Hi,

I am doing a db application doing in C# and having db in MS Access...I have two tables



Products=ProdId,ProdName,Price,Packing(Number as datatype)
Packing=packingId,PackingName (Text as datatype)

Now below code is in C# ..first check pls if "sql2" is correct query and then

when i execute an application i get an error "Expression Mismatch" on line:
adp.Fill(ds,"PackingName");


Code:
private void Form1_Load(object sender, EventArgs e)
        {
            
            string sql ="SELECT distinct ProductName FROM Products";
            string sql2 = "SELECT pac.PackingName FROM Products prod,Packing pac where prod.Packing=pac.PackingName ";
            

            DataSet ds=new DataSet();
            
            try 
            {
                database = new OleDbConnection(connectionString);
                database.Open();
            }
            catch (Exception x)
            {
                MessageBox.Show(x.Message);
            }
            
            OleDbDataAdapter adp = new OleDbDataAdapter(sql, database);
            adp.Fill(ds, "ProductName");

            adp = new OleDbDataAdapter(sql2, database);
            adp.Fill(ds,"PackingName");
                            
            foreach (DataRow dr in ds.Tables[0].Rows) 
            {
                comboBox3.Items.Add(dr[0].ToString()) ;
                comboBox1.Items.Add(dr[1].ToString());
                    
            }
Please help I need it badly to work..Thanks in Advance...