DataTable转换Json

 public string DataTableToJson(DataTable dt)
    {
        string Json = "[";
        int ColumnCount = dt.Columns.Count;
        foreach (DataRow dr in dt.Rows)
        {
            Json += "{";
            for (int i = 0; i < ColumnCount; i++)
                Json += "\"" + dt.Columns[i] + "\":" + "\"" + dr[i].ToString().Trim() + "\",";
            Json = Json.TrimEnd(',') + "},";
        }
        Json = Json.TrimEnd(',') + "]";



        return Json;

    }