comboBox_SelectedIndexChanged

Question

hey...
i'm working on windows form, and on that form i have a comboBox that attached to a dataBase, and several empty
textBoxes that dosen't attached to anything...
now what i want is this:
when i choose a value from the comboBox then the empty textBoxes will fill with data from the dataBase...
for example, if the comboBox attached to a "person" table to the "ID" column, then when i choose an ID number from the comboBox then the empty textBoxes will fill with that same person data, like age,birthDate,height exc...

i know that i'm suppose to use the function "SelectedIndexChanged", but how?
if someone can help me or even post a similer example it will help alot
thanks!

Vulpes · Answer

Assuming that ID is set as the primary key of the table, try something like this: private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { DataTable dt = (DataTable)comboBox1.DataSource; int id = (int)((DataRowView)comboBox1.SelectedItem)["ID"]; DataRow dr = dt.Rows.Find(id); textBox1.Text = dr["age"].ToString(); textBox2.Text = ((DateTime)dr["birthDate"]).ToString("MM/dd/yyyy"); textBox3.Text = dr["height"].ToString(); }

Satyapriya Nayak · Answer

Hi roi, please refer this link http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/8561/" If this post help you please mark it as answer

Vulpes · Answer

I'm guessing here as I don't know exactly how you bound comboBox4 to the DataTable in the first place but I'd try instead: BindingSource bs = (BindingSource)comboBox4.DataSource; DataTable dt = (DataTable)bs.DataSource; int apartmentNum = (int)((DataRowView)comboBox4.SelectedItem)["aptNum"]; DataRow dr = dt.Rows.Find(apartmentNum); textBox6.Text = dr["floor"].ToString();

roi kruv · Answer

hey vulpes... thank you for your help. i'v tried your code but i get an error, thats my code: ("aptNum" is the primary key of Apartment table) DataTable dt = (DataTable)comboBox4.DataSource; int apartmentNum = (int)((DataRowView)comboBox4.SelectedItem)["aptNum"]; DataRow dr = dt.Rows.Find(apartmentNum); textBox6.Text = dr["floor"].ToString(); i get the following error: Unable to cast object of type 'System.Windows.Forms.BindingSource' to type 'System.Data.DataTable' . i'v tried to googel the error but nothing helpful came out, got any ideas?

Satyapriya Nayak · Answer

Hi roi, Normal 0 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 combobox_textbox_data { public partial class Form2 : Form { string ConnectionString = System.Configuration. ConfigurationSettings .AppSettings[ "dsn" ]; OleDbCommand com; OleDbDataAdapter oledbda; DataSet ds; string str; public Form2() { InitializeComponent(); } private void Form2_Load( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "select * from employee" ; com = new OleDbCommand (str, con); OleDbDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[ "empid" ]); } reader.Close(); con.Close(); comboBox1.Text = "select" ; textBox1.Text = "" ; textBox2.Text = "" ; textBox3.Text = "" ; textBox4.Text = "" ; } private void comboBox1_SelectedIndexChanged( object sender, EventArgs e) { OleDbConnection con = new OleDbConnection (ConnectionString); con.Open(); str = "select * from employee where empid='" + comboBox1.Text.Trim() + "'" ; com = new OleDbCommand (str, con); OleDbDataReader reader = com.ExecuteReader(); if (reader.Read()) { textBox1.Text = reader[ "empname" ].ToString(); textBox2.Text = reader[ "sal" ].ToString(); textBox3.Text = reader[ "empaddress" ].ToString(); textBox4.Text = reader[ "phoneno" ].ToString(); } con.Close(); reader.Close(); } } } If this post help you please mark it as answer

Ahmad Abu Eid · Answer

// open you connection string SqlStr = "Select * From person where id= " + comboBox1.SelectedValue.ToString(); SqlDataAdapter da = new SqlDataAdapter (SqlStr, Your Sql Connection); DataTable dt = new DataTable(); try { da.Fill(dt); } catch { //Error } finally { close your connection } //now fill the boxes LabelFname.Text = dt.Rows[0]["FullName"].ToString(); LabelCity.Text = dt.Rows[0]["ProvinceName"].ToString();

comboBox_SelectedIndexChanged

Server/Instance Level Configuration Check

I/O distribution Analysis

SQL Server Resource Wait Stats Analysis

Index Analysis

TempDB Space Review

Database Files (MDF, NDF) and Log File Inspection

Fragmentations and Defragmentations

Backup and Recovery health Check

Log Reviews (Windows Event Logs, SQL Server Error Logs and Agent Logs)

Hardware Review

DBCC Best Practices Implementations

Deadlock Detection and Resolutions Hands-On