error in code of array

Question

0.00/5 (No votes)

See more:

Error:-Index was outside the bounds of the array
my code is:-

C#

SqlDataReader reader = cmd4.ExecuteReader();

  while (reader.Read())
  {
      Label6.Text = Convert.ToString(reader[0]);
      Label8.Text = Convert.ToString(reader[1]); //it gives error on this line.
      Label10.Text = Convert.ToString(reader[2]);
  }

so plz try to solve it...

Posted 12-Jun-12 19:29pm

Member 9027483

Updated 12-Jun-12 19:44pm

AmitGajjar

v4

Add a Solution

Comments

RDBurmon 13-Jun-12 9:30am

Thanks Everyone who replied to this thread , So Member********, I think you have got enough responses and you should be able to mark it as your answer and close the thread. Please do so.

3 solutions

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)

VJ Reddy · Answer 1 · 2012-06-12T19:44:00

As explained here http://msdn.microsoft.com/en-us/library/haa3afyz(v=vs.90).aspx[^], "You use the Read method of the DataReader object to obtain a row from the results of the query. You can access each column of the returned row by passing the name or ordinal reference of the column to the DataReader. However, for best performance, the DataReader provides a series of methods that allow you to access column values in their native data types (GetDateTime, GetDouble, GetGuid, GetInt32, and so on). For a list of typed accessor methods for data provider-specific DataReaders, see OleDbDataReader and SqlDataReader. Using the typed accessor methods, assuming the underlying data type is known, reduces the amount of type conversion required when retrieving the column value."

One possibility could be that the Row returned by the Reader may be having only one column.

Please but a bread point at Label6.Text and check the contents of the reader to see whether it has required number of columns. Otherwise, please check the cmd4 for ensuring to return the required number of columns. Further instead of using Convert.ToString the GetString method explained here http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.getstring(v=vs.90)[^] can be used as suggested in the above reference.

Sandeep Mewara · Answer 2 · 2012-06-12T19:48:00

The way you use DataReader is not correct.

Change to:

C#

SqlDataReader reader = command.ExecuteReader();
        int i=0;
        if (reader.HasRows)
        {
            while (reader.Read())
            {
                Console.WriteLine(reader[i].ToString());
                ++i;
            }
        }
        else
        {
            Console.WriteLine("No rows found.");
        }
        reader.Close();

Look at these:
Retrieving Data Using a DataReader (ADO.NET)[^]
DataReader Class[^]

**AmitGajjar** · Answer 3 · 2012-06-12T19:45:00

Solution 2

Hi,

Check if your command have how many column returned. it may happen only if required resource is not available.

Also post your command code to identify accurately.

thanks
-Amit

Posted 12-Jun-12 19:45pm

AmitGajjar

error in code of array

3 solutions

Solution 1

Solution 4

Solution 2

Add your solution here

Preview 0