用lamda表达式操作datatable

 1             DataTable dt = new DataTable();
 2             dt.Columns.Add("Name", System.Type.GetType("System.String"));
 3             dt.Columns.Add("NO", System.Type.GetType("System.String"));
 4             dt.Rows.Add("A", "kx-307");
 5             dt.Rows.Add("A", "kx-407");
 6             dt.Rows.Add("A", "kx-507");
 7             dt.Rows.Add("B", "kx-825");
 8 
 9             //将筛选后的datatable放入序列中
10             var tmp = dt.AsEnumerable();
11             var result = tmp.Where(x => x["Name"].ToString() == "A");
12 
13             //将序列转为datatable
14             DataTable dtNew = result.OrderBy(x => x["NO"].ToString()).CopyToDataTable<DataRow>();
15             for (int i = 0; i < dtNew.Rows.Count; i++)
16             {
17                 MessageBox.Show(dtNew.Rows[i]["NO"].ToString());
18             }