I have access database file with 7 tables in it but I don't know how to connect and show all tables, If some one can help me?
this is my code but it doesn't show anything
private void button1_Click(object sender, EventArgs e)
OleDbConnection conn = new OleDbConnection();
String connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\Tables.accdb;Persist Security Info=True";
string sql = "SELECT Clients FROM Tables";
conn.ConnectionString = connection;
DataSet ds = new DataSet();
DataGridView dataGridView1 = new DataGridView();
BindingSource bSource = new BindingSource();
OleDbDataAdapter adapter = new OleDbDataAdapter(sql,conn);
dataGridView1.DataSource = ds;
Your help is greatly appreciated.