JsonParserMultiple 1.0.0

JsonParserMultiple

Convert Json to DataTable without any model or class
Get the result immediately in a DataTable
Create models or classes for convert json in .NET

You can find the sample project in GitHub
This is a simple way to parse your Json result to DataTable.
Instruction of use Json parser multiple :

Just follow these simple steps to use JsonParser

• download JsonParserMultiple DLL
• Use below samples code.

Just run this sample code to parse Json to DataTable after download the DLL :\

JsonObject

Simple Example :

string JsonStr = "{\"id\":\"1\",\"name\":\"Jack\",\"age\":\"36\"}";
JsonParser.JParser JP = new JsonParser.JParser();
DataTable dt = JP.JsonConvert(JsonStr);

JsonArray

Example 1 :

string JsonStr = "[{\"id\":\"1\",\"name\":\"Jack\",\"age\":\"36\"}
                  ,{\"id\":\"2\",\"name\":\"Janatan\",\"age\":\"30\"}
                  ,{\"id\":\"3\",\"name\":\"Natasha\",\"age\":\"32\"}]";
JsonParser.JParser JP = new JsonParser.JParser();
DataTable dt = JP.JsonConvert(JsonStr);

Example 2 :

It may that our JsonArray have different values in their jsonobjects.
For example :

string JsonStr = "[{\"id\":\"1\",\"name\":\"Jack\",\"age\":\"36\"}
                  ,{\"id\":\"2\",\"name\":\"Janatan\",\"age\":\"30\"}
                  ,{\"id\":\"3\",\"name\":\"Natasha\",\"zipcode\":\"5896472358\"}]";
JsonParser.JParser JP = new JsonParser.JParser();
DataTable dt = JP.JsonConvert(JsonStr);

We have age in first and second jsonobjects, but in third one we have zipcode instead of age.
Consequently in two first row we have zipcode with empty value and in third row we have empty value for age column and this value '5896472358' for zipcode column.
Like below table :

Object In Object

Sometimes one of our value consists a JsonObject even a JsonArray. we can use JsonParser for value of that column specifically

Example 1 :

string JsonStr = "{\"id\":\"1\",\"product\":\"TV\",\"number\":\"1\"
                  ,\"extrainfo\":{\"product_id\":\"157895004\",\"product_serial\":\"8874500\",\"product_model\":\"M23TU\"}}";

JsonParser.JParser JP = new JsonParser.JParser();
DataTable dt = JP.JsonConvert(JsonStr);

In this JsonObject that concern to a sale order, extrainfo include of another JsonObject.
If you need extrainfo values like ' product_id , product_serial , ... ' you must pass value of extrainfo column to JsonConvert.
The result is like this below table in first step of convert.

In the next step I pass value of extrainfo column to JsonConvert and get values.
Pass value like below code

DataTable dt_extrainfo = JP.JsonConvert(dt.Rows[0]["extrainfo"]);

Note: You can use loop (for , while...) for convert another rows simply

DataTable dt_extrainfo;
for (int i = 0; i < dt.Rows.Count; i++)
{
    dt_extrainfo = new DataTable();
    dt_extrainfo = JP.JsonConvert(dt.Rows[i]["extrainfo"].ToString());
}