C#如何利用SQL实现模糊查询

[q520525745]

string sql1 = "select * from " + this.comboBox3.Text + " where " + this.comboBox4.Text + " like '" + this.textBox9.Text + "'";
如果想实现模糊查询like '" + this.textBox9.Text + "'这段话要改成什么?
请知道的帮忙说下谢谢.

[userwjg]

like '%" + this.textBox9.Text + "%'

[angleoldhen]

string sql 1 = "select * from " + this.comboBox3.Text + " where " + this.comboBox4.Text + " like '%" + this.textBox9.Text + "%'";

[s000rd]

like _'" + this.textBox9.Text + "_'"

[beibeishen]

string sql1 = "select * from " + this.comboBox3.Text + " where " + this.comboBox4.Text + " like '%" + this.textBox9.Text + "%'"; 

[pl731]

偶来晚了一步~

[fqbnet2050]

楼上正解！

[q520525745]

谢谢你们哈.
另再问下如何在局域网里连接SQL数据库
private string cmd = "server=.;uid=sa;pwd=;database=系统;";
这句应该改成什么

[lainY7mail]

string conn = "Initial Catalog=要连接的数据库;Data Source=要连接的IP;User ID=sa;Password=sa";

[kakajya]

like '%" + this.textBox9.Text.tostring().trim() + "%'