converting json data to datatable with only specific fields

Question

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

Vinay Singh · Answer

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