Exactly how you do it will depend on what you want to retirve, and how you want to display it. But, assuming it is more than just "get a string from an Access column and display it" then it needs a little more work.
Here is one way to do it:
using (OleDbConnection con = new OleDbConnection(strConnect))
{
con.Open();
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM MyTable", con);
da.Fill(dt);
myListBox.DataSource = dt;
myListBox.DisplayMember = "NameOfColumnInDB";
}
There are loads of others, depending on exactly what you want to do!
Submit an article or tip