c# - Newtonsoft.Json JsonConvert To Datatable

Question

I have a code like this,

DataTable dt = new DataTable();

string data = "{"ProductId":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77],"ProductName":["Chai","Chang","Aniseed Syrup","Chef Anton's Cajun Seasoning","Chef Anton's Gumbo Mix","Grandma's Boysenberry Spread","Uncle Bob's Organic Dried Pears","Northwoods Cranberry Sauce","Mishi Kobe Niku","Ikura","Queso Cabrales","Queso Manchego La Pastora","Konbu","Tofu","Genen Shouyu","Pavlova","Alice Mutton","Carnarvon Tigers","Teatime Chocolate Biscuits","Sir Rodney's Marmalade","Sir Rodney's Scones","Gustaf's Kn?¤ckebr??d","Tunnbr??d","Guaran?? Fant??stica","NuNuCa Nu??-Nougat-Creme","Gumb?¤r Gummib?¤rchen","Schoggi Schokolade","R??ssle Sauerkraut","Th??ringer Rostbratwurst","Nord-Ost Matjeshering","Gorgonzola Telino","Mascarpone Fabioli","Geitost","Sasquatch Ale","Steeleye Stout","Inlagd Sill","Gravad lax","C?′te de Blaye","Chartreuse verte","Boston Crab Meat","Jack's New England Clam Chowder","Singaporean Hokkien Fried Mee","Ipoh Coffee","Gula Malacca","Rogede sild","Spegesild","Zaanse koeken","Chocolade","Maxilaku","Valkoinen suklaa","Manjimup Dried Apples","Filo Mix","Perth Pasties","Tourti?¨re","P?￠t?? chinois","Gnocchi di nonna Alice","Ravioli Angelo","Escargots de Bourgogne","Raclette Courdavault","Camembert Pierrot","Sirop d'??rable","Tarte au sucre","Vegie-spread","Wimmers gute Semmelkn??del","Louisiana Fiery Hot Pepper Sauce","Louisiana Hot Spiced Okra","Laughing Lumberjack Lager","Scottish Longbreads","Gudbrandsdalsost","Outback Lager","Flotemysost","Mozzarella di Giovanni","R??d Kaviar","Longlife Tofu","Rh??nbr?¤u Klosterbier","Lakkalik????ri","Original Frankfurter gr??ne So??e"]}";

dt = JsonConvert.DeserializeObject<DataTable>(data);

If I run this data on online json editor as remove char, it's showing. But in Visual Studio, there is an error,

Unexpected JSON token when reading DataTable. Expected StartArray, got StartObject. Path '', line 1, position 1.

on last code place.

I want to, convert data to DataTable using Newtonsoft plugin. How can i solve this problem? Thanks.

Answer 1

Your json must be an array of objects to be converted to a DataTable, it must start like this :

"[{"ProductId..........

end ends like this:

....,"fieldName":Value}]"