error in displaying data

Question

1.00/5 (1 vote)

See more:

Error:- Invalid attempt to read when no data is present.

my code is:-

C#

string jobcategory = "Select Job_Name from Job_Category where Industry_ID=@b;";
        SqlCommand cmd4 = new SqlCommand(jobcategory, cn);
        cmd4.Parameters.AddWithValue("b", b);
        SqlDataReader reader = cmd4.ExecuteReader();
        Label6.Text = Convert.ToString(reader[0]);//here error this.
        Label8.Text = Convert.ToString(reader[1]);

how to solve this error plz help me friends....

Posted 12-Jun-12 2:29am

Member 9027483

Updated 12-Jun-12 7:05am

Maciej Los

v2

Add a Solution

Comments

Abhi KA 12-Jun-12 8:34am

if data is present ?

RDBurmon 13-Jun-12 9:25am

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.

6 solutions

Solution 1

Try

C#

SqlDataReader reader = cmd4.ExecuteReader();
if(reader.HasRows)
{
reader.Read();
Label6.Text = Convert.ToString(reader[0]);
Label8.Text = Convert.ToString(reader[1]);
}

Posted 12-Jun-12 2:34am

Sharma Richa

Updated 12-Jun-12 7:06am

v2

Comments

Member 9027483 12-Jun-12 8:42am

after trying above changes same error occure....give me another suggestion..

Sharma Richa 13-Jun-12 5:46am

Please see the another answer provided by me

Solution 2

C#

while (dr.read())
{
    //your logic here
Label6.Text = Convert.ToString(reader[0]);
Label8.Text = Convert.ToString(reader[1]);

}

Posted 12-Jun-12 2:36am

Abhi KA

Comments

Sharma Richa 12-Jun-12 8:37am

But if query return multiple records, then it will replace values of Labels again and again.

Abhi KA 12-Jun-12 8:51am

how many records get?

Solution 4

Hi
Your query is
Select Job_Name from Job_Category where Industry_ID=@b
You are fetching only Job_Name, but when assigning values to Labels You are using

C#

Label8.Text = Convert.ToString(reader[1]);

But your reader has only one value i.e. Job_Name
You can't use reader[1] because it is not present.

Posted 12-Jun-12 23:50pm

Sharma Richa

Solution 5

Hi,

Try this:

C#

string jobcategory = "Select Job_Name from Job_Category where Industry_ID=@b;";
SqlCommand cmd4 = new SqlCommand(jobcategory, cn);
cmd4.Parameters.AddWithValue("b", b);
SqlDataReader reader = cmd4.ExecuteReader();
while(reader.Read()){
   Label6.Text = Convert.ToString(reader[0]);
   Label8.Text = Convert.ToString(reader[1]);
}

All the best.
--AK

Posted 13-Jun-12 0:23am

AmitKumar89

v2

Solution 6

Try this:

string jobcategory = "Select Job_Name from Job_Category where Industry_ID=@b;";
SqlCommand cmd4 = new SqlCommand(jobcategory, cn);
SqlDataReader reader = cmd4.ExecuteReader();
while(reader.Read())
{
Label6.Text = reader[0].ToString();
Label8.Text = reader[1].ToString();
}

Posted 13-Jun-12 1:52am

Zukiari

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)

Sandeep Mewara · Accepted Answer · 2012-06-12T05:46:00

Solution 3

The way you are using DataReader looks incorrect.

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

Posted 12-Jun-12 5:46am

Sandeep Mewara

Comments

Maciej Los 12-Jun-12 13:10pm

Good links, my 5!

Sandeep Mewara 13-Jun-12 1:39am

Thanks.

Vani Kulkarni 13-Jun-12 23:38pm

5!

Sandeep Mewara 15-Jun-12 2:58am

Thanks.