Hi,
Dim ds As New DataSet
Dim dv As DataView
Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim conn As SqlConnection
Dim strConn As String
Dim strCmd As String
Dim da, daProducts As SqlDataAdapter
Dim strServer As String = "(local)"
strConn = String.Format(" Server = {0};", strServer)
strConn &= "Database = Northwind; Integrated Security = sspi;"
conn = New SqlConnection(s trConn)
da = New SqlDataAdapter( "Select * From Categories", conn)
da.Fill(ds, "Categories ")
daProducts = New SqlDataAdapter( "Select * from Products", conn)
daProducts.Fill (ds, "Products")
dv = New DataView(ds.Tab les("Products") )
With cmbCategories
..DataSource = ds.Tables("Cate gories")
..DisplayMember = "CategoryNa me"
..ValueMember = "CategoryID "
End With
With cmbProducts
..DataSource = dv
..DisplayMember = "ProductNam e"
End With
End Sub
Private Sub cmbCategories_S electedValueCha nged(ByVal sender As Object, ByVal
e As System.EventArg s) Handles cmbCategories.S electedValueCha nged
Try
dv.RowFilter = "CategoryID = " & cmbCategories.S electedValue.To String
Catch
End Try
End Sub
Ken
------------------------------
"pmcguire" <pm******@discu ssions.microsof t.com> wrote in message
news:94******** *************** ***********@mic rosoft.com...
Hmm. I don't really understand.
You mean use a filtered DataView as the second ComboBox's DataSource? I am
already doing that. The problem isn't obtaining the list of values needed
for the ComboBox, the problem is that I want to bind the SelectedValue of
the
two ComboBoxes to columns in another table. When PositionChanged fires,
Combo1 and Combo2 both get new values; however, in general, the value Combo2
gets from its currency manager is not yet present in its list, so after
Combo1_Selectio nIndexChanged fires (somewhat later) and Combo2 synchs up,
the
BindingContext interprets Combo2 as having modified the record.
Forgive me if I'm being dense, but does your solution solve this? And if
so, could you show me an example of how to do what you are describing?
Thanks,
Pat
"Ken Tucker [MVP]" wrote:
Hi,
Bind the second combobox to a dataview. Use the
dataview.rowfil ter
method to only show the right records.
Ken
---------------
"pmcguire" <pm******@discu ssions.microsof t.com> wrote in message
news:4C******** *************** ***********@mic rosoft.com...
I have 2 bound ComboBoxes. I want the datasource of the second to be
limited
by the selection made in the first. I can do this by responding to the
SelectionIndexC hanged event on the first, but this results in the
BindingContext' s Current.Row.Row state becoming 'Modified' whenever the
BindingContext position changes. What is the RIGHT way to go about this?
Thanks,
--
Pat
