show output in label

Question

0.00/5 (No votes)

See more:

i want to give output in label after dropdownlist selected value query result.
but i get the output as---- System.Data.OleDb.OleDbDataReader ----

my code as follow

C#

protected void DDLWEEK7_SelectedIndexChanged(object sender, EventArgs e)
    {
        lblfrmdt.Visible = true;
        lbltodt.Visible = true;
       
        OleDbConnection con = new OleDbConnection("Provider=MSDAORA;User ID=sd;password=321;Data Source=User");       
        OleDbCommand cmd3 = new OleDbCommand("SELECT d1  FROM VIPUL_DATE WHERE dw='" + DDLWEEK7.SelectedValue + "'", con);
        OleDbCommand cmd4 = new OleDbCommand("SELECT d2  FROM VIPUL_DATE WHERE dw='"+DDLWEEK7.SelectedValue+"'", con);
     
        con.Open();
     
        OleDbDataReader DR1= cmd3.ExecuteReader();
        OleDbDataReader DR2= cmd4.ExecuteReader();
       
        lblfrmdt.Text +=DR1;
        lbltodt.Text += DR2;
    }

Posted 27-Jul-11 23:21pm

vipul_aug_1988

Updated 27-Jul-11 23:26pm

Tarun.K.S

v4

Add a Solution

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

Mahendra.p25 · Answer 1 · 2011-07-27T23:27:00

Solution 1

try to find out in the following way

C#

objReader = objCommand.ExecuteReader();
 while (objReader.Read())
{
 Label1.text += objReader["d1"].ToString();
}

Posted 27-Jul-11 23:27pm

Mahendra.p25

Updated 28-Jul-11 0:50am

v2

Comments

RaviRanjanKr 28-Jul-11 6:58am

Nice Answer, My 5 :)

Dalek Dave 28-Jul-11 7:25am

Good Call.

Mahendra.p25 28-Jul-11 8:13am

Thanks

walterhevedeich · Answer 2 · 2011-07-27T23:29:00

Solution 2

You're doing it wrong. You should have some sort of loop like this.

C#

while(DR1.Read())
{
   lblfrmdt.Text += DR1["d1"].ToString();
}

while(DR2.Read())
{
   lbltodt.Text += DR2["d2"].ToString();
}

Perhaps a little reading needs to be done. See the following for reference.
http://www.akadia.com/services/dotnet_data_reader.html[^]
http://msdn.microsoft.com/en-us/library/haa3afyz%28v=vs.71%29.aspx[^]

Posted 27-Jul-11 23:29pm

walterhevedeich

Comments

Dalek Dave 28-Jul-11 7:25am

Nice, gets a 5.

walterhevedeich 28-Jul-11 19:42pm

Thanks DD.

Tajuddin_HYD · Answer 3 · 2011-07-27T23:31:00

Solution 3

Just use like this

C#

while(DR1.Read())
{
   lblfrmdt.Text += DR1["d1"].ToString();
}

Posted 27-Jul-11 23:31pm

Tajuddin_HYD

Updated 27-Jul-11 23:46pm

v5

Tech Code Freak · Answer 4 · 2011-07-28T01:20:00

You have to add following after ExecuteReader():

while(DR1.Read())
{
   lblfrmdt.Text += DR1[0].ToString();
}
while(DR2.Read())
{
   lbltodt.Text += DR2[0].ToString();
}

Then,

DR1.Close(); DR2.Close(); con.Close();

DataReader needs to call Read() function first so that, it can iterate through the Rows returned by ExecuteReader().
DataReader retrieves data row by row as Read() is called.
First call to Read() gets the First row returned. And so on...
So, we use while() condition so that data is retrieved as long as Read() is true and some data is present in DataReader.
And you're done!