Datatable轉換為Json

標籤：sum   tab   column   else   summary   cti   ati   nbsp   pre   

        /// <summary>             /// Datatable轉換為Json             /// </summary>            /// <param name="table">Datatable對象</param>             /// <returns>Json字串</returns>             public static string ToJson(DataTable dt)        {            StringBuilder jsonString = new StringBuilder();            jsonString.Append("[");            DataRowCollection drc = dt.Rows;            for (int i = 0; i < drc.Count; i++)            {                jsonString.Append("{");                for (int j = 0; j < dt.Columns.Count; j++)                {                    string strKey = dt.Columns[j].ColumnName;                    string strValue = drc[i][j].ToString();                    Type type = dt.Columns[j].DataType;                    jsonString.Append("\"" + strKey + "\":");                    strValue = String.Format(strValue, type);                    if (j < dt.Columns.Count - 1)                    {                        jsonString.Append("\"" + strValue + "\"" + ",");                    }                    else                    {                        jsonString.Append("\"" + strValue + "\"");                    }                }                jsonString.Append("},");            }            jsonString.Remove(jsonString.Length - 1, 1);            jsonString.Append("]");            return jsonString.ToString();        }

 

Datatable轉換為Json