Our Training Programs

All contents are copyright of their authors.

how to bind drop down lists in c#?

how to bind drop down lists in c#?

Sam thota

7yAsked Jan 28, 2019, 1:56 AM763Learn iOS Programming

private void comboBoxComNS_SelectedIndexChanged(object sender, EventArgs e)//country

{

ModelBind();

string str = Convert.ToString(comboBoxComNS.SelectedValue);

SqlCommand cmd = new SqlCommand("Select MODELNUM from TBL_MODEL where COMPID=@compid", conn);

cmd.Parameters.AddWithValue("@compid", str);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds, "Modelnew");

comboBoxMNS.DataSource = ds.Tables["Modelnew"];

}

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Salman Beg7y ago
Hi. The code looks good to me. Are you facing any error? Can you please check whether you are getting any value in the dataset or not. Thanks
Sanwar Ranwa7y ago
Hello Sam

Please check these Links

https://www.c-sharpcorner.com/UploadFile/rohatash/binding-dropdownlist-with-database-and-display-data-in-gridv/

https://www.codeproject.com/Questions/412998/bind-data-to-dropdownlist-with-csharp

https://www.c-sharpcorner.com/UploadFile/deveshomar/ways-to-bind-dropdown-list-in-Asp-Net-mvc/
Vivek Kumar7y ago
Hi Sam,
Please find below link for your references.

https://stackoverflow.com/questions/27597250/how-to-bind-database-values-to-combo-box-in-windows-application

https://www.c-sharpcorner.com/UploadFile/009464/bind-combobox-in-window-application-using-C-Sharp/

https://www.c-sharpcorner.com/blogs/binding-data-with-combo-box-in-window-form-application-c-sharp