Displaying data from SQL DB table into Textbox

Question

0.00/5 (No votes)

See more:

Hi,

I am new with asp.net. And not enjoying it so
so far.

I need to choose an item from the DropDownList
(Data linked with Data Source to SQL Table) and
populate info from same table into a textbox.

Please any help would be appriciated!!

Posted 28-Nov-11 19:57pm

Ben Paxton

Add a Solution

3 solutions

Solution 1

you should write the following code on dropdownlist selectedindexchanged event

VB

dim str as string 
str="select column from tablename where colname=@condition"
dim con as new SqlConnection("Data Source=.;Initial Catalog=master; uid=sa;pwd=12335")
dim cmd as new SqlCommand(str,con)
cmd.CommandType=CommandType.Text
cmd.Paramaters.AddWithValue("@condition",DropDownList1.SelectedValue)
dim adap as new SqlDataAdapter(cmd)

dim dt as new DataTable
adap.fill(dt)
TextBox1.text=dt.Rows(0)(0).ToString()

Posted 28-Nov-11 20:09pm

Member 7745088

Updated 28-Nov-11 22:48pm

v3

Comments

StianSandberg 29-Nov-11 2:13am

just a comment for Solution 1:
You should NEVER insert strings into a sql-statement like that. Use parameters to prevent sql-injections..

Solution 4

DataSet dtst_Equals = ObjCommon.GetObject.ExecuteQuery_Select(Connection.ConnectionString, "select Created_By from Tbl_Property_Master where Record_Id='" + Id + "'");
if (dtst_Equals.Tables[0].Rows.Count != 0)
{
drplst_Country.SelectedValue = dtst_get_details.Tables[0].Rows[0["Country"].ToString();
}

Posted 28-Nov-11 23:19pm

Mohammed Asif.K

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)

Prince Antony G · Accepted Answer · 2011-11-28T20:19:00

C#

AutoPostBack="True" OnSelectedIndexChanged="droplist1_SelectedIndexChanged"

C#

protected void droplist1_SelectedIndexChanged(object sender, EventArgs e)
   {
       using (SqlConnection con = new SqlConnection(conn))
       {
           string query = "select * from Login where uname='" + droplist1.SelectedValue + "' ";
           SqlDataAdapter da = new SqlDataAdapter(query, con);
           DataSet ds = new DataSet();
           da.Fill(ds);
           if (ds.Tables[0].Rows.Count > 0)
           {
               txtbox1.Text=ds.Tables[0].Rows[0].ItemArray[0].ToString();
           }
       }

   }