关于ASP.NET模糊搜索
代码在这里:
protected void Button1_Click(object sender, EventArgs e)//搜索关键字
{
// string nt= this.TextBox1.Text;
// Response.Write(nt);
SqlConnection sqlCon = GetConnection();
string SqlStr = "select BXBH,BXDD,BXWP,SJ,WXZT from DBXXB WHERE WXZT = '" + this.TextBox1.Text.Trim( )+ "'";
Response.Write(SqlStr);
SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);
DataSet ds = new DataSet();
sqlCon.Open();
da.Fill(ds, "DBXXB");
GridView1.DataSource = ds;
GridView1.DataMember = "DBXXB";
GridView1.DataBind();
sqlCon.Close();
}
SQL语句要对整张表进行模糊搜索语句怎么写,我那里只能对WXZT进行搜索。而且我点BUTTEN按钮也不能把刚才搜索的信息在GridView中显示出来。