connect MS access DB oleDB problem

[scottmcg]

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

[MMH]

Instead of using ListBox, use ListView.

[dannystommen]

foreach (DataRow dr in dt.Rows)
{
  ListViewItem item = new ListViewItem(dr["Dish"]);
  item.SubItems.Add(dr["secondField"]);
  listView1.Items.Add(item);
}

Change the View property to Details and add some columns to the listview

[scottmcg]

thanks

I'm getting some errors when trying to use a listbox:

cannot convert from 'double' to 'System.Windows.Forms.ListViewItem.ListViewSubItem

it's referring to my second field in the DB, which is 'Cost' with data type double

any idea's?

much appreciated..

[MMH]

You cannot directly add double to ListView Collection.
First convert it to string type.

item.SubItems.Add(dr["cost"].ToString());