WinForm中是不是不支持like '_'的写法啊?
如下的语句,在SQL的查询分析器里能通过,在C#中,选出的记录却为0,为什么?ds.Tables["Base_Unit"].DefaultView.RowFilter = "Path like '________/00000033/%'";
如下的语句,在SQL的查询分析器里能通过,在C#中,选出的记录却为0,为什么?ds.Tables["Base_Unit"].DefaultView.RowFilter = "Path like '________/00000033/%'";
DataTable dt1 = new DataTable();
dt1.Columns.Add("number ", typeof(int));
dt1.Columns.Add("Name", typeof(string));
dt1.Columns.Add("age", typeof(int));
dt1.Columns.Add("sex", typeof(string));dt1.Rows.Add(101,"张三", 12,"男");
dt1.Rows.Add(102, "________/00000033/李四", 13, "男");
dt1.Rows.Add(103, "王五", 14, "男");
dt1.Rows.Add(104, DBNull.Value, null);
dt1.Rows.Add(105, null, null);
dt1.DefaultView.RowFilter = "name like '________/00000033/%'";
Console.WriteLine(dt1.DefaultView.Count);