how to set a datagridview with a combo column that display table value from a database

See more:

C#

WinForms

how to set a datagridview with a combo column that display table value from a database while form load...

Can any one help me

iam using following code for displaying data from DB table in datagridview

private void edit_res_per_Load(object sender, EventArgs e)
     {
         mycon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ETMS\\ETMS\\ETMS\\etms.accdb");
         string query = "Select resid as ID, resname as Person_Name,resdesg as Designation, resdept as Department From resperson order By resid ";
         da = new OleDbDataAdapter(query, mycon);
         OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
         dt = new DataTable();
         da.Fill(dt);
         dgv1.AllowUserToAddRows = false;


         dgv1.DataSource = dt;
         dgv1.Columns[0].ReadOnly = true;



     }