{

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

{

Json.Append("{");

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

{

Type type = dt.Rows[i][j].GetType();

Json.Append("\"" + dt.Columns[j].ColumnName.ToString() + "\":" + StringFormat(dt.Rows[i][j].ToString(), type));

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

{

Json.Append(",");

}

}

Json.Append("}");

if (i<dt.Rows.Count - 1)

{

Json.Append(",");

}

}

}

Json.Append("]}");

returnJson.ToString();

}

///<summary>

///DataReader转换为Json

///</summary>

///<param name="dataReader">DataReader对象</param>

///<returns>Json字符串</returns>

publicstaticstringToJson(DbDataReaderdataReader)

{

StringBuilderjsonString = newStringBuilder();

jsonString.Append("[");

while (dataReader.Read())

{

jsonString.Append("{");

for (inti = 0; i<dataReader.FieldCount; i++)

{

Type type = dataReader.GetFieldType(i);

stringstrKey = dataReader.GetName(i);

stringstrValue = dataReader[i].ToString();

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

strValue = StringFormat(strValue, type);