Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How to create a json string like this in C#:

{ "aaData": [
["Trident","Internet Explorer 4.0","Win 95+","4","X"],
["Trident","Internet Explorer 5.0","Win 95+","5","C"],
["Trident","Internet Explorer 5.5","Win 95+","5.5","A"]]}
Posted
Comments
Mehdi Gholam 1-May-14 3:53am    
how to create a string or an object representing the string?

you can try with Json.Net. Sample console application code:

C#
using System.Collections.Generic;
using Newtonsoft.Json;

namespace ConsoleApplication11
{
    class Program
    {
        static void Main(string[] args)
        {
            MyData data = new MyData()
            {
                aaData = new List<list><string>>()
                { 
                    new List<string>(){"Trident","Internet Explorer 4.0","Win 95+","4","X"},
                    new List<string>(){"Trident","Internet Explorer 5.0","Win 95+","5","C"},
                    new List<string>(){"Trident","Internet Explorer 5.5","Win 95+","5.5","A"}}
                };

            string json = JsonConvert.SerializeObject(data);

            //{"aaData":[["Trident","Internet Explorer 4.0","Win 95+","4","X"],["Trident","Internet Explorer 5.0","Win 95+","5","C"],["Trident","Internet Explorer 5.5","Win 95+","5.5","A"]]}

        }
    }

    public class MyData
    {
        public List<list><string>> aaData { get; set; }
    }
}
 
Share this answer
 
v2
Take reference from the below links:

Create-JSON-from-C-using-JSON-Library
how-to-create-json-string-in-c-sharp

Hope it helps :)
 
Share this answer
 
Use the String.Format method, or a StringBuilder object.
 
Share this answer
 
You can create a logic from this :::

public string CreateJsonParameters()
{
SOUCC.App_Code.ReportClass objReportClass = new SOUCC.App_Code.ReportClass();
DataTable dt = new DataTable();

dt = objReportClass.SOUCC_GetCampaignRegistration();

StringBuilder JsonString = new StringBuilder();

//Exception Handling
if (dt != null && dt.Rows.Count > 0)
{
JsonString.Append("{ ");
JsonString.Append("\"" + dt.TableName + "\":[ ");

for (int i = 0; i < dt.Rows.Count; i++)
{
JsonString.Append("{ ");
for (int j = 0; j < dt.Columns.Count; j++)
{
if (j < dt.Columns.Count - 1)
{
if (dt.Columns[j].ColumnName.ToString() == "Que1")
{
JsonString.Append("\"" + "questions" + "\":[ ");
}

if (dt.Columns[j].ColumnName.ToString() == "Que1" ||
dt.Columns[j].ColumnName.ToString() == "Que2" ||
dt.Columns[j].ColumnName.ToString() == "Que3" ||
dt.Columns[j].ColumnName.ToString() == "Que4" ||
dt.Columns[j].ColumnName.ToString() == "Que5" ||
dt.Columns[j].ColumnName.ToString() == "Que6" ||
dt.Columns[j].ColumnName.ToString() == "Que7" ||
dt.Columns[j].ColumnName.ToString() == "Que8" ||
dt.Columns[j].ColumnName.ToString() == "Que9" ||
dt.Columns[j].ColumnName.ToString() == "Que10" ||
dt.Columns[j].ColumnName.ToString() == "Que11" ||
dt.Columns[j].ColumnName.ToString() == "Que12" ||
dt.Columns[j].ColumnName.ToString() == "Que13" ||
dt.Columns[j].ColumnName.ToString() == "Que14" ||
dt.Columns[j].ColumnName.ToString() == "Que15" ||
dt.Columns[j].ColumnName.ToString() == "Que16" ||
dt.Columns[j].ColumnName.ToString() == "Que17" ||
dt.Columns[j].ColumnName.ToString() == "Que18" ||
dt.Columns[j].ColumnName.ToString() == "Que19" ||
dt.Columns[j].ColumnName.ToString() == "Que20"
)
{

JsonString.Append("{\"" + dt.Columns[j].ColumnName.ToString() +
"\":" + "\"" +
dt.Rows[i][j].ToString() + "\",");

if (dt.Columns[j + 1].ColumnName.ToString() == "Ans1" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans2" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans3" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans4" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans5" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans6" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans7" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans8" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans9" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans10" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans11" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans12" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans13" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans14" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans15" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans16" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans17" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans18" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans19" ||
dt.Columns[j + 1].ColumnName.ToString() == "Ans20"
)
{
JsonString.Append("\"" + dt.Columns[j + 1].ColumnName.ToString() +
"\":" + "\"" +
dt.Rows[i][j + 1].ToString() + "\",");

JsonString.Append("}, ");

if (dt.Columns[j + 1].ColumnName.ToString() == "Ans20") // For Last Question
{
JsonString.Append("]");
}
}
}
else
{
if (dt.Columns[j].ColumnName.ToString() == "Ans1" ||
dt.Columns[j].ColumnName.ToString() == "Ans2" ||
dt.Columns[j].ColumnName.ToString() == "Ans3" ||
dt.Columns[j].ColumnName.ToString() == "Ans4" ||
dt.Columns[j].ColumnName.ToString() == "Ans5" ||
dt.Columns[j].ColumnName.ToString() == "Ans6" ||
dt.Columns[j].ColumnName.ToString() == "Ans7" ||
dt.Columns[j].ColumnName.ToString() == "Ans8" ||
dt.Columns[j].ColumnName.ToString() == "Ans9" ||
dt.Columns[j].ColumnName.ToString() == "Ans10" ||
dt.Columns[j].ColumnName.ToString() == "Ans11" ||
dt.Columns[j].ColumnName.ToString() == "Ans12" ||
dt.Columns[j].ColumnName.ToString() == "Ans13" ||
dt.Columns[j].ColumnName.ToString() == "Ans14" ||
dt.Columns[j].ColumnName.ToString() == "Ans15" ||
dt.Columns[j].ColumnName.ToString() == "Ans16" ||
dt.Columns[j].ColumnName.ToString() == "Ans17" ||
dt.Columns[j].ColumnName.ToString() == "Ans18" ||
dt.Columns[j].ColumnName.ToString() == "Ans19" ||
dt.Columns[j].ColumnName.ToString() == "Ans20")
{
//JsonString.Replace("Ans1", null);
}
else
{
JsonString.Append("\"" + dt.Columns[j].ColumnName.ToString() +
"\":" + "\"" +
dt.Rows[i][j].ToString() + "\",");
}
}
}
else if (j == dt.Columns.Count - 1)
{
// For Last Question
if (dt.Columns[j].ColumnName.ToString() == "Ans20")
{

}
else
{
JsonString.Append("\"" +
dt.Columns[j].ColumnName.ToString() + "\":" +
"\"" + dt.Rows[i][j].ToString() + "\"");
}

}
}

/*end Of String*/
if (i == dt.Rows.Count - 1)
{
JsonString.Append("} ");
}
else
{
JsonString.Append("}, ");
}
}

JsonString.Append("]}");
return JsonString.ToString();
}
else
{
return null;
}
}
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900