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

hiranjith 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(); } }