TextBox Text Change not working

Question

1.00/5 (2 votes)

See more:

I have a form to where you can enter a name in a textbox and it populates the next textbox. FOr some reason it is not working. What am I doing wrong? Here is my code:

C#

 protected void TextBoxLongName_TextChanged(object sender, EventArgs e)
        {
            SqlConnection con2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
            con2.Open();

            SqlCommand scmd2 = new SqlCommand("Select INST_ID, LongName from Table23 where LongName = '" + TextBoxINST_ID.Text + "'", con2);
            SqlDataReader dr2 = scmd2.ExecuteReader();

            if (dr2.Read())

            {
                TextBoxINST_ID.Text = dr2["INST_ID"].ToString();
            }
            dr2.Close();
            con2.Close();
        }
    }
}

Posted 12-May-14 5:35am

Computer Wiz99

Add a Solution

Comments

CHill60 12-May-14 11:39am

Define "not working"

Computer Wiz99 12-May-14 11:48am

It is not populating the textbox. When you enter a name in TextboxLongName and hit tab key or click anywhere on the form it should populate the TextBoxINST_ID but it does not. What did I do wrong?

Kornfeld Eliyahu Peter 12-May-14 11:50am

You may not hit the line at all! Debug it!

Computer Wiz99 12-May-14 11:52am

What do you mean?

Kornfeld Eliyahu Peter 12-May-14 11:53am

This line is conditional: TextBoxINST_ID.Text = dr2["INST_ID"].ToString();
Maybe the condition is false!!!

Computer Wiz99 12-May-14 11:54am

Ok. Hold on, Let me try something different.

Computer Wiz99 12-May-14 12:14pm

I changed it to populate by the ID and it worked but why will it not work when user enters a name?

1 solution

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)

sankarsan parida · Accepted Answer · 2014-05-12T06:24:00

Your code almost right.
You have given exact match condition. May be user input was wrong

See one more wrong input is here you are using TextBoxLongName textbox for input and search and this TextBoxINST_ID for to populate result. Hope so this is wrong so you have change this this.

protected void TextBoxLongName_TextChanged(object sender, EventArgs e)
        {
            SqlConnection con2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
            con2.Open();
 
            SqlCommand scmd2 = new SqlCommand("Select INST_ID, LongName from Table23 where LongName = '" + TextBoxLongName.Text + "'", con2);
            SqlDataReader dr2 = scmd2.ExecuteReader();
 
            if (dr2.Read())
 
            {
                TextBoxINST_ID.Text = dr2["INST_ID"].ToString();
            }
            dr2.Close();
            con2.Close();
        }
    }
}