ComboBox and textbox

Question

I designed a change password form and would like to give this option to Admin to see full name of user on comboBox and when he selected the user, username appear on the Label or Textbox,

Table User:

Firstname:

Lastname:

Username:

Password:

Email:

Notification

Combobox--> show Firstname + lastname

Lable : Display username belong to selected item value from combo box.

Please share your idea.

Thnak you

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Fetch_multi_in_combobox { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings[dsn]; OleDbCommand com; OleDbDataAdapter oda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { comboBox1.Text = Select; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from emp; com = new OleDbCommand(str con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds emp); for (int i = 0; i { comboBox1.Items.Add(ds.Tables[0].Rows[i][Firstname] + ds.Tables[0].Rows[i][Lastname].ToString()); } con.Close(); } private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from emp where Firstname+Lastname=' + comboBox1.SelectedItem + '; com = new OleDbCommand(str con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { label1.Text = reader[Username].ToString(); } reader.Close(); con.Close(); } } }

Nazhand Zareei · Answer

Can you please help me in this matter as well After selected value from combobox display username on Textbox (Username) or Label

Kunal Vaishya · Answer

Use Query like this Select Eid FirtsName+' '+LastName as FullName  EAddressEsal from Employee. Combobox1.DataSource=ds.Tables[0]; Combobox1.DisplayMemberPath= FullName ; Combobox1.ValueMemberPath= Eid ;

Vishal Gilbile · Answer

Hello Friend What you can do is in your sql query you can merge the values of the two columns and provide an alias name to the new column. What I want to say is the following. let's say i've one table named employee with fields as eid efnameelnameeaddressesal so inorder to display the firstname and lastname of employee on combobox together I can write my query like the following. Select Eid eFName+' '+eLName as Name  EAddressEsal from Employee. Now while setting the combobox DataSource I can write like the following. combobox1.DataSource=ds.Tables[0].DefaultView; combobox1.DisplayMemberPath=Name; Hope that solves your problem. With Regards Vishal Gilbile.

Satyapriya Nayak · Answer

private void Form1_Load(object sender EventArgs e) { comboBox1.Text = Select; OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select * from emp; com = new OleDbCommand(str con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds emp); for (int i = 0; i { comboBox1.Items.Add(ds.Tables[0].Rows[i][Firstname] +   + ds.Tables[0].Rows[i][Lastname] + ); } }