var row = from drow in dt.AsEnumerable() where drow.Field<string>("字段") == "" select drow;
var row = from drow in dt.AsEnumerable() where drow.Field<string>("字段") == ""&drow.Field<string>("")=="" select drow;多个条件用& 字段是你所需要筛选的字段 =="" 是你所需要筛选的值
DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(System.Int32)); dt.Columns.Add("name", typeof(System.String)); DataRow row = dt.NewRow(); row[0] = 1; row[1] = "csdn"; dt.Rows.Add(row); DataRow row2 = dt.NewRow(); row2[0] = 2; row2[1] = "cnblogs"; dt.Rows.Add(row2); var query = from d in dt.AsEnumerable() where d.Field<int>("id") == 1 && d.Field<string>("name") == "csdn" select new { id = d.Field<int>("id"), name = d.Field<string>("name") }; foreach (var q in query) Console.WriteLine(q.id + "==" + q.name);
如果你的DataTable是强类型的就也可以用linq来查询
什么合适用什么
var row = from drow in dt.AsEnumerable()
where drow.Field<string>("字段") == ""
select drow;
where drow.Field<string>("字段") == ""&drow.Field<string>("")==""
select drow;多个条件用&
字段是你所需要筛选的字段
==""
是你所需要筛选的值
dt.Columns.Add("id", typeof(System.Int32));
dt.Columns.Add("name", typeof(System.String));
DataRow row = dt.NewRow();
row[0] = 1;
row[1] = "csdn";
dt.Rows.Add(row);
DataRow row2 = dt.NewRow();
row2[0] = 2;
row2[1] = "cnblogs";
dt.Rows.Add(row2);
var query = from d in dt.AsEnumerable() where d.Field<int>("id") == 1 && d.Field<string>("name") == "csdn" select new { id = d.Field<int>("id"), name = d.Field<string>("name") };
foreach (var q in query)
Console.WriteLine(q.id + "==" + q.name);