Set value of text from database into another textbox

Question

0.00/5 (No votes)

See more:

Hi , i have a WebApp which contains 2 textboxes (txtName and txtID). txtName is populated from a queryString i.e.

C#

String Brkc = Request.QueryString["Name"];
txtName.Text = Name;

I have a stored procedure to find the ID from the database for whichever name is populated in the textbox.

The problem is , i want to populate the txtID textbox with the ID from the text that is in txtName.

thanks.

Posted 1-Sep-11 21:54pm

Rico_

Add a Solution

Comments

CodingLover 2-Sep-11 4:01am

You mean that on content changed of the txtName you need to find the ID and fill?

Rico_ 2-Sep-11 4:05am

yes

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

Prerak Patel · Answer 1 · 2011-09-01T22:11:00

Solution 1

0. Open connection.
1. Create command with query "select id from table where name = '" + txtName.Text +"'" or your procedure.
2. Use String id = cmd.ExecuteScalar();
3. Use id wherever you want txtID.Text = id;

Posted 1-Sep-11 22:11pm

Prerak Patel

Updated 1-Sep-11 22:33pm

v3

Comments

DominicZA 2-Sep-11 4:18am

No, I dont think this is right. He already has the proc to get the ID, we wants to know where!

Rico_ 2-Sep-11 4:24am

Hi , i already have the ID. i need to populate the txtID textbox with the ID.

DominicZA · Answer 2 · 2011-09-01T22:15:00

How many names are you using here? You could create a static Dictionary in a Cache.cs file. Just update the dictionary when another user is created, this will take a load off the DB, so your Cache.cs would have the following:

C#

private Dictionary<string,> _users = null;
public Dictionary<string,> Users
{
get
{
     if (_users == null)
         MethodThatPopulatesUsers();
     return _users;
}
}

public void ClearUserCache()
{
     _users = null;
}

private void MethodThatPopulatesUsers()
{
    //Make the call to the DB and populate the dictionary with the username as the Key and the ID as the value. 
}

Then, where your textbox is, on the OnTextChanged event just have:

C#

if (Cache.Users.ContainsKey(txtTextbox1.Text))
    txtTextbox2.Text = Cache.Users[txtTextbox1.Text];