Loading

How to Convert Json to Datatable in c#

How to Convert Json to Datatable in c#

Sourav Kumar Das

Sourav Kumar Das

7y24.5kLearn iOS Programming

[{"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..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varnaparan D7y ago
.
Vivek Kumar7y ago
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
Salman Beg7y ago
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.
Puneet Kankar7y ago
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 Ramar7y ago
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 < props.Count ; 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.Length; i++) {
values[i] = props[i].GetValue(item);
}
table.Rows.Add(values);
}
return table;
}

after that call the method

UserList.ToDataTable();