首先创建 list集合:
List<int> list = new List<int> { 1, 2, 3, 4, 5 };
创建DataTable:
DataTable dt = new DataTable();
dt.TableName = "Test";
dt.Columns.Add("id");
dt.Columns.Add("name");
dt.Rows.Add("1","张");
dt.Rows.Add("2","王");
语法:
1. where的三种使用方法
var ss = list.Where(a => a != 1);
结果:
var ss1 = list.Where(a=> a.ToString().Contains("1"));
结果:
var ss2 = from a in list
where a.ToString().Contains("2")
select a;
结果:
2. Select
var ss3 = list.Select(a=>a.ToString());
结果
var ss4 = dt.AsEnumerable()
.Select(a => a.Field<string>("id").ToString());
结果:
3. Where与select同时使用:
var ss5= list.Where(a => !string.IsNullOrEmpty(a.ToString())).Select(a => a.ToString());
结果: