/// <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 + "}");
}
