Bind textbox when select combobox values

Question

Hi How to bind textbox when selected combo value.I have send file for my code. please help me as soon as possible. Thanks

Satyapriya Nayak · Answer

Hi shubhangi We can do it in three different ways below private void Form1_Load(object sender System.EventArgs e) { // con.Open(); str = select * from student; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds student); comboBox1.DataSource = ds.Tables[student]; comboBox1.DisplayMember = sid; // con.Close(); } private void comboBox1_SelectedIndexChanged(object sender System.EventArgs e) { con.Open(); str = select * from student where sid=' + comboBox1.Text.Trim() + '; com = new SqlCommand(str con); SqlDataReader reader=com.ExecuteReader(); if( reader.Read()) { textBox1.Text = reader[sid].ToString(); textBox2.Text = reader[sname].ToString(); textBox3.Text = reader[smarks].ToString(); textBox4.Text = reader[saddress].ToString(); textBox5.Text = reader[year].ToString(); } con.Close(); reader.Close(); } --------------------------------------------------------------------------------------------- private void Form2_Load(object sender System.EventArgs e) { con.Open(); str = select * from student; com = new SqlCommand(str con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[sid]); } reader.Close(); con.Close(); } private void comboBox1_SelectedIndexChanged(object sender System.EventArgs e) { con.Open(); str = select * from student where sid=' + comboBox1.Text.Trim() + '; com = new SqlCommand(str con); SqlDataReader reader=com.ExecuteReader(); if( reader.Read()) { textBox1.Text = reader[sid].ToString(); textBox2.Text = reader[sname].ToString(); textBox3.Text = reader[smarks].ToString(); textBox4.Text = reader[saddress].ToString(); textBox5.Text = reader[year].ToString(); } con.Close(); reader.Close(); } ------------------------------------------------------------------------------------------- private void Form3_Load(object sender System.EventArgs e) { con.Open(); str = select * from student; com = new SqlCommand(str con); sqlda = new SqlDataAdapter(com); ds = new DataSet(); sqlda.Fill(ds student); dt=ds.Tables[student]; int i; for(i=0;i { comboBox1.Items.Add(dt.Rows[i].ItemArray[0]); } con.Close(); } private void comboBox1_SelectedIndexChanged(object sender System.EventArgs e) { con.Open(); str = select * from student where sid=' + comboBox1.Text.Trim() + '; com = new SqlCommand(str con); SqlDataReader reader=com.ExecuteReader(); if( reader.Read()) { textBox1.Text = reader[sid].ToString(); textBox2.Text = reader[sname].ToString(); textBox3.Text = reader[smarks].ToString(); textBox4.Text = reader[saddress].ToString(); textBox5.Text = reader[year].ToString(); } con.Close(); reader.Close(); } Thanks