/// <summary>
/// 将datatble转换成json字符串
/// </summary>
/// <param name="dtb"></param>
/// <returns></returns>
public string DataTableToJson(DataTable dtb)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
ArrayList dic = new ArrayList();
try
{
foreach (DataRow dr in dtb.Rows)
{
System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
foreach (DataColumn dc in dtb.Columns)
{
drow.Add(dc.ColumnName, dr[dc.ColumnName] + "");
}
dic.Add(drow);
}
}
catch (Exception ex)
{
return "系统错误!" + ex;
}
//序列化
return jss.Serialize(dic);
}
/// 将datatble转换成json字符串
/// </summary>
/// <param name="dtb"></param>
/// <returns></returns>
public string DataTableToJson(DataTable dtb)
{
JavaScriptSerializer jss = new JavaScriptSerializer();
ArrayList dic = new ArrayList();
try
{
foreach (DataRow dr in dtb.Rows)
{
System.Collections.Generic.Dictionary<string, object> drow = new System.Collections.Generic.Dictionary<string, object>();
foreach (DataColumn dc in dtb.Columns)
{
drow.Add(dc.ColumnName, dr[dc.ColumnName] + "");
}
dic.Add(drow);
}
}
catch (Exception ex)
{
return "系统错误!" + ex;
}
//序列化
return jss.Serialize(dic);
}