string str = "select * from Books";
            OleDbDataAdapter da = new OleDbDataAdapter(str,con.GetConnection());
            DataSet ds = new DataSet();
            da.Fill(ds);

dataGridView1.DataSource = ds.Tables[0].DefaultView;