java dataset json_DataSet转换成Json格式

///

/// DataSet转换成Json格式

///

/// DataSet

///

public static string DatasetToJson(DataSet ds, int total = -1)

{

StringBuilder json = new StringBuilder();

foreach (DataTable dt in ds.Tables)

{

//{"total":5,"rows":[

json.Append("{\"total\":");

if (total == -1)

{

json.Append(dt.Rows.Count);

}

else

{

json.Append(total);

}

json.Append(",\"rows\":[");

json.Append(DataTableToJson(dt));

json.Append("]}");

}

return json.ToString();

}

///

/// dataTable转换成Json格式

///

///

///

public static string DataTableToJson(DataTable dt)

{

StringBuilder jsonBuilder = new StringBuilder();

for (int i = 0; i < dt.Rows.Count; i++)

{

jsonBuilder.Append("{");

for (int j = 0; j < dt.Columns.Count; j++)

{

jsonBuilder.Append("\"");

jsonBuilder.Append(dt.Columns[j].ColumnName);

jsonBuilder.Append("\":\"");

jsonBuilder.Append(dt.Rows[i][j].ToString());

jsonBuilder.Append("\",");

}

if (dt.Columns.Count > 0)

{

jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

}

jsonBuilder.Append("},");

}

if (dt.Rows.Count > 0)

{

jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

}

return jsonBuilder.ToString();

}