windows application using c#

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

how to display automatically respective name in textbox2 when id is typed in the textbox1?????

where table name : Employee Details
columns : EmployeeID, EmployeeNAME

my windows form looks as follows

Employee ID : textBox1 textBox2

when i type Employee ID in textBox1, it should automatically display the respective name in textBox2 for the ID in typed textBox1.

Posted 18-Feb-13 1:09am

Harsha24

Updated 18-Feb-13 1:25am

v2

Add a Solution

Comments

Shubh Agrahari 18-Feb-13 7:40am

please more clarify that what actually you want to ask that can help us to help you...

Shubh Agrahari 18-Feb-13 7:42am

now okk by v2

3 solutions

Solution 1

Hi. i suppose you use LINQ.

C#

private void TextBox1_TextChanged(object sender, TextChangedEventArgs e)
       {
           int id = Convert.ToInt32(TextBox1.Text);
           TextBox2.Text=//you must write :select Name from myTable where myTable.ID==id;
       }

your question isn't obvious.
you must determine your source. SQL table or List<string> ?

Posted 18-Feb-13 1:18am

aliwpf

Solution 2

Your question is not clear but i supposed you are fetching data from Database against a specific Id. you can do this in textChanged Event of the text box.

C#

 // here someFunctionWhichWillreturnNameAgainstId is a function which takes id as parameter and return the name.
private void textBoxId_TextChanged(object sender, EventArgs e)
        {
            string id = textBoxId.Text;
            textName.Text =  someFunctionWhichWillreturnNameAgainstId(id);
        }

    private string someFunctionWhichWillreturnNameAgainstId(string id) {
            string cm = "select EmployeeNAME from Employee Details where  EmployeeID=" + id;
            string constr = "you connection stirng";
            SqlConnection con = new SqlConnection(constr);
            SqlCommand sqlcmd = new SqlCommand(cm,con);
            object name   =  sqlcmd.ExecuteScalar();
            con.Close();
            return name.ToString();

            
        }

Posted 18-Feb-13 1:24am

Sm.Abdullah

Updated 18-Feb-13 1:45am

v2

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)

Shubh Agrahari · Accepted Answer · 2013-02-18T01:54:00

hi friend...

for this EmployeeID should be not duplicate(primary key in database)
and then the event of text chenge for textbox1 control you have to right the code...

C#

private void textBoxId_TextChanged(object sender, EventArgs e)
        {
      string empname="select EmployeeName from Employee_Details where   EmployeeID='"+textbox.text+"' ";
con.open()
MySqlCommand cmd = new MySqlCommand(empname, con);
MySqlDataReader dr = cmd.ExecuteReader();
if(dr.read)
{
textbox2.text=dr["EmployeeName"].tostring;
}
con.close();
        }

also use Namespace and connection String for SQL Server(if you using this database)
it is achiving that actually you want...
thanks