How do i add the return table to the DataGridView

Question

Hi,
I haev created a Data Grid view control at design and add three columns at design time one includes a check box.
Then at the buton clicck event:

 
private void btnLoad_Click(object sender, EventArgs e)
{
ds = DBConn.GetAllReocrds(); 
int i = 0;
foreach (DataRow item in ds.Tables[0].Rows)
{
dgvMulti.Rows[i].Cells[0].Value = item[0]; 
i++; 
}
}

"DBConn" object of class DBConnection that has the method GetAllReocrds() that returns a Dataset that has a three columned table.
What i was trying to do is to load each cell value of the retuned table to the cells of the dgvMulti... unforntuately "dgvMulti.Rows[i].Cells[0]" thorws an error. the cells werre created. How do i fix this and add data to the dgvMulti?
TY

naura pax · Answer

hey there, why don't you try this private void btnLoad_Click( object sender, EventArgs e) { ds = DBConn.GetAllReocrds(); dgvMulti.DataSource=ds.Tables[0]; } } error that you are getting is because no cells have been added in the datagridview. There is an alternate for above -: you can also write a code for adding a row in the datagridview foreach(DataRow dr in ds.Tables[0].Rows[0) dgvMulti.Rows.Add(dr["CheckBoxColumn"].ToString(),dr["Col1"].ToString(),dr["Col2"].ToString());

Amit Choudhary · Answer

maggogg have given a good example code for you. you can also design the item template for that and only one check box you add in item template and you will get it in all your Grid rows

Nilanka Dharmadasa · Answer

Why do you use a loop here? You can directly set the data table this way. datagrid.DataSource = ds.Tables[0]; Even for the checkbox column you can directly set the values. If you have any problem pls ask.