随记_1_将泛型集合转为Table 

 1 　　　　　/// <summary>
 2         /// 将泛型集合转为Table
 3         /// </summary>
 4         /// <param name="list">数据</param>
 5         /// <param name="columns">列</param>
 6         /// <param name="isIntColumn">标识该列为整数类型（用于排序）</param>
 7         /// <returns></returns>
 8         public static DataTable listToTable(List<object[]> list, string[] columns, string[] isIntColumn)
 9         {
10             try
11             {
12                 DataTable dt = new DataTable();
13                 for (int i = 0; i < columns.Length; i++)
14                 {
15                     if (!isIntColumn.Contains(columns[i]))
16                     {
17                         dt.Columns.Add(columns[i]);
18                     }
19                     else
20                     {
21                         dt.Columns.Add(columns[i], typeof(double));
22                     }
23                 }
24                 for (int i = 0; i < list.Count; i++)
25                 {
26                     object[] objs = list[i];
27                     if (objs.Length == columns.Length)
28                     {
29                         dt.Rows.Add();
30                         for (int s = 0; s < objs.Length; s++)
31                         {
32                             dt.Rows[dt.Rows.Count - 1][s] = objs[s];
33                         }
34                     }
35                 }
36 
37                 return dt;
38             }
39             catch (Exception ee)
40             {
41                 Console.WriteLine(ee.Message);
42                 return null;
43             }
44         }

 

posted @ 2017-03-23 16:46  Z_JRV1  阅读(134)  评论(0)    收藏  举报