How to Convert Json to Datatable in c#

Question

[{ 'TypeId' : '1' , 'TypeName' : 'Wastage not collected' },{ 'TypeId' : '2' , 'TypeName' : 'Drainage not cleaned' },{ 'TypeId' : '3' , 'TypeName' : 'Dispose dead animal' },{ 'TypeId' : '4' , 'TypeName' : 'Sweeper Misbehaviour' },{ 'TypeId' : '5' , 'TypeName' : 'Water supply issue' },{ 'TypeId' : '6' , 'TypeName' : 'Wastage burning issue' },{ 'TypeId' : '7' , 'TypeName' : 'Others' }] How to convert JSON Data to Datatable using C# of web application without putting into the text document? If there's a solution please let me know it..

Vivek Kumar · Answer

Hi Sourav, Please have a look to below links for your reference. https://stackoverflow.com/questions/11981282/convert-json-to-datatable https://www.codeproject.com/Tips/1084643/Convert-JSON-To-DataTable-Csharp

Puneet Kankar · Answer

Please check below links. https://www.c-sharpcorner.com/blogs/convert-json-string-to-datatable-in-asp-net1 https://www.codeproject.com/Tips/1084643/Convert-JSON-To-DataTable-Csharp

Gowtham Ramar · Answer

First convert json to list object using newton soft reference List UserList = JsonConvert.DeserializeObject >(jsonString); add the below method your project public static DataTable ToDataTable (this IList data) { PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T)); DataTable table = new DataTable(); for(int i = 0 ; i PropertyDescriptor prop = props[i]; table.Columns.Add(prop.Name, prop.PropertyType); } object[] values = new object[props.Count]; foreach (T item in data) { for (int i = 0; i values[i] = props[i].GetValue(item); } table.Rows.Add(values); } return table; } after that call the method UserList.ToDataTable ();

Varnaparan D · Answer

.

Salman Beg · Answer

Hi. You can follow these links, https://www.c-sharpcorner.com/blogs/convert-json-string-to-datatable-in-asp-net1 http://www.technothirsty.com/4-ways-to-convert-json-to-datatable-csharp-asp-net/ Thanks.

How to Convert Json to Datatable in c#

Answers (5)