In this blog we will know how to Display username belong to
selected item value from combo box.
Scenario
Fullname of user will be displayed
in comboBox and when the user, select Fullname corresponding Username will be
displayed in the Label control
Table User:
Firstname:
Lastname:
Username:
Password:
Email:
Notification
Combobox--> show Firstname +
lastname
Label: Display username belong to
selected item value from combo box.
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
Firstname_lastname_combo_username
{
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 < ds.Tables[0].Rows.Count;
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();
}
}
}