Index was outside the bounds of Array

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

.NET3.5

, +

Hi,

I have a table Company in my database from that I want to read the name where the code='12345'
but it shows exception as Index was outside the bound of Array

I wrote the code as follows

SqlCommand cmd = new SqlCommand();
SqlDataReader rdr = null;
conn.Open();
String str = "select name from Company where CCode='12345'";
cmd.CommandText = str;
cmd.Connection = conn;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
System.Windows.MessageBox.Show("Test");

this.txtname.Text = rdr.GetString(2)

}

Posted 20-Jan-10 23:26pm

LukmanulHakeem.T

Add a Solution

6 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)

Abhinav S · Answer 1 · 2010-01-20T23:40:00

Solution 1

LukmanulHakeem.T wrote:
where CCode

You've used CCode. Do you need to use Code instead?

Posted 20-Jan-10 23:40pm

Abhinav S

Rod Kemp · Answer 2 · 2010-01-20T23:42:00

Solution 2

You are only returning a single value from your query therefore the line;

this.txtname.Text = rdr.GetString(2);

will fail as you are telling it to get the third column from the result set, to get the first column use;

this.txtname.Text = rdr.GetString(0);

Posted 20-Jan-10 23:42pm

Rod Kemp

CPallini · Answer 3 · 2010-01-20T23:44:00

Solution 3

LukmanulHakeem.T wrote:
this.txtname.Text = rdr.GetString(2)

Change to:

this.txtname.Text = rdr.GetString(0)

Why did you use 2 as index while you have just one column (whose index is 0)?

Posted 20-Jan-10 23:44pm

CPallini

v2

Mehul M Thakkar · Answer 4 · 2010-01-20T23:44:00

Solution 4

Well you are accessing wrong column, as you are having only one column in you select statement. Just change your line

this.txtname.Text = rdr.GetString(2)

with

this.txtname.Text = rdr.GetString(0)

.

Then it should work.

Posted 20-Jan-10 23:44pm

Mehul M Thakkar

#realJSOP · Answer 5 · 2010-01-21T00:19:00

Solution 5

USE THE DEBUGGER.

It would have allowed you to discover that there is only one item in the rdr object. Using a value greater than 0 will almost always result in an exception.

Posted 21-Jan-10 0:19am

#realJSOP

Updated 21-Jan-10 0:20am

v3

Indrajeet Sutar · Answer 6 · 2010-01-21T01:50:00

I have answer to your problem.
Your query does not return any row.. this means your reader has now rows. so how you can write

(if dr.read())   <br />
{<br />
..<br />
..<br />
}

use this

<br />
SqlCommand cmd = new SqlCommand();<br />
SqlDataReader rdr = null;<br />
conn.Open();<br />
String str = "select name from Company where CCode='12345'";<br />
cmd.CommandText = str;<br />
cmd.Connection = conn;<br />
rdr = cmd.ExecuteReader();<br />
if (rdr.HasRows)<br />
{<br />
while (rdr.read())<br />
{System.Windows.MessageBox.Show("Test");<br />
<br />
this.txtname.Text = rdr["column name"];<br />
}<br />
<br />
}<br />

I think this will definitely help you

if yes plz reply me..
inder2305@gmail.com