how to get values from database from datareader in text box and fileupload control in asp.net c#

Question

5.00/5 (1 vote)

See more:

Please someone tell that how to read value from database from datareader in asp.net c#. I have done my code but it throwing an error that dr is variable but is used like a method.
This is my code :

C#

cmd = new SqlCommand("select * from Images where id=" + DropDownList1 .SelectedValue + "",con);
            cmd.ExecuteReader();

            while(dr.Read ())
            {
                TextBox1.Text = dr(1);
            }

Please some one tell the solution

Thanks.

Posted 21-Apr-11 1:25am

chander_rani

Updated 21-Apr-11 1:34am

Tarun.K.S

v2

Add a Solution

4 solutions

Solution 1

Initialize dr like this :

SqlDataReader dr = cmd.ExecuteReader;

SQL

cmd = new SqlCommand("select * from Images where id=" + DropDownList1 .SelectedValue + "",con);
           SqlDataReader dr =  cmd.ExecuteReader();
            while(dr.Read ())
            {
                TextBox1.Text = dr[1].ToString();
            }

Posted 21-Apr-11 1:37am

Tarun.K.S

Updated 21-Apr-11 1:39am

v3

Comments

Toniyo Jackson 21-Apr-11 7:40am

Correct. My 5

Tarun.K.S 21-Apr-11 7:53am

Thanks buddy.

Member 10037441 8-May-13 11:15am

The solution was excellent! It helped me populate a listbox with the results of a query.

Solution 4

try to find out in the following way

int Id = int.parse(DropDownList1 .SelectedValue);

SQL

cmd = new SqlCommand("select * from Images where id= @Id",con);
cmd.parameters.addwithvalue("@Id",Id);

MIDL

while (dr.Read())
            {
                objProduct.ProductImage = dr["Imagename"].ToString();
            }

Posted 21-Apr-11 1:42am

Mahendra.p25

Comments

Tarun.K.S 21-Apr-11 7:56am

How is this going to solve the problem?

Mahendra.p25 21-Apr-11 8:00am

i just told him the way not exact solution

Tarun.K.S 21-Apr-11 8:09am

But if you tell him the exact solution first and then the way, it could solve the OP's answer better. OP doesn't know how to use the ExecuteReader command.

Mahendra.p25 21-Apr-11 8:12am

suggestion accepted

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)

OriginalGriff · Accepted Answer · 2011-04-21T01:37:00

Solution 2

Change

TextBox1.Text = dr(1);

To

TextBox1.Text = dr[1];

In addition, try using the field name instead of a number, particularly if you are going to return all fields via the "*" specifier - you don't say what order to return the fields in, so you don't know if column 1 exists, or what it contains...

Posted 21-Apr-11 1:37am

OriginalGriff

Comments

Toniyo Jackson 21-Apr-11 7:40am

Correct. My 5

Toniyo Jackson · Accepted Answer · 2011-04-21T01:38:00

Solution 3

Check this links. These will help you.

http://msdn.microsoft.com/en-us/library/haa3afyz%28v=VS.80%29.aspx[^]

http://blog.mdsohelrana.com/2008/07/02/how-to-use-datareader-in-cnet/[^]

I think you should use like this.

TextBox1.Text = dr[1];

Posted 21-Apr-11 1:38am

Toniyo Jackson

Updated 21-Apr-11 1:55am

v3

Comments

Tarun.K.S 21-Apr-11 7:56am

Updated the first link to include the C# version. 5+

Toniyo Jackson 21-Apr-11 7:58am

Thanks Tarun