want to search empdata in textbox by providing empid in text

Question

i have a database(employee1) column(empnameempidempaddressempeducation). now i have a textbox and a button now i want when i enter emp id in textbox and click on button.it will show me that employee data in that textbox. pls provide me code plsssss

Ranjit Powar · Answer

In button click write following code SqlConnection con= new SqlConnection(Connectinstring); SqlDataAdapter da = new SqlDataAdapter(select * from table name where empid='+textbox.text+' con); DataTable dt = new DataTable(); da.Fill(dt); txtEmpName.Text=dt.Rows[0][empname].ToString();

Gowtham Rajamanickam · Answer

button click bind your search query

Upendra Pratap Shahi · Answer

Bind your search query on button click and take output in textbox.