C#中DataTable转Json

public string DataTableConvertToJson(DataTable table)
        {
            var str = new StringBuilder();
        //首先根据获得的Table行数来判断Table是否为空，按照Json的数据格式将Table中的数据怕拼成Json格式的数据
            if (table.Rows.Count > 0)
            {
                str.Append("[");
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    str.Append("{");
                    for (int j = 0; j < table.Columns.Count; j++)
                    {
                        if (j < table.Columns.Count - 1)
                        {
                            //将Datatable中的列明作为Json键值对的Key
                            str.Append("\"" + table.Columns[j].ColumnName.ToString()
                         + "\":" + "\""
                         + table.Rows[i][j].ToString() + "\",");
                        }
                        else if (j == table.Columns.Count - 1)
                        {
                            str.Append("\"" + table.Columns[j].ColumnName.ToString()
                         + "\":" + "\""
                         + table.Rows[i][j].ToString() + "\"");
                        }
                    }
                    if (i == table.Rows.Count - 1)
                    {
                        str.Append("}");
                    }
                    else
                    {
                        str.Append("},");
                    }
                }
                str.Append("]");
            }
            return str.ToString();
        }