fill datagridview using datareader

Shyja Abraham

hai,

I have a form with datagridview. the column names of datagridview are sno,itemcode,itemdescription,unit,qty,rate,discount,value . I want to insert the database values into datagridview . I use this code for that,but It will not work.no error,but no values fill in to the datagridview, plz help.

for (i = 0; i < lpogridview.Rows.Count - 1; i++)

{

cmd.CommandText = "select lpoid, itemcode,itemname,unit,lpoqty,lporate,lpodiscount,lpovalue,nar from lpo l inner join item i on l.itemid=i.itemid where lpono='" + textBox2.Text + "'";

dr = cmd.ExecuteReader();

while (dr.Read())

{

lpogridview.Rows[i].Cells[0].Value = Convert.ToString(dr[0]);

lpogridview.Rows[i].Cells[1].Value = Convert.ToString(dr[1]);

lpogridview.Rows[i].Cells[2].Value = Convert.ToString(dr[2]);

lpogridview.Rows[i].Cells[3].Value = Convert.ToString(dr[3]);

lpogridview.Rows[i].Cells[4].Value = Convert.ToString(dr[4]);

lpogridview.Rows[i].Cells[5].Value = Convert.ToString(dr[5]);

lpogridview.Rows[i].Cells[6].Value = Convert.ToString(dr[6]);

lpogridview.Rows[i].Cells[7].Value = Convert.ToString(dr[7]);

}

dr.Close();

}

4 Replies

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

Vulpes15y ago
Accepted answer
Assuming that you have at least 8 columns in your DGV, that probably means that there are not enough rows to accommodate all the records that are being read from the database.

See if it gets rid of the exception if you add the highlighted line:

cmd.CommandText = "select lpoid, itemcode,itemname,unit,lpoqty,lporate,lpodiscount,lpovalue,nar from lpo l inner join item i on l.itemid=i.itemid where lpono='" + textBox2.Text + "'";
dr = cmd.ExecuteReader();
int i = 0;
while(dr.Read())
{
if (lpogridview.Rows.Count < i + 1) lpogridview.Rows.Add();
lpogridview.Rows[i].Cells[0].Value = Convert.ToString(dr[0]);
lpogridview.Rows[i].Cells[1].Value = Convert.ToString(dr[1]);
lpogridview.Rows[i].Cells[2].Value = Convert.ToString(dr[2]);
lpogridview.Rows[i].Cells[3].Value = Convert.ToString(dr[3]);
lpogridview.Rows[i].Cells[4].Value = Convert.ToString(dr[4]);
lpogridview.Rows[i].Cells[5].Value = Convert.ToString(dr[5]);
lpogridview.Rows[i].Cells[6].Value = Convert.ToString(dr[6]);
lpogridview.Rows[i].Cells[7].Value = Convert.ToString(dr[7]);
i++;
}
dr.Close();
0
Sam Hobbs15y ago
You can bind the query results to the DataGridView and the columns will be automatically created if that is okay. Do you want to do that?

Also see my Database Table Update in a DataGridView without Writing Code.
0
Shyja Abraham15y ago
i try this ,but one error occur.Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
0
Vulpes15y ago
Try it like this:

cmd.CommandText = "select lpoid, itemcode,itemname,unit,lpoqty,lporate,lpodiscount,lpovalue,nar from lpo l inner join item i on l.itemid=i.itemid where lpono='" + textBox2.Text + "'";
dr = cmd.ExecuteReader();
i = 0;
while(dr.Read())
{
lpogridview.Rows[i].Cells[0].Value = Convert.ToString(dr[0]);
lpogridview.Rows[i].Cells[1].Value = Convert.ToString(dr[1]);
lpogridview.Rows[i].Cells[2].Value = Convert.ToString(dr[2]);
lpogridview.Rows[i].Cells[3].Value = Convert.ToString(dr[3]);
lpogridview.Rows[i].Cells[4].Value = Convert.ToString(dr[4]);
lpogridview.Rows[i].Cells[5].Value = Convert.ToString(dr[5]);
lpogridview.Rows[i].Cells[6].Value = Convert.ToString(dr[6]);
lpogridview.Rows[i].Cells[7].Value = Convert.ToString(dr[7]);
i++;
}
dr.Close();
0