C#处理DataTable转Json

方法一

public  string DataTableJson(DataTable dt)
       {
           StringBuilder sb = new StringBuilder();
           sb.Append("[");
           for (int i = 0; i < dt.Rows.Count; i++)
           {
               sb.Append("{");
               for (int j = 0; j < dt.Columns.Count; j++)
               {
                   sb.Append("\"");
                   sb.Append(dt.Columns[j].ColumnName);
                   sb.Append("\":\"");
                   sb.Append(dt.Rows[i][j].ToString());
                   sb.Append("\",");
               }
               sb.Remove(sb.Length - 1, 1);
               sb.Append("},");
           }
           sb.Remove(sb.Length - 1, 1);
           sb.Append("]");
           return sb.ToString();
       }
    }

方法二：引用using Newtonsoft.Json;

 public string allUserH(DataTable  dt)
        {
            string JsonString = string.Empty;
            if (dt.Rows.Count > 0)
            {
                JsonString = JsonConvert.SerializeObject(dt);
            }

}