this code gives me error of... Index was out of range

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(i) = dt.Rows(i)("Emp_ID")
            DataGridView1.SelectedRows(i).Cells(i) = dt.Rows(i)("Emp_Name")
            DataGridView1.SelectedRows(i).Cells(i) = dt.Rows(i)("Day_Dat")

            i = i + 1
        Next

is there a problem clear here ? :(

Santhosh Kumar Jayaraman · Answer

Am not sure what you are trying to achieve here. Because for selected rows also you call index i and for cells also you call index i. So now what happends if you have total of 2 rows and selected only one row second time inside the loop it will become DataGridView1.SelectedRows(1).Cells(1) = dt.Rows(1)(Emp_ID) But there is only one selected row. Similarly If there are only 4 cells in a row and you have 10 rows then again when you say cell(6) it will throw index out of range In general index out of range will come if you dont have any element in that index. If we get more requirements from you we can exactly say which line error occurred

sanjeev pandey · Answer

Dear ahmed maybe yout datatable has less rows data than selected rows of the datagridview.

Dinesh Bhoje · Answer

Have u resolved your problem..

Santhosh Kumar Jayaraman · Answer

@Riddhi i have explained in your another post plz check there http://www.c-sharpcorner.com/Forums/Thread/198310/handle-exceptions-and-debugging.aspx

Riddhi Valecha · Answer

UserName - riddhi Password - riddhi

Riddhi Valecha · Answer

Hi...sure... Thanks in advance.... The attached zip is my code....

Santhosh Kumar Jayaraman · Answer

@riddhi Please share your project

Riddhi Valecha · Answer

Hi.......Can you send me your code/application ?? I will try to fix your issue...... Santosh: Please help me out in Silverlight issues dear....... In my Silverlight Chat Application when I debug the login page and redirect to next page the control again comes back to login page and starts debugging... I don't know what to do with it.... Please help... Thanks in advance...

Santhosh Kumar Jayaraman · Answer

Put a breakpoint and debug. Check where it throws error  which row and which cell

ahmed fahd · Answer

still giving error Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index :( although we are using the correct and suitable index

Santhosh Kumar Jayaraman · Answer

I meant the actual index of column in your table Check this sample grid example EmpId EmpName Dept 1 Santhosh HR 2 Kumar Account Now using your code if i have selected both the records then first time i=0 then DataGridView1.SelectedRows(0).Cells(0) = dt.Rows(0)(Emp_ID) table will become EmpId EmpName Dept new empId Santhosh HR 2 Kumar Account DataGridView1.SelectedRows(0).Cells(0) = dt.Rows(0)(Emp_Name) EmpId EmpName Dept new EmPname Santhosh HR 2 Kumar Account DataGridView1.SelectedRows(0).Cells(0) = dt.Rows(0)(Day_Dat) EmpId EmpName Dept new daydate Santhosh HR 2 Kumar Account So everytime its updating only EmpId column for each row. So i meant use actual index. which is for empid column index will be always 0 empname it will be 1 dept will always be 2. So i asked you to rewrite like Dim i As Integer = 0 For Each r As DataRow In dt.Rows DataGridView1.SelectedRows(i).Cells( 0 ) = dt.Rows(i)(Emp_ID) DataGridView1.SelectedRows(i).Cells( 1 ) = dt.Rows(i)(Emp_Name) DataGridView1.SelectedRows(i).Cells( 2 ) = dt.Rows(i)(Day_Dat) i = i + 1 Next

ahmed fahd · Answer

what do you mean with actual index dear? please could you give me small sample ?

Santhosh Kumar Jayaraman · Answer

then you have to give actual index for cells instead of i right? Because in your current code you are updating same cell again and again with three columns. First time you are updating cell 1 with Empid second line updating the same cell with empname like this

ahmed fahd · Answer

you are right but the rows not fixed i have to take the 3 of 4 columns values from sql table and give them to specified columns in my datagridview so i tried to do loop for the rows i retrieved and give them to the datagrid