How to handle this exception:Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Question

1.00/5 (1 vote)

See more:

C#

private void Daily_Attendance_Load(object sender, EventArgs e)
{
      DataTable dailyattendance = new DataTable();
      dailyattendance = emp.viewallemployee(); //Function  for selecting all data from table
     for (int i = 0; i < dailyattendance.Rows.Count; i++)
     {
         dataGridView1.Rows[i].Cells[0].Value = dailyattendance.Rows[i][0].ToString();                 
         dataGridView1.Rows[i].Cells[1].Value = dailyattendance.Rows[i][1].ToString();
         dataGridView1.Rows[i].Cells[2].Value = dailyattendance.Rows[i][2].ToString();
         dataGridView1.Rows[i].Cells[3].Value = dailyattendance.Rows[i][3].ToString();
     }
}

Posted 3-Feb-13 22:00pm

jacobjohn196

Add a Solution

Comments

jacobjohn196 4-Feb-13 4:02am

We need to display the data from the table using the datagridview. But it shows an error message "Index was out of range " when we try to assign the data from the data table to datagridview.
How can we solve this problem?
Thanks

Sergey Alexandrovich Kryukov 4-Feb-13 4:03am

You hard-code indices 0 to 3, but how you guarantee that all that elements exist?
Use the debugger, and you will see.
—SA

jacobjohn196 4-Feb-13 4:09am

Thank you Sergey, But I have only four fields in the table.

Sergey Alexandrovich Kryukov 4-Feb-13 4:12am

Use the debugger or output/log exception stack, and you will see. Why taking guesses?
—SA

2 solutions

Solution 2

Without knowing which exact line the error occurs on, we can't help you with a specific answer.
The best (indeed pretty much only) solution is to use the debugger.
Put a breakpoint on the first line in the method:

C#

DataTable dailyattendance = new DataTable();

And single step though it.
You can examine each variable at each step and decide what should happen, then compare that with what did happen when you actually run the line.

Only then will you have anywhere near enough information to start solving this!

Posted 3-Feb-13 22:16pm

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jibesh · Accepted Answer · 2013-02-03T22:14:00

If you are using DataTable the simplest method is Binding the dataTable with your datagridview i.e

C#

datagridView.DataSource = dailyAttendance;

You can find numerous article here in code project on how to bing dataTable to datagridview one is Important facts about datagridview[^]

Now coming back to the "Index was out of range" exception it may be when you try to access the row, the cells of the datagirview or the dataTable rows or cells which is not explained in your question. debug your application to identify which variable throws this exception datagrid or dataTable and add the columns to match.

my initial thought is you forget to add datagridviewRow instance to the Rows before you access 'dataGridView1.Rows[i]'