what is wrong in this 4 lines ?

ahmed fahd

this code gives me error of
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

        Dim i As Integer = 0

        For Each r As DataRow In dt.Rows

            DataGridView1.SelectedRows(i).Cells("emp_name") = dt.Rows(i)("Emp_Name")
            DataGridView1.SelectedRows(i).Cells("emp_id") = dt.Rows(i)("Emp_ID")
            DataGridView1.SelectedRows(i).Cells("date_") = dt.Rows(i)("Day_Dat")

            i = i + 1
        Next

4 Replies

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

chellappan pandiarajan13y ago
If you want to bind the Datatable to Datagridview then you simply write a code like below

DataGridView1.Datasource = dt;
DataGridView1.DataBind();

-Pandian
DRISHTY13y ago
It is because DataGridView1.SelectedRows count is not equivalent to
dt.Rows count.
ahmed fahd13y ago
my datagridview has it's column names i selected some columns from sql table and gave it to datatable now i want to give the values from datatable to datagrid but i have to use index to put the values in the suitable datagridview column and row
chellappan pandiarajan13y ago
What you are trying to do...?
Binding Datatable to Grid view...?

Change the following
dt.rows(i)(""Emp_Name") to dt.rows("Emp_Name").ToString
dt.Rows(i)("Emp_ID") to dt.rows("Emp_ID").ToString
dt.Rows(i)("Day_Dat") to dt.rows("Day_Dat").ToString

Surely The error occured because of left side statement in FOR loop
Pls explain the concept then i will provide the solution..

-Pandian