IndexOutOfRangeException was unhandled by user code

Question

0.00/5 (No votes)

See more:

Hi Friends,

what is the reason for occurring this problem whenever execute the C# Code also retrieving the records from SQL server?

pls comments...

Posted 2-Nov-10 19:19pm

velmahesh

Add a Solution

4 solutions

Solution 2

IndexOutOfRange exception is thrown when you attempt to access (Read/ Write) an element of an array with an index which is outside the bounds of the array

As per your problem, I guess you are trying to read or write some array elements which are outside of your array boundary.

Posted 2-Nov-10 19:55pm

Abhijit Jana

Comments

Hiren solanki 3-Nov-10 2:02am

Yes, that is the issue i wanted to post in GIT but I thought it will be considered as bagging of point request. another one is also as accepted answer but it's also having downvote, See http://www.codeproject.com/Answers/123821/How-can-we-Give-Spaces-in-EmptyDataText-of-gridvie.aspx#answer2

Hiren solanki 3-Nov-10 2:02am

Below answer is a reply to your comment in my answer.

Solution 4

C#

int ScriptId = 0;
               string sql = "Select Max(ScriptId) from tbl_Script";
               SqlCommand cmd = new SqlCommand(sql, connection);
               using (var reader = cmd.ExecuteReader())
               {
                   //while (reader.Read())
                   //{

                       if (reader["ScriptId"] == System.DBNull.Value)
                       {
                           ScriptId += 1;
                       }
                       else
                       {
                           ScriptId = ScriptId++;
                       }
                   //}
               }

this is my code i am face same error (IndexOutOfRangeException was unhandled) this is an issue pls let me know ans

Posted 13-Feb-14 23:22pm

Arjunwalmiki

Solution 5

your getting only one value here so executescalar() method instead executereader()

Posted 14-Feb-14 0:06am

Member 10476757

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)

Hiren solanki · Accepted Answer · 2010-11-02T19:27:00

Solution 1

It's error related when you are retriving index record which is not exist.

See if there's 5 elements in array, But when you are trying to retrieve record at index 6 then it will generate Exception of kind IndexOutOfRangeException.

See HERE[^] for more details.

Please vote and Accept Answer if it Helped.

Posted 2-Nov-10 19:27pm

Hiren solanki

Comments

Abhijit Jana 3-Nov-10 2:00am

didn,t find any reason why some one voted it 1. Though it was correct answer. I voted 5 ! Thanks

Hiren solanki 3-Nov-10 2:04am

Thanks abhijit.

Abhijit Jana 3-Nov-10 2:07am

Don't know why someone voted it 1, though it was correct answer :( ! I voted 5.