one datatable and two comboboxes? 1

[haddaway]

I have this code:

Private DTEntryTypes As New DataTable

---

Dim c1 As New DataColumn("OPERATOR", GetType(EventLogEventClass.OperatorT))
DTEventLogOperators.Columns.Add(c1)
Dim c2 As New DataColumn("DESC", GetType(String))
DTEventLogOperators.Columns.Add(c2)

' bind to comboboxes
cboEventLogCategory.DataSource = DTEventLogOperators
cboEventLogCategory.DisplayMember = "DESC"
cboEventLogCategory.ValueMember = "OPERATOR"
cboEventLogCategoryString.DataSource = DTEventLogOperators
cboEventLogCategoryString.DisplayMember = "DESC"
cboEventLogCategoryString.ValueMember = "OPERATOR"

Dim d2 As DataRow = DTEventLogOperators.NewRow
d2("DESC") = "AND"
d2("OPERATOR") = EventLogEventClass.OperatorT.SQLAND
DTEventLogOperators.Rows.Add(d2)
Dim d3 As DataRow = DTEventLogOperators.NewRow
d3("DESC") = "OR"
d3("OPERATOR") = EventLogEventClass.OperatorT.SQLOR
DTEventLogOperators.Rows.Add(d3


The problem is that when I change selected item in one combobox the selected item is also changed in the other one? I thought that the content(datatable) had nothing todo with the selected item. Do I have to have several datatables or can I solve it in any other way?

 

[ca8msm]

Do I have to have several datatables or can I solve it in any other way?

You can either have two datatables or instead of binding them both, you can loop through the datatable and add an item to each combobox for each row in the datatable.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.