publicstaticstringToJson(DataTabledt)

{

StringBuilderjsonString = newStringBuilder();

jsonString.Append("[");

DataRowCollectiondrc = dt.Rows;

for (inti = 0; i<drc.Count; i++)

{

jsonString.Append("{");

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

{

stringstrKey = dt.Columns[j].ColumnName;

stringstrValue = drc[i][j].ToString();

Type type = dt.Columns[j].DataType;

jsonString.Append("\"" + strKey + "\":");

strValue = StringFormat(strValue, type);

if (j <dt.Columns.Count - 1)

{

jsonString.Append(strValue + ",");

}

else

{

jsonString.Append(strValue);

}

}

jsonString.Append("},");

}

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

jsonString.Append("]");

returnjsonString.ToString();

}

///<summary>

///DataTable转成Json

///</summary>

///<param name="jsonName"></param>

///<param name="dt"></param>

///<returns></returns>

publicstaticstringToJson(DataTabledt, stringjsonName)

{

StringBuilderJson = newStringBuilder();

if (string.IsNullOrEmpty(jsonName))

jsonName = dt.TableName;

Json.Append("{\"" + jsonName + "\":[");

if (dt.Rows.Count>0)