using System.Data.OleDb;
OleDbConnection con = new OleDbConnection();
con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;
Persist Security Info=False;";
con.Open();
string query = "select * from clienttable";
OleDbCommand cmd = new OleDbCommand(query, con);
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
dataGridView1.DataSource = dt;
dataGridView1.Show();
con.Close();
You can amend the above code as per your requirements. We have used OLDB method to get the data from data base to your gridview.
Let me know if you face any problems.