// 将DataSet转化成JSON数据
public static string DataSetToJson(DataSet ds)
{
StringBuilder sb = new StringBuilder();
try
{
if (ds.Tables.Count == 0)
throw new Exception("DataSet中Tables为0");
for (int i = 0; i < ds.Tables.Count; i++)
{
sb.Append("\"T" + (i + 1) + "\":[");
for (int j = 0; j < ds.Tables[i].Rows.Count; j++)
{
sb.Append("{");
for (int k = 0; k < ds.Tables[i].Columns.Count; k++)
{
sb.Append("\"" + ds.Tables[i].Columns[k].ColumnName + "\":\"" + ds.Tables[i].Rows[j][k].ToString() + "\"");
if (k != ds.Tables[i].Columns.Count - 1)
sb.Append(",");
}
sb.Append("}");
if (j != ds.Tables[i].Rows.Count - 1)
sb.Append(",");
}
sb.Append("]");
if (i != ds.Tables.Count - 1)
sb.Append(",");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return sb.ToString();
}
public static string DataSetToJson(DataSet ds)
{
StringBuilder sb = new StringBuilder();
try
{
if (ds.Tables.Count == 0)
throw new Exception("DataSet中Tables为0");
for (int i = 0; i < ds.Tables.Count; i++)
{
sb.Append("\"T" + (i + 1) + "\":[");
for (int j = 0; j < ds.Tables[i].Rows.Count; j++)
{
sb.Append("{");
for (int k = 0; k < ds.Tables[i].Columns.Count; k++)
{
sb.Append("\"" + ds.Tables[i].Columns[k].ColumnName + "\":\"" + ds.Tables[i].Rows[j][k].ToString() + "\"");
if (k != ds.Tables[i].Columns.Count - 1)
sb.Append(",");
}
sb.Append("}");
if (j != ds.Tables[i].Rows.Count - 1)
sb.Append(",");
}
sb.Append("]");
if (i != ds.Tables.Count - 1)
sb.Append(",");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return sb.ToString();
}