C#多条件查询,代码如次
C#多条件查询,代码如下!
string sql = "Select * From tuixiuxinxi Where 1=1";
if (textBox1.Text != "")
{
sql += " And a like '%" + textBox1.Text + "%'";
}
if (textBox2.Text != "")
{
sql += " And b like '%" + textBox2.Text + "%'";
}
if (textBox3.Text != "")
{
sql += " And b like '%" + textBox3.Text + "%'";
}
if (textBox4.Text != "")
{
sql += " And b like '%" + textBox4.Text + "%'";
}
if (textBox5.Text != "")
{
sql += " And b like '%" + textBox5.Text + "%'";
}
if (textBox6.Text != "")
{
sql += " And b like '%" + textBox6.Text + "%'";
}
if (textBox7.Text != "")
{
sql += " And c like '%" + textBox7.Text + "%'";
}
if (comboBox1.Text != "")
{
sql += " And b like '%" + comboBox1.Text + "%'";
}
if (comboBox2.Text != "")
{
sql += " And b like '%" + comboBox2.Text + "%'";
}
if (comboBox4.Text != "")
{
sql += " And b like '%" + comboBox4.Text + "%'";
}
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = data.mdb");
OleDbCommand comm = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql,conn);
//da.Fill(ds);
dataGridView1.DataSource = da;
dataGridView1.Visible = true;
请问哪里不对了?
string sql = "Select * From tuixiuxinxi Where 1=1";
if (textBox1.Text != "")
{
sql += " And a like '%" + textBox1.Text + "%'";
}
if (textBox2.Text != "")
{
sql += " And b like '%" + textBox2.Text + "%'";
}
if (textBox3.Text != "")
{
sql += " And b like '%" + textBox3.Text + "%'";
}
if (textBox4.Text != "")
{
sql += " And b like '%" + textBox4.Text + "%'";
}
if (textBox5.Text != "")
{
sql += " And b like '%" + textBox5.Text + "%'";
}
if (textBox6.Text != "")
{
sql += " And b like '%" + textBox6.Text + "%'";
}
if (textBox7.Text != "")
{
sql += " And c like '%" + textBox7.Text + "%'";
}
if (comboBox1.Text != "")
{
sql += " And b like '%" + comboBox1.Text + "%'";
}
if (comboBox2.Text != "")
{
sql += " And b like '%" + comboBox2.Text + "%'";
}
if (comboBox4.Text != "")
{
sql += " And b like '%" + comboBox4.Text + "%'";
}
OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source = data.mdb");
OleDbCommand comm = new OleDbCommand(sql, conn);
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter(sql,conn);
//da.Fill(ds);
dataGridView1.DataSource = da;
dataGridView1.Visible = true;
请问哪里不对了?
相关解决方案