/// <summary> /// DataTable转换成json(支持字段名大小写选项) /// </summary> /// <param name="dt"></param> /// <param name="LetterCase">字段名大小选项,默认原状态</param> /// <returns></returns> public static string DataTableToJson(DataTable dt, ColumnNameLetterCase LetterCase = ColumnNameLetterCase.Original) { JavaScriptSerializer json = new JavaScriptSerializer(); json.MaxJsonLength = Int32.MaxValue; //取得最大数值 ArrayList arrayList = new ArrayList(); foreach (DataRow dataRow in dt.Rows) { Dictionary <string, object> dictionary = new Dictionary <string, object>(); //实例化一个参数集合 foreach (DataColumn dataColumn in dt.Columns) { string ColumnName = ""; switch (LetterCase) { case ColumnNameLetterCase.Original: ColumnName = dataColumn.ColumnName; break; case ColumnNameLetterCase.ToLower: ColumnName = dataColumn.ColumnName.ToLower(); break; case ColumnNameLetterCase.ToUpper: ColumnName = dataColumn.ColumnName.ToUpper(); break; } dictionary.Add(ColumnName, dataRow[dataColumn.ColumnName].ToString()); } arrayList.Add(dictionary); //ArrayList集合中添加键值 } return(json.Serialize(arrayList)); //返回一个json字符串 }
/// <summary> /// DataSet转换为Json /// </summary> /// <param name="dataSet">DataSet对象</param> /// <returns>Json字符串</returns> public static string DataSetToJson(DataSet dataSet, ColumnNameLetterCase LetterCase = ColumnNameLetterCase.Original) { string jsonString = "{"; foreach (DataTable table in dataSet.Tables) { jsonString += "\"" + table.TableName + "\":" + DataTableToJson(table, LetterCase) + ","; } jsonString = jsonString.TrimEnd(','); return(jsonString + "}"); }