Database Values in Textbox For Combobox Selection in Windows Forms

Here I will explain how to create a combobox such that when a name is selected from the combobox then all the details are shown in respective textboxes.

Step(1): Form with combobox

Drag and drop a combobx from the Toolbox.

Step(2): Coding

Click on the combobox and write this code.



Private Void comboBox1.SelectedIndexChanged(object sender , EventArgs e)
{
string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";
SqlConnection con = new SqlConnection(str);
string query = "select * from tablename where name = '"+combobox1.text+"' ";
SqlCommand cmd = new SqlCommand( query,con);
sqldatareader dbr;
try
{
con.open();
dbr = cmd.executereader();
while(dbr.read())
{
string sID = (string) dbr["ID"].tostring;
string sname = (string) dbr["name"] // name is string value
string ssurname = (string) dbr["surname"]
string sage = (string) dbr["age"].tostring;
textbox1.text = sid;
textbox2.text = sname;
textbox3.text = ssurname ;
textbox4.text = sage;
}
catch(execption es)
{
messagebox.show(es.message);
}
}
}
Step(3): Output

Run your application and click on the name in the combobox.

You can also go to my blog_munesh .

Up Next
    Ebook Download
    View all
    Learn
    View all