Clearing out text in a textbox not working.

Question

0.00/5 (No votes)

See more:

So, if I enter a username like, Mike, and click on the password TextBox, an error message displays and says, "User Name Already Exist!!!". Then TextBox 1, 2 and 3 are cleared. Then I enter in a username that is in another database the message displays, "User Name Is Available. Please Create Password.". At this time I can create a new password but if I delete the current username and enter a different one that is not in the database I get this message,"User Name Is Available. Please Create Password." with the same data still in TextBox 2 and 3. I then can create a password using the data from the username that was valid and availble. How can I stop this? That is where I am stuck at.

C#

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

            SqlCommand scmd = new SqlCommand("Select INST_ID, EmailAddress, accessLevel from Table1 where EmailAddress = @TextBoxEA", con);
            SqlCommand scmd2 = new SqlCommand("Select INST_ID, EmailAddress, accessLevel from Table2 where EmailAddress = @TextBoxEA", con);

            scmd.Parameters.Add(new SqlParameter("@TextBoxEA", TextBoxEA.Text));
            scmd2.Parameters.Add(new SqlParameter("@TextBoxEA", TextBoxEA.Text));

            using (SqlDataReader dr = scmd.ExecuteReader())
            {
                while (dr.Read())
                {
                    TextBoxINST_ID.Text = dr["INST_ID"].ToString();
                    TextBoxaccessLevel.Text = dr["accessLevel"].ToString();
                }
            }

            using (SqlDataReader dr2 = scmd2.ExecuteReader())
            {
                while (dr2.Read())
                {
                    TextBoxINST_ID.Text = dr2["INST_ID"].ToString();
                    TextBoxaccessLevel.Text = dr2["accessLevel"].ToString();
                }
            }
            if (IsPostBack)
            {
                string cmdStr = "Select count(*) from Tablepass where EmailAddress='" + TextBoxEA.Text + "'";
                SqlCommand userExist = new SqlCommand(cmdStr, con);
                SqlCommand cmd = new SqlCommand("select INST_ID, EmailAddress from Tablepass", con);
                int temp = Convert.ToInt32(userExist.ExecuteScalar().ToString());
                if (temp == 1)
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('User Name Already Exist!!!');", true);
                    TextBoxINST_ID.Text = string.Empty;
                    TextBoxaccessLevel.Text = string.Empty;
                    TextBoxEA.Text = string.Empty;
                }
                else if (temp == 0)
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('User Name Is Available. Please Create Password.');", true);
                    //TextBoxINST_ID.Text = string.Empty;
                    //TextBoxaccessLevel.Text = string.Empty;
                    //TextBoxEA.Text = string.Empty;
                }
                
            }
        }
    }
}

Posted 21-Nov-13 4:29am

Computer Wiz99

Updated 21-Nov-13 7:10am

v5

Add a Solution

Comments

TryAndSucceed 21-Nov-13 11:01am

I think you might have to set the ReadOnly as false before setting the value. Not sure though.

Computer Wiz99 21-Nov-13 11:04am

I was thinking about that but it works on the other forms that have the same properties set the same way. And those TextBoxes are used for math operators. I will test it out to see.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Nov-13 11:07am

I guess Enabled="False" is the problem.

Computer Wiz99 21-Nov-13 11:11am

No, neither on worked. I have other TextBoxes in the same setup and they clear out. What makes these so different? I will still try different things.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Nov-13 11:12am

Now remove both the Enabled="False" ReadOnly="True" and try.

Computer Wiz99 21-Nov-13 11:14am

Yeah, I did that already.

Maciej Los 21-Nov-13 11:36am

And... Have you see any changes?

Computer Wiz99 21-Nov-13 11:37am

No. I am still testing.

Computer Wiz99 21-Nov-13 11:45am

Ok, I have an issue. When I enter a valid username and press tab or click any where on the form, error message fires that says, "User Name Already Exist!!!" which is good but TextBox 2 and 3 auto populate with a number that does not match the username in TextBox 1. Then when I enter an invalid username, message fires and TextBox 2 and 3 stays the same with the same number that populated when I entered a valid username. Why is that?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Nov-13 11:56am

Look, I can't understand the flow yet and nothing works automatically.
You can debug each line and check where exactly it is assigning values to TextBox.

One more thing is remove Enabled="False" ReadOnly="True" and keep it simple first.
Then debug inside Button Click event. See where exactly is the problem.

Computer Wiz99 21-Nov-13 11:57am

Ok. I follow you. I think I need more coffee.

Computer Wiz99 21-Nov-13 12:36pm

Ok. I found it. I took my code that was in Page_Load out and put it at the bottom of the TextBox_TextChange and it worked. There is only one issue that i am stuck at. If a user enters in a valid username and tab or click to the next TextBox, the TextChange finds the data and populates TextBox 2 and 3. Which is good but, if the user wants to delete the username and enter in another username that is not in the database it will allow the user to create the new username with the populated fields. Why is that?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Nov-13 12:55pm

So, you should clear those TextBoxes when user again enters data into that username box, simple.

Computer Wiz99 21-Nov-13 13:07pm

You would think so. It only does it when you enter a username that is already in a database. So, if I enter a username like, Mike, and click on the password TextBox, an error message displays and says, "User Name Already Exist!!!". Then TextBox 1, 2 and 3 are cleared. Then I enter in a username that is in another database the message displays, "User Name Is Available. Please Create Password.". At this time I can create a new password but if I delete the current username and enter a different one that is not in the database I get this message,"User Name Is Available. Please Create Password." with the same data still in TextBox 2 and 3. I then can create a password using the data from the username that was valid and availble. How can I stop this? That is where I am stuck at.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Nov-13 13:37pm

Can you clear these TextBoxes as soon as you enter to TextChanged event?
I mean code for clearing should go first. Check that.

Computer Wiz99 21-Nov-13 13:48pm

How do you mean? Clear the TextBoxes before the TextChange event or after?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Nov-13 1:10am

I mean to say the codes for clearing should go first like below...

protected void TextBoxEA_TextChanged(object sender, EventArgs e)
{
TextBox1.Text = string.Empty;
TextBox2.Text = string.Empty;
TextBox3.Text = string.Empty;

// Now other codes....

}

Computer Wiz99 22-Nov-13 5:50am

Ok, Thanks. Can you put that in a Solution.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Nov-13 6:04am

Yeah doing it now.

Computer Wiz99 22-Nov-13 8:31am

OK. That does work but I had to put it in Page Load. It worked at the TextChange but not the way I needed it to. But I did get it to work. Thanks!!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-Nov-13 9:28am

Okay. Good. Thanks for accepting the answer. :)

joshrduncan2012 21-Nov-13 14:39pm

To clear out textboxes, I would suggest doing something similar to this:

textBox.Text = "";

Computer Wiz99 21-Nov-13 14:45pm

I was using, "TextBox.Text = string.Empty;"

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-11-22T00:06:00

As per the discussion with OP, the problem was...

Quote:
It only does it when you enter a username that is already in a database. So, if I enter a username like, Mike, and click on the password TextBox, an error message displays and says, "User Name Already Exist!!!". Then TextBox 1, 2 and 3 are cleared. Then I enter in a username that is in another database the message displays, "User Name Is Available. Please Create Password.". At this time I can create a new password but if I delete the current username and enter a different one that is not in the database I get this message,"User Name Is Available. Please Create Password." with the same data still in TextBox 2 and 3. I then can create a password using the data from the username that was valid and availble.

And my suggestion was to...

Codes for clearing the TextBoxes should go first like below...

C#

protected void TextBoxEA_TextChanged(object sender, EventArgs e)
{
    TextBox1.Text = string.Empty;
    TextBox2.Text = string.Empty;
    TextBox3.Text = string.Empty;

    // Now other codes....

}