what is wrong in this 4 lines ?

Question

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

chellappan pandiarajan · Answer

If you want to bind the Datatable to Datagridview then you simply write a code like below DataGridView1.Datasource = dt; DataGridView1.DataBind(); -Pandian

DRISHTY · Answer

It is because DataGridView1.SelectedRows count is not equivalent to dt.Rows count.

ahmed fahd · Answer

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 pandiarajan · Answer

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