converting json data to datatable with only specific fields

i have json data like this...Need to create data table only with selected fields....

[{"taskid":"12","description":{"leaddata":{"UserId":"","UserName":"8860300036","FirstName":"sushma test ","LastName":"","DOB":"1983-06-08T00:00:00M000","MobileNumber":"8860300036","Language":"5","Gender":"200001","State":"40","PhotoPath":null,"City":null,"Address":"279\/28","District":"248","Email":"[email protected]","FacebookId":"","serviceType":"book now","altMobile":"0000000001","pincode":"546458464","preferredDate":"02\/18\/2016","preferredTime":"10:30 PM","serviceId":"BN1455377555265"}},"status":"Success","errormsg":"None"},{"taskid":"13","description":{"leaddata":{"UserId":"","UserName":"8860300036","FirstName":"sushma test ","LastName":"Sushma","DOB":"1983-06-08T00:00:00M000","MobileNumber":"8860300036","Language":"5","Gender":"200001","State":"40","PhotoPath":null,"City":null,"Address":"279\/28","District":"248","Email":"[email protected]","FacebookId":"","serviceType":"book now","altMobile":"0000000001","pincode":"546458464","preferredDate":"02\/18\/2016","preferredTime":"10:30:00 AM","serviceId":"BN1455377555265"}},"status":"Success","errormsg":"None"}]

How to do It

Check the below links

http://www.c-sharpcorner.com/blogs/convert-json-string-to-datatable-in-asp-net1

http://stackoverflow.com/questions/11981282/convert-json-to-datatable

https://weblog.west-wind.com/posts/2008/sep/03/datatable-json-serialization-in-jsonnet-and-javascriptserializer

Now use linq to get specific column

check the link

http://stackoverflow.com/questions/13760072/select-certain-columns-off-a-data-table

http://stackoverflow.com/questions/25505738/how-to-get-a-specific-column-value-from-a-datatable-in-c-sharp

http://www.codeproject.com/Questions/648826/how-to-get-column-values-by-specific-column-name-f

https://www.mindstick.com/Forum/274/how-to-get-records-of-specific-columns-of-data-table-using-c-sharp

1 Reply

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

Vinay Singh10y ago
Hi
Check the below links
http://www.c-sharpcorner.com/blogs/convert-json-string-to-datatable-in-asp-net1
http://stackoverflow.com/questions/11981282/convert-json-to-datatable
https://weblog.west-wind.com/posts/2008/sep/03/datatable-json-serialization-in-jsonnet-and-javascriptserializer
Now use linq to get specific column
check the link
http://stackoverflow.com/questions/13760072/select-certain-columns-off-a-data-table
http://stackoverflow.com/questions/25505738/how-to-get-a-specific-column-value-from-a-datatable-in-c-sharp
http://www.codeproject.com/Questions/648826/how-to-get-column-values-by-specific-column-name-f
https://www.mindstick.com/Forum/274/how-to-get-records-of-specific-columns-of-data-table-using-c-sharp