/// <summary> /// requested this through an ajax call, you can call a => [{name:{name1:"ab",name2:"cd"},id:9}] /// var jsondatastructure = eval (yourResponseText); /// </summary> public string makejsonoftable(DataTable table, makejson e) { StringBuilder sb = new StringBuilder(); foreach (DataRow dr in table.Rows) { if (sb.Length != 0) sb.Append(","); sb.Append("{"); StringBuilder sb2 = new StringBuilder(); foreach (DataColumn col in table.Columns) { string fieldname = col.ColumnName; string fieldvalue = dr[fieldname].ToString(); if (sb2.Length != 0) sb2.Append(","); sb2.Append(string.Format("\"{0}\":\"{1}\"", fieldname, fieldvalue)); } sb.Append(sb2.ToString()); sb.Append("}"); } if (e == makejson.e_with_square_brackets) { sb.Insert(0, "["); sb.Append("]"); } return sb.ToString(); }
/// <summary> /// requested this through an ajax call, you can call a => [{name:{name1:"ab",name2:"cd"},id:9}] /// var jsondatastructure = eval (yourResponseText); /// </summary> public string makejsonoftable(DataTable table, makejson e) { StringBuilder sb = new StringBuilder(); foreach (DataRow dr in table.Rows) { if (sb.Length != 0) { sb.Append(","); } sb.Append("{"); StringBuilder sb2 = new StringBuilder(); foreach (DataColumn col in table.Columns) { string fieldname = col.ColumnName; string fieldvalue = dr[fieldname].ToString(); if (sb2.Length != 0) { sb2.Append(","); } sb2.Append(string.Format("\"{0}\":\"{1}\"", fieldname, fieldvalue)); } sb.Append(sb2.ToString()); sb.Append("}"); } if (e == makejson.e_with_square_brackets) { sb.Insert(0, "["); sb.Append("]"); } return(sb.ToString()); }