110,535
社区成员
发帖
与我相关
我的任务
分享
string s=tb.Text
string str = " text like '%" + s + "%'";
DataRow[] dr = dt.Select(str);
string str = @"text like '%" + @s + "%'";
System.Data.DataTable dataTable1 = new System.Data.DataTable("BlogUser");
System.Data.DataRow d;
dataTable1.Columns.Add(new System.Data.DataColumn("Id", typeof(System.Int32)));
dataTable1.Columns.Add(new System.Data.DataColumn("Tel", typeof(System.String)));
dataTable1.Columns.Add(new System.Data.DataColumn("addr", typeof(System.String)));
dataTable1.Rows.Add(new Object[] { 1, "测试1", "在过滤datatable记录的时候" });
dataTable1.Rows.Add(new Object[] { 2, "输入内容如果出现通配符", "在过滤datatable记录的时候" });
dataTable1.Rows.Add(new Object[] { 3, "输入内容如果出现通配符", "输入内容如果出现通配符" });
dataTable1.Rows.Add(new Object[] { 4, "测试1", "输入内容如果出现通配符" });
GridView1.DataSource = dataTable1;
GridView1.DataBind();
string s = "输入内容";
string str = "addr like '%" + s + "%' or Tel like '%" + s + "%'";
System.Data.DataRow[] dr = dataTable1.Select(str);
MessageBox.Show(dr.Length.ToString());