only 1st value is shown after selected from from the combo box in text box in asp.net c#

Question

0.00/5 (No votes)

See more:

Please someone tell, after select the id from combobox, it shows in the text box only 1st record of the table, and other 2,3,4 is not showing, my code is

C#

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

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

Pls, someone tell that why 2,3 and 4th id data is not showing.

Thanks.

Posted 21-Apr-11 2:10am

chander_rani

Updated 21-Apr-11 2:16am

Not Active

v2

Add a Solution

Comments

willempipi 21-Apr-11 8:18am

Check your DropDownList1.SelectedValue in debug to see which id you use. The code above should work, otherwise supply more code please.

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

E.F. Nijboer · Answer 1 · 2011-04-21T02:17:00

Each time you overwrite the previous value. Try this:

TextBox1.Text += dr[1].ToString();

Check out the msdn where they output to the console. In that case all is shown because each value is automatically added (and not overwritten):
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader.aspx#Y2907[^]

Good luck!

nit_singh · Answer 2 · 2011-04-21T02:18:00

Solution 3

The question is not explanatory but can understand little bit.
Try like that.

TextBox1.Text += dr[1].ToString();

Posted 21-Apr-11 2:18am

nit_singh

Updated 21-Apr-11 2:20am

v2

Not Active · Answer 3 · 2011-04-21T02:18:00

Solution 2

Your SQL query is asking for a specific record matching one ID, that is why only one is showing.

Posted 21-Apr-11 2:18am

Not Active

Prasanta_Prince · Answer 4 · 2011-04-21T03:34:00

SqlDataAdaptor adp=new SqlDataAdaptor("select * from Images where id=" + DropDownList1.SelectedValue + "",Con);
Dataset ds=new Dataset();

adp.Fill(ds);

for(int i=0;i<ds.tables[0].Rows.Count;i++)
{
TextBox1.text=ds.Tables[0].Rows[i]["FieldName"];

/* Here u use your own field I store it in TextBox. for your understand. */
}

palraj001 · Answer 5 · 2011-05-16T03:12:00

Solution 6

Hi !!
You have mentioned about Value Field of the DropDownList1. what about the Text Field of the DropDownList1. Is it same or different??.
I guess Text fields are same. so it takes first ID .

Posted 16-May-11 3:12am

palraj001