How do i add the return table to the DataGridView

petre ricardo

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

naura pax17y ago
Accepted 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());
0
Amit Choudhary17y ago
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
0
Nilanka Dharmadasa17y ago
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.
0