Linq 操作DataTable
来源:互联网 发布:织梦cms使用 编辑:程序博客网 时间:2024/04/30 20:39
- class ClientStruct
- {
- public string ID = "ID";
- public string Name = "Name";
- public string Company = "Company";
- public string CreatedDate = "CreatedDate";
- }
- public string[,] infoArr = new string[,] { { "1", "百度", "baidu", "201303" }, { "2", "迅雷", "xunlei", "201302" }, { "3", "谷歌", "guge", "201301" } };
- protected void LinqDataTable()
- {
- DataRow row;
- ClientStruct cs = new ClientStruct();
- DataTable dtTable = new DataTable();
- dtTable.Columns.Add(cs.ID);
- dtTable.Columns.Add(cs.Name);
- dtTable.Columns.Add(cs.Company);
- dtTable.Columns.Add(cs.CreatedDate);
- for (int i = 0; i < 3; i++)
- {
- row = dtTable.NewRow();
- row[cs.ID] = infoArr[i, 0];
- row[cs.Name] = infoArr[i, 1];
- row[cs.Company] = infoArr[i, 2];
- row[cs.CreatedDate] = infoArr[i, 3];
- dtTable.Rows.Add(row);
- }
- //遍历DataTable,取出所有的ID
- List<string> lstID = (from d in dtTable.AsEnumerable()
- select d.Field<string>(cs.ID)).ToList<string>();
- //遍历DataTable,将其中的数据对应到ClientStruct中:
- List<ClientStruct> list = (from x in dtTable.AsEnumerable()
- orderby x.Field<string>(cs.Company)
- select new ClientStruct
- {
- ID = x.Field<string>(cs.ID),
- Name = x.Field<string>(cs.Name),
- Company = x.Field<string>(cs.Company),
- CreatedDate = x.Field<string>(cs.CreatedDate)
- }).ToList<ClientStruct>();
- //遍历DataTable,并将上面的List结果存储到Dictionary中:
- Dictionary<string, ClientStruct> dic = list.ToDictionary(p => p.Company);
- //p作为string键值来存储
- }
0 0
- Linq to datatable 操作
- Linq操作DataTable
- c# Linq操作DataTable
- Linq 操作DataTable
- Linq 操作DataTable
- Linq to DataTable 操作
- Linq 操作DataTable
- Linq 操作DataTable
- C# 中 Linq 操作 DataTable
- LINQ to DataSet的DataTable操作
- LINQ系列:LINQ to DataSet的DataTable操作
- LINQ系列:LINQ to DataSet的DataTable操作
- Linq Datatable
- datatable linq
- Linq To DataTable
- LINQ To DataTable
- Datatable中linq查询
- Linq To DataTable
- 说点有用的吧 mysql密码修改工具
- poj 1741 Tree | 树分治
- Android中使用HTTP服务
- Codeforces Round #266 (Div. 2) A
- do...while(0)的作用
- Linq 操作DataTable
- 快速排序 Java实现
- jquery tmpl 学习
- Maven 命令大全
- android 侧滑事件的监听
- codeforces#266 总结
- 运算的优先级与结合性
- 黑马程序员——函数及数组
- D-ExecuteSQL