How to enable a text box?

Question

0.00/5 (No votes)

See more:

Hi guys.

I have 3 text boxes. When I input an ID on the first text box and matches that ID in the Database, the two remaining text boxes will become enabled. If not, an error message will display. How to do that?

Posted 28-Aug-14 20:44pm

DarkDreamer08

Add a Solution

3 solutions

Solution 1

1. Default status of the two text boxes define as disables
2. When inter ID in first text box match the values with your id

C#

SqlDataReader reader = null;
SqlConnection conn = new SqlConnection("Yourconnectionstring");
    conn.Open();
    SqlCommand cmd = new SqlCommand("select * from yourtable where your_id=@URID", conn);
cmd.Parameters.AddWithValue("@URID",TextBox.Text);
   reader = cmd.ExecuteReader();
    if(reader!=null && reader.HasRows){
    //Enable TextBox2 and 3
    }

Posted 28-Aug-14 20:54pm

Gihan Liyanage

v2

Comments

Gihan Liyanage 29-Aug-14 3:00am

TextBox.Enabled = true;

DarkDreamer08 29-Aug-14 3:04am

Cant I just put the code to make the two text boxes enabled inside an event on the first text box?

Gihan Liyanage 29-Aug-14 3:06am

I dont have VS to test this code now, Any how you may allow it. And put and see what happen

DarkDreamer08 29-Aug-14 3:08am

I tried it inside the _TextChange event. But it does not happen.

Solution 2

Use UpdatePanel. Have a look at the following links. You will know what to do.

http://msdn.microsoft.com/en-us/library/system.web.ui.updatepanel(v=vs.110).aspx[^]

http://stackoverflow.com/questions/1525173/how-do-you-use-an-updatepanel-properly-asp-net[^]

Posted 28-Aug-14 20:56pm

debashishPaul

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)

Sinisa Hajnal · Accepted Answer · 2014-08-28T20:58:00

Solution 3

Assuming you use asp:TextBox:
1. add OnTextChanged="txtID_changed" in your markup
2. on the server add protected void txtID_changed(object sender, eventargs e) handler for your check
3. within the handler go to the database and validate your ID
4. if ID matches, txt2.Enabled = true; txt3.Enabled = true; else lblInfo.Text = "Error message" - lblInfo is the control you use to display messages to the user.

Assuming you use jQuery / Ajax
1. add onblur="retutn is_ID_valid(); in your input tag
2. add in your javascript tag function is_ID_valid()
3. check up the ID (jQuery.ajax call), if it matches add $("#txt2", "#txt3").attr("disabled", "false"); else show message to the user.

Posted 28-Aug-14 20:58pm

Sinisa Hajnal

Updated 28-Aug-14 21:30pm

v3

Comments

DarkDreamer08 29-Aug-14 3:16am

I tried the one you mentioned above. But nothing happens. Here is my code about that:
protected void systemid_TextChanged(object sender, EventArgs e)
{
s = WebConfigurationManager.ConnectionStrings["amicassa"].ConnectionString;
amicasaCon = new SqlConnection(s);
amicasaCon.Open();

SqlCommand cmd = new SqlCommand("SELECT system_id FROM users WHERE username = '"+username.Text+"'", amicasaCon);
SqlDataReader rd = cmd.ExecuteReader();
while(rd.Read())
{
a = rd[0].ToString();
if(a == systemid.Text)
{
password.Enabled = true;
repass.Enabled = true;
ImageButton1.Enabled = true;
}
}
rd.Close();
amicasaCon.Close();
}

Sinisa Hajnal 29-Aug-14 3:22am

What do you mean nothing happens? does the code execute? do you get id from the database? is systemid.Text empty?

you lack FROM in the select above. Also I strongly suggest you google sql injection attacks and transfer your query into stored procedure or at least httpUtility.Encode(username.Text).

Never trust user input.
What would happen if I entered username: '; DROP TABLE users; '
first apostrophe would close your query, then drop table would execute, second apostrophe would close your own apostrophe.