DataSet 扩展 方法

    
        public static ImmutableArray<ArrayList> ToImmutableArray(this DataSet ds) 
        { 
            List<ArrayList> list = new List<ArrayList>(); 
            
            foreach (DataTable item in ds.Tables)
            {
                ArrayList arrayList= item.ToArrayList();   //调用 toArrayList 方法
                list.Add(arrayList);
            } 
           return list.ToImmutableArray();

        }

 

 /// <summary>
        ///  将 table 转成  ArrayList
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static ArrayList ToArrayList(this DataTable dt)
        {
            ArrayList arrayList = new ArrayList();
            foreach (DataRow item in dt.Rows)
            {
                item.ToString();
                Dictionary<string, object> dictionary = new Dictionary<string, object>();  //实例化一个参数集合
                foreach (DataColumn dataColumn in dt.Columns)
                {                   
                    dictionary.Add(dataColumn.ColumnName, item[dataColumn.ColumnName].ToString() );                  
                }
                arrayList.Add(dictionary); //ArrayList集合中添加键值
            }

            return arrayList;


        }