convert table to json

Question

static public string table2Json(DataSet ds, int table_no) { try { // Given a Dataset & Table NO , function returns a 2 dim JSON Array of values in that table int rcnt = ds.Tables[table_no].Rows.Count; // Row Count int ccnt = ds.Tables[table_no].Columns.Count; // Col Count object [][] tb = new object [rcnt][]; int r = 0; foreach (DataRow dr in ds.Tables[table_no].Rows) { tb[r] = new object [ccnt]; for ( int col = 0; col { tb[r][col] = dr[col]; if ((tb[r][col]).Equals(System.DBNull.Value)) tb[r][col] = "" ; } r++; } var table= JsonConvert.SerializeObject(tb); return table; } I have some code for convert table to json string i want to remove for loo from these code how does it is possible

Mageshwaran R · Answer

Hi, Try this code: public string ConvertDataTabletoString() { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection( "Data Source=SureshDasari;Initial Catalog=master;Integrated Security=true" )) { using (SqlCommand cmd = new SqlCommand( "select title=City,lat=latitude,lng=longitude,description from LocationDetails" , con)) { con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List string , object >> rows = new List string , object >>(); Dictionary string , object > row; foreach (DataRow dr in dt.Rows) { row = new Dictionary string , object >(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } return serializer.Serialize(rows); } } }

Amit Mohanty · Answer

Then try this public static object DataSetToJSON(DataSet ds) { ArrayList root = new ArrayList(); List string , object >> table; Dictionary string , object > data; foreach (DataTable dt in ds.Tables) { table = new List string , object >>(); foreach (DataRow dr in dt.Rows) { data = new Dictionary string , object >(); foreach (DataColumn col in dt.Columns) { data.Add(col.ColumnName, dr[col]); } table.Add(data); } root.Add(table); } JavaScriptSerializer serializer = new JavaScriptSerializer { MaxJsonLength = Int32.MaxValue }; return serializer.Serialize(root); }

Sanjay gautam · Answer

hi Amit Mohanty sir this is not perfect salution. I have data set which contain number of table and table no also

Amit Mohanty · Answer

Hey try this public static object DataTableToJSON(DataTable table) { var list = new List string , object >>(); foreach (DataRow row in table.Rows) { var dict = new Dictionary string , object >(); foreach (DataColumn col in table.Columns) { dict[col.ColumnName] = (Convert.ToString(row[col])); } list.Add(dict); } JavaScriptSerializer serializer = new JavaScriptSerializer { MaxJsonLength = Int32.MaxValue }; return serializer.Serialize(list); }

convert table to json

Answers (4)