表格过滤

DataTable dt = new DataTable("测试"); dt.Columns.Add("name"); dt.Columns.Add("startTime"); dt.Columns.Add("duration");

var name = "小东"; var startTime = new DateTime(2024, 1, 1); var duration = 10; for (int i = 0; i < 10; i++) { DataRow drNew = dt.NewRow(); drNew["name"] = name + i; drNew["startTime"] = startTime.ToString("yyyy-MM-dd HH:mm:ss"); drNew["duration"] = duration + i; dt.Rows.Add(drNew); startTime = startTime.AddMinutes(10); } dt.AcceptChanges(); var checkName = "小东"; var checkStartTime = new DateTime(2024, 1, 1).AddMinutes(10).ToString("yyyy-MM-dd HH:mm:ss"); //var existCount = dt.Select($@"name = '{checkName}' and startTime ='{checkStartTime}'").Count(); var existCount = dt.Select($@"name = '{checkName}1' and (duration <> 12 or duration <> 11)").Count(); if (existCount > 0) { txtRes.Text = "存在"; } else { txtRes.Text = "不存在"; }