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

Bind textbox when select combobox values

Answers (1)