我是实现一个模糊查询


this.sqlConnection1.ConnectionString = "workstation id=ZJ;packet size=4096;integrated security=SSPI;initial catalog=dms;p" +
"ersist security info=False";

string StrSQL="SELECT * FROM wj WHERE ChineseName LINK '%this.textBox1.Text+%'";

this.sqlDataAdapter1.SelectCommand.CommandText=StrSQL;
this.sqlDataAdapter1.SelectCommand.Connection=this.sqlConnection1;
//打开数据库连接
this.sqlConnection1.Open();
//执行SQL命令
this.sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
//关闭连接
this.sqlConnection1.Close();
//更新数据库
this.sqlDataAdapter1.Fill(this.dataSet1,"wj");
this.dataGrid1.DataSource=this.dataSet1;

恩谢谢了,我知道了!