Convert JSON as String to DataTable in C#

Question

I have pass the JSON value as String & in C# need to convert to DataTable.

I have done in android part,(making a json as String)

  public void getUploadTableData(){
    DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(this);
    dbAdapter.openDataBase();
    try {
        if(uploadTable.size() > 0){
            for (Map.Entry<Integer, String> entry : uploadTable.entrySet()) {
                int key = entry.getKey();
                String value = entry.getValue();

                JSONObject invHeader = new JSONObject();

                if(value.equals("WMInvoiceHeader")){
                     String query = "SELECT BusinessUnit,ExecutiveCode,InvoiceNo,SalesCategory,RetailerCode," +
                                    " RetailerCodeSon,InvoiceDate,GrossValue,InvoiceValue,TotalLineDiscount," +
                                    " FROM WMInvoiceHeader " +
                                    " WHERE (CancelFlag IS NULL OR CancelFlag ='0')";
                     ArrayList<?> stringList = dbAdapter.selectRecordsFromDBList(query, null);
                     if(stringList.size() > 0){
                            for (int i = 0; i < stringList.size(); i++) {
                                ArrayList<?> arrayList = (ArrayList<?>) stringList.get(i);
                                ArrayList<?> list = arrayList;

                                invHeader.put("BusinessUnit",(String)list.get(0));
                                invHeader.put("ExecutiveCode",(String)list.get(1));
                                invHeader.put("InvoiceNo",(String)list.get(2));
                                invHeader.put("SalesCategory",(String)list.get(3));
                                invHeader.put("RetailerCode",(String)list.get(4));
                                invHeader.put("RetailerCodeSon",(String)list.get(5));
                                invHeader.put("InvoiceDate",(String)list.get(6));
                                invHeader.put("GrossValue",(String)list.get(7));
                                invHeader.put("InvoiceValue",(String)list.get(8));
                                invHeader.put("TotalLineDiscount",(String)list.get(9));


                            }
                            System.out.println("----invHeader---" + invHeader.toString());
                     }
                     soapPrimitiveData("WMInvoiceHeader", strBusinessUnit, strExecutive, invHeader.toString());
                }

            //  System.out.println("----invHeader---" + invHeader.toString());
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

This is my webservice part....

// ksoap2 calling wcf
public SoapPrimitive soapPrimitiveData(String tablename,String strBusinessUnit, String strExecutive,String jsonString) throws IOException,XmlPullParserException {
    SoapPrimitive responsesData = null;
    SoapObject requestData = new SoapObject(NAMESPACE, METHOD_NAME); // set

    requestData.addProperty("strBusinessUnit", strBusinessUnit);
    requestData.addProperty("strExecutive", strExecutive);
    requestData.addProperty("strTableName", tablename);
    requestData.addProperty("jsonContent", jsonString);
    SoapSerializationEnvelope envelopes = new SoapSerializationEnvelope(SoapEnvelope.VER11); // put all required data into a soap//// envelope
    envelopes.dotNet = true;
    envelopes.setOutputSoapObject(requestData);
    AndroidHttpTransport httpTransport = new AndroidHttpTransport(APPURL);
    httpTransport.debug = true;


    try {
        httpTransport.call(SOAP_ACTION, envelopes);
        responsesData = (SoapPrimitive) envelopes.getResponse();


    } catch (SocketException ex) {
        Log.e("Error : " , "Error on soapPrimitiveData() " + ex.getMessage());
        ex.printStackTrace();
    } catch (Exception e) {
        Log.e("Error : " , "Error on soapPrimitiveData() " + e.getMessage());
       e.printStackTrace();
    }
    return responsesData;
}

This is my C# code

    public bool convertJSONToDataSet(string strBusinessUnit, string strExecutiveCode, string strTableName, string jsonContent)
    {
        bool status =false;

        DataTable dataTable = JsonConvert.DeserializeObject<DataTable>(jsonContent);
        status  = UpdateUploadData(strBusinessUnit, strExecutiveCode, strTableName, dataTable);
        return status;
    }

When i call webservice this method conversion part giving error .It say Additional text found in JSON string after finishing deserializing object.

This is my json result in C#

{
"SpecialDiscountFlag": "0",
"TotalLineDiscount": "0",
"ExecutiveCode": "TEST001",
"InvoiceValue": "3000",
"InvoiceDate": "2011-11-17",
"RouteCode": "VRT002",
"RetailerCode": "TEST0007",
"HeaderDiscountFlag": "1",
"GrossValue": "3000",
"UploadedOn": "2011-11-17",
"SalesType": "O",
"VisitNumber": "26",
"UploadFlag": "1",
"InvoiceNo": "26",
"SalesCategory": "VSAO",
"BusinessUnit": "MASS",
"VisitSequence": "1",
"UploadedBy": "TEST001",
"TotalHeaderDiscount": "0"
}

Please tell me what is wrong here.

I want to do the Convert JSON as String to DataTable in C#

Answer 1

Json string should be like below:

{
    "List": [
        {
            "ProjectId": 504,
            "RowId": 1,
            "ProjectName": "Google",
            "Member": "Private"
        },
        {
            "ProjectId": 503,
            "RowId": 2,
            "ProjectName": "Facebook",
            "Member": "Public"
        }
    ]
}

Where "List" treated as your table name and data inside curly brackets treated as row for DataTable
To validate json string you can use this site: http://jsonlint.com/