populate combobox by passing parameter to seperate class

[redspiderke]

Hi, I have +20 comboboxes in my windows app. and thought its best to have the code in a seperate class and than call that class and pass the parameters using a constructor... With this one function I hope to fill every combo box that i have in my application from a database table. But not sure how to get started with it. thanks Wouter

[Not Active]

First I'd say from a UI perspective 20+ comboboxes on a screen is probably not the best design. Think about breaking them up with tabs, or sub forms if it makes sense. What you can do is iterate through the controls collection to find each combobox and set the properties accordingly. Or you could set DataBinding between the comboboxes and your datatable

---

I know the language. I've read a book. - _Madmatt

[redspiderke]

I have 14 forms and 20 combo's in total, So each form has max 2 comboboxes on it.

[Not Active]

More reasonable then. DataBinding, IMO, would be the best approach in this case.

---

I know the language. I've read a book. - _Madmatt

[redspiderke]

Mark, Thanks, the answer was indeed easyer than the question, solved the problem ! In class "cls_role.cs":

public DataTable GetRols()
{
DataTable DT = new DataTable();
string Query = "GetRols";
DT = _dbHelper.ExecuteDataTable(Query);
return DT;
}

In Winform:

private void GetRols()
{
Cls_Role Role = new Cls_Role();
cmbRole.DataSource = Role.GetRols();
cmbRole.DisplayMember = "Role_Name";
cmbRole.ValueMember = "Role_ID";
}

I was thinking to complex :-D