Question

.Net中DataView 的RowFilter如何实现模糊查询？

 dvTestPaper.RowFilter = "TestPaperName like '%want%'";其中want是一个变量，从文本框中获取的。上面的这种方法不能实现。请各位大侠指点下。。。。

Answer 1

DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=sa;DataBase=pubs"); SqlDataAdapter ada = new SqlDataAdapter("select * from authors",conn); conn。Open(); ada。Fill(ds,"a"); conn。Close(); DataView dv = new DataView(); dv。Table = ds。Tables[0]; dv。RowFilter = "au_fname like 'rr%'"; 。。RowFilter 的值和where语句的模糊查询语句一r样 dv。Sort = "au_id DESC"; tst。DataSource=dv; tst。DataBind(); _在C# RowFilter中6是不q行的我也a试了d， dataview5。RowFilter = "f5 like 'rr%' and len(f5)=5";这样行吗？如果不z行就用这种思路一o定能解决。 p狮u√g侉vМbltzWs啊♀qл

Answer 2

dvTestPaper.RowFilter = "TestPaperName like '%"+want+"%'";

Answer 3

//关键语句
DataTable dt = ds.Tables[0]; //dt数据源
DataView dvTestPaper= dt.DefaultView;
dvTestPaper.RowFilter = "TestPaperName like '%want%'";
dgvShowList.DataSource = dvTestPaper;