i tried as below its not loading data into grid view when i tried using dataset it worked perfectly
OleDbCommand cmd = new OleDbCommand("select * from customer", con);
con.Open();
MessageBox.Show(con.State.ToString());
OleDbDataReader dr = cmd.ExecuteReader();
con.Close();
MessageBox.Show(con.State.ToString());
dataGridView1.DataSource = dr;