scott

scott

  • NA
  • 2
  • 0

connect Ms access DB oleDb problem

Jan 13 2009 2:33 AM
Hi again, I'm having trouble whilst connecting a MS access db using oleDB

Problem is with getting more than one column added into a listbox in my application from the DB
here's the code so far


            OleDbConnection Conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Scott\\Documents\\Menu.accdb");

                OleDbDataAdapter da = new OleDbDataAdapter(
                      "Select * from Menu", Conn);

                DataSet ds = new DataSet();
                da.Fill(ds);
                DataTable dt = ds.Tables[0];

                foreach (DataRow dr in dt.Rows)
                {
                    listBox1.Items.Add(dr["Dish"]);
                }
          }

I just can't find a way to get the second column added ?

thanks,Scott

Answers (2)