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 }
转载于:https://www.cnblogs.com/JenReiChau/p/6605955.html
