C#查询datatable接收数据集并转换为json返回

 StringBuilder commandText = new StringBuilder();
commandText.Append("select clientcode,coperator, skdate,usefund,skway,skprice from ReceiptLog");
commandText.Append(" WHERE clientcode = '"+Custcode+"'");
SysDBModel.CodeValue Codeobj = new SysDBModel.CodeValue();
DataTable CodeTable = new DataTable();
Codeobj.ExecuteQuery(commandText.ToString(), CodeTable);
var jsonString = new StringBuilder();
if (CodeTable.Rows.Count > 0)
{
    jsonString.Append("[");
    for (int i = 0; i < CodeTable.Rows.Count; i++)
    {
        jsonString.Append("{");
        for (int j = 0; j < CodeTable.Columns.Count; j++)
        {
            if (j < CodeTable.Columns.Count - 1)
            {
                jsonString.Append("\"" + CodeTable.Columns[j].ColumnName.ToString()
                + "\":" + "\""
                + CodeTable.Rows[i][j].ToString() + "\",");
            }
            else if (j == CodeTable.Columns.Count - 1)
            {
                jsonString.Append("\"" + CodeTable.Columns[j].ColumnName.ToString()
                + "\":" + "\""
                + CodeTable.Rows[i][j].ToString() + "\"");
            }
        }
        if (i == CodeTable.Rows.Count - 1)
        {
            jsonString.Append("}");
        }
        else
        {
            jsonString.Append("},");
        }
    }
    jsonString.Append("]");
}
return jsonString.ToString();
return "OK";

转载于:https://www.cnblogs.com/zhipeng007/p/10614965.html