Question

ASP.NET如何做个简单的模糊查询并显示结果?

Answer 1

string strConn="server=192.168.1.103;database=111;uid=sa;pwd=";
SqlConnection myConn=new SqlConnection(strConn);
string strSql;
strSql = "select * from 出库表 WHERE (序号 like '%"+this.TextBox1.Text.Trim() +"%')";
SqlCommand forumCommand =new SqlCommand(strSql,myConn);
sqlDataAdapter1=new SqlDataAdapter();
DataSet1 dataSet11= new DataSet1();
sqlDataAdapter1.SelectCommand =forumCommand;
sqlDataAdapter1.Fill(dataSet11,"出库表");
DataGrid1.DataSource=dataSet11;
DataGrid1.DataBind();