How to convert a multi dimensional array into json format in C# asp.net? [closed]

Question

I have created a multidimenssional array.. which stores multiple rows from my database table..

 SqlDataAdapter da = new SqlDataAdapter("select  * from question_bank_details  where question_num  in (select top 2 question_num  from question_bank_details order by newid())", con5);
 DataTable data_table = new DataTable();
 DataList data_list = new DataList();
 da.Fill(data_table);

 string[,] array_questions = new string[dt.Rows.Count,dt.Columns.Count];

 for (int i = 0; i <dt.Rows.Count; i++)
 {
      for (int j = 0; j < dt.Columns.Count; j++)
      {
           array_questions[i, j] = dt.Rows[i][j].ToString();

      }
 }
 data_list.DataSource = data_table;
 data_list.DataBind();

now I need to convert this multi dimenssional array into JSON format.please help

Satpal · Accepted Answer · 2013-06-04 05:30:18Z

4

You can use Json.NET 4.0, It is also available in Nuget

string output = JsonConvert.SerializeObject(array_questions);

answered Jun 4, 2013 at 5:30

Satpal

134k13 gold badges168 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chris Over a year ago

I just used JSON.NET for dotnet 4.0 for my project, and I can say it worked -perfectly- I suggest this answer.

Community · Accepted Answer · 2017-05-23 11:59:17Z

0

Use this

JavaScriptSerializer js = new JavaScriptSerializer();
string json = js.Serialize(array_questions);

Source :How do I convert a c# two-dimensional array to a JSON object?

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Jun 4, 2013 at 5:37

Sain Pradeep

3,1351 gold badge24 silver badges34 bronze badges

1 Comment

user2431727 Over a year ago

thankyou..but when sending the data, it is received as a very long single line ..how can i transfer it row wise?

SeeSharp · Accepted Answer · 2013-06-04 05:34:16Z

0

this example is basically converting javascript to json....hope you might get some idea from this you need to use an open-source json parser and stringfier check at http://www.json.org/

https://github.com/douglascrockford/JSON-js/blob/master/json2.js after then you have to include the code and use the JSON.stringify() method on your array.

answered Jun 4, 2013 at 5:34

SeeSharp

1791 gold badge4 silver badges12 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:15:34Z

0

var serializer = new JavaScriptSerializer();
serializer.Serialize(array_questions); // This will serialize array to JSON string.

If you want to deserialize from JScript, use

JSON.Parse(array_questions);

Please refer this one also for JScript deserilazation How to return a HashTable from a WebService?

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jun 4, 2013 at 5:47

mlg

1,1911 gold badge14 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to convert a multi dimensional array into json format in C# asp.net? [closed]

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Linked

Related