C# System.Data.DataTable 转JSON用数据

最新推荐文章于 2024-10-03 07:17:26 发布

oXueYuZhiYing

最新推荐文章于 2024-10-03 07:17:26 发布

阅读量286

点赞数 5

文章标签： c# json java

本文链接：https://blog.csdn.net/oXueYuZhiYing/article/details/140834922

版权

 /// <summary>
        /// 数据转哈希列表
        /// </summary>
        /// <param name="tb"></param>
        /// <returns></returns>
        public static System.Collections.ArrayList TabToArrayList(System.Data.DataTable tb)
        {
            System.Collections.ArrayList arrayList = new System.Collections.ArrayList();
            foreach (System.Data.DataRow row in tb.Rows)
            {
                System.Collections.Hashtable arrayRow = new System.Collections.Hashtable();
                foreach (System.Data.DataColumn col in tb.Columns)
                {
                    arrayRow.Add(col.ColumnName, row[col.ColumnName]);
                }
                arrayList.Add(arrayRow);
            }
            return arrayList;
        }
        /// <summary>
        /// 数据转哈希表
        /// </summary>
        /// <param name="row"></param>
        /// <returns></returns>
        public static System.Collections.Hashtable RowToHashtable(System.Data.DataRow row)
        {
            System.Collections.Hashtable arrayRow = new System.Collections.Hashtable();
            foreach (System.Data.DataColumn col in row.Table.Columns)
            {
                arrayRow.Add(col.ColumnName, row[col.ColumnName]);
            }
            return arrayRow;
        }