private void ShowDataGridView()
        {
            SQL_conn();
           if (comboBox1.SelectedIndex == -1 && comboBox2.SelectedIndex == -1)
            {
                cmdtext = "select ReiNumber as 识别码,ReiDate as 日期,Department as 部门,name as 出差人,Reason as 出差事由,Cashier as 出纳,Payee as 收款人,TotalRei as 金额 from TravelExpense2";
            }
            else
            {
                if (comboBox1.SelectedIndex == -1&& comboBox2.SelectedIndex != -1)
                {
                    cmdtext = "select ReiNumber as 识别码,ReiDate as 日期,Department as 部门,name as 出差人,Reason as 出差事由,Cashier as 出纳,Payee as 收款人,TotalRei as 金额 from TravelExpense2 where name = " + comboBox2.Text;
                }
                if (comboBox1.SelectedIndex != -1&& comboBox2.SelectedIndex == -1)
                {
                    cmdtext = "select ReiNumber as 识别码,ReiDate as 日期,Department as 部门,name as 出差人,Reason as 出差事由,Cashier as 出纳,Payee as 收款人,TotalRei as 金额 from TravelExpense2 where Department = " + comboBox1.Text;
                }
                if(comboBox1.SelectedIndex != -1&& comboBox2.SelectedIndex != -1)
                {
                cmdtext = "select ReiNumber as 识别码,ReiDate as 日期,Department as 部门,name as 出差人,Reason as 出差事由,Cashier as 出纳,Payee as 收款人,TotalRei as 金额 from TravelExpense2  where Department = '" + comboBox1.Text + "' and name=" + comboBox2.Text;
                }
           }
            SQLiteDataAdapter sda = new SQLiteDataAdapter(cmdtext, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "TravelExpense2");
            this.dataGridView1.DataSource = ds.Tables["TravelExpense2"];
            dataGridView1.Visible = true;
            conn.Close();
        
        }
执行时，总是提示数据库表中没有combobox控件中选中的值，请问应该怎么修改？感激不尽！

没人会？难道论坛里的都是新手？

sql 语句错了..如果是文本的话要用 ' ' 引起来..我看你只有后面的其中一个用了单引号 ''

恩，前天的时候已经做出来了