datagridview did not show all data of database.

Question

datagridview did not show all data of database it only show one data. DataTable dt = new DataTable(); dt = blcat.getallcategory(); if (dt.Rows.Count > 0) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["calcategory_id"].Value = dt.Rows[0]["category_id"].ToString(); dataGridView1.Rows[i].Cells["calcategory"].Value = dt.Rows[0]["category_name"].ToString(); i++; }

Ranjit Powar · Answer

Sorry DataTable dt = new DataTable(); dt = blcat.getallcategory(); for (int i=0;i { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["calcategory_id"].Value = dt.Rows [i] ["category_id"].ToString(); dataGridView1.Rows[i].Cells["calcategory"].Value = dt.Rows [i][ "category_name"].ToString(); } If helps select as correct answer.

Yves Larock · Answer

thanks bro...

Vipul Malhotra · Answer

Please try and replace int k= dataGridView1.rows.count; with int k= dataGridView1.rows.count-1;

Yves Larock · Answer

hello Abdu Rafeeq sir.Index was out of range. Must be non-negative and less than the size of the collection. this kind of error come.

Abdu Rafeeq · Answer

hi,,ranjith your answer read only first row of data table.

Ranjit Powar · Answer

hey use for loop like below DataTable dt = new DataTable(); dt = blcat.getallcategory(); for (int i=0;i { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["calcategory_id"].Value = dt.Rows[0]["category_id"].ToString(); dataGridView1.Rows[i].Cells["calcategory"].Value = dt.Rows[0]["category_name"].ToString(); } If your problem solved accept it as correct answer.

Abdu Rafeeq · Answer

This is cause of your code.If you want show all data please copy the code DataTable dt = new DataTable(); dt = blcat.getallcategory(); if (dt.Rows.Count > 0) { for(int i=0;i { dataGridView1.Rows.Add(); int k= dataGridView1.rows.count; dataGridView1.Rows[k].Cells["calcategory_id"].Value = dt.Rows[i]["category_id"].ToString(); dataGridView1.Rows[k].Cells["calcategory"].Value = dt.Rows[i]["category_name"].ToString(); } }

datagridview did not show all data of database.

Answers (7)