private void textBox4_TextChanged(object sender, System.EventArgs e)
{
this.dataGrid1.Visible =true;
string filterexp;
filterexp="customerid like '" + this.textBox4.Text + "%'";
如果是传入常数的话表达式应该是这样的:
customerid like 'abcdefg%' 蓝色部分可用传入变量代替
this.dataView1.RowFilter=filterexp;
this.dataGrid1.DataSource=this.dataView1;
}
实现模糊查询的select语句写法
private void textBox4_TextChanged(object sender, System.EventArgs e)
{
this.dataGrid1.Visible =true;
string filterexp;
filterexp="customerid like '" + this.textBox4.Text + "%'";
上句是传入一个变量,如果是传入常数的话表达式应该是这样的:
customerid like 'abcdefg%' 蓝色部分可用传入变量代替
this.dataView1.RowFilter=filterexp;
this.dataGrid1.DataSource=this.dataView1;
}