DataTable to json(DataTable 转换为json数据)
1 public static string DataTableToJSON(DataTable table) 2 { 3 List<Dictionary<string, object>> list = new List<Dictionary<string, object>>(); 4 5 foreach (DataRow row in table.Rows) 6 { 7 Dictionary<string, object> dict = new Dictionary<string, object>(); 8 9 foreach (DataColumn col in table.Columns) 10 { 11 dict[col.ColumnName] = row[col]; 12 } 13 list.Add(dict); 14 } 15 JavaScriptSerializer serializer = new JavaScriptSerializer(); 16 return serializer.Serialize(list); 17 }
(DataTable 转换为json数据)
ReadToJson
1 public string ReadToJson(SqlDataReader reader) 2 { 3 List<string> cols = new List<string>(10); 4 int ncols = reader.FieldCount; 5 for (int i = 0; i < ncols; ++i) 6 { 7 cols.Add(reader.GetName(i)); 8 } 9 StringBuilder sbJson = new StringBuilder("["); 10 //process each row 11 while (reader.Read()) 12 { 13 sbJson.Append("{"); 14 foreach (string col in cols) 15 { 16 sbJson.AppendFormat("\"{0}\":{1}, ", col, reader[col]); 17 } 18 sbJson.Replace(", ", "},", sbJson.Length - 2, 2); 19 } 20 sbJson.Replace("},", "}]", sbJson.Length - 2, 2); 21 return sbJson.ToString(); 22 }