DataTable 對象 轉換為Json 字串

標籤：

   #region DataTable 轉換為Json 字串        /// <summary>        /// DataTable 對象 轉換為Json 字串        /// </summary>        /// <param name="dt"></param>        /// <returns></returns>        public string ToJson( DataTable dt)        {            JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();            javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大數值            ArrayList arrayList = new ArrayList();            foreach (DataRow dataRow in dt.Rows)            {                Dictionary<string, object> dictionary = new Dictionary<string, object>();  //執行個體化一個參數集合                foreach (DataColumn dataColumn in dt.Columns)                {                    dictionary.Add(dataColumn.ColumnName, dataRow[dataColumn.ColumnName].ToString());                }                arrayList.Add(dictionary); //ArrayList集合中添加索引值            }            return javaScriptSerializer.Serialize(arrayList);  //返回一個json字串        }        #endregion

 

DataTable 對象 轉換為Json 字串