datagridview did not show all data of database.

Yves Larock

10y926Visual Basic .NET

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++;

}

7 Replies

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

Ranjit Powar10y ago
Accepted answer
Sorry

DataTable dt = new DataTable();
dt = blcat.getallcategory();
for (int i=0;i< dt.Rows.Count ;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.
0
Yves Larock10y ago
thanks bro...
0
Vipul Malhotra10y ago
Please try and replace int k= dataGridView1.rows.count; with int k= dataGridView1.rows.count-1;
0
Yves Larock10y ago
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.
0
Abdu Rafeeq10y ago
hi,,ranjith your answer read only first row of data table.
0
Ranjit Powar10y ago
hey use for loop like below

DataTable dt = new DataTable();
dt = blcat.getallcategory();
for (int i=0;i< dt.Rows.Count ;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.
0
Abdu Rafeeq10y ago
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();
}
}

0