Question

C#多条件查询？代码如下；怎么修改能实现多条件查询？

private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
DataView dv = dataSet.Tables["预订订单"].DefaultView;
dv.RowFilter = "厂商名称 = '" + toolStripComboBox1.Text + "'";
//dv.RowFilter = "订单号 = '" + toolStripTextBox1.Text + "'";
dataGridView1.DataSource = dv;
}
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
DataView dv = dataSet.Tables["预订订单"].DefaultView;
dv.RowFilter = "厂商名称 = '" + toolStripComboBox1.Text + "'" as dv.RowFilter = "订单号 = '" + toolStripTextBox1.Text + "'";
//dv.RowFilter = "订单号 = '" + toolStripTextBox1.Text + "'";
dataGridView1.DataSource = dv;
}

Answer 1

dv.RowFilter = "厂商名称 = '" + toolStripComboBox1.Text + "' and 订单号 = " + toolStripTextBox1.Text + "'";

用这个filter

Answer 2

你QQ多少 我把代码发给你

Answer 3

你想说的是自定义查询吧。这个东西呢最近也在看。csdn和博客园上有些例子

追问

能具体点吗?