Here I will explain how to Link a combobox with a database. Before this I explain how to use a combobox.Step(1): Form with ComboBox
Drag and drop a combobox from the Toolbox.
Step(2): Coding
Now in the coding section make a function connected to the database and call this method in the constructor.
Void fillcombo()
{
string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";
SqlConnection con = new SqlConnection(str);
string query = "select * from tablename";
SqlCommand cmd = new SqlCommand( query,con);
sqldatareader dbr;
try
{
con.open();
dbr = cmd.executereader();
while(dbr.read())
{
string sname = (string) myreader["name"];; //name is coming from database
combobox1.items.Add(sname);
}
catch(execption es)
{
messagebox.show(es.message);
}
}
}
Step(3): Output
When you run your application the data (we are fetching the name from the database) is to be stored in the combobox.
Comments
Join the conversation! Your thoughts help the community grow.