How do I use a combobox for master-detail binding with a datagrid?

[Larry Woods]

I have a combobox that is populated with a list of names. When a name is
selected I want to populate a datagrid with name information. I have my
master-detail defined in my dataset and it works fine if I use a datagrid
for the master, instead of a combobox. But the combobox won't cause the
repopulation of the datagrid with the appropriate data. What's the trick?

TIA,

Larry Woods
cross-posted on ...dotnet.langu ages.vb.control s

[Ken Tucker [MVP]]

Hi,

Create a dataview to for the datagrid. Bind the datagrid to the
dataview. Filter the records in the combobox selected item changed event.

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 strConn As String

Dim strSQL As String

Dim da, daOrders As OleDbDataAdapte r

Dim conn As OleDbConnection

strConn = "Provider = Microsoft.Jet.O LEDB.4.0;"

strConn &= "Data Source = Northwind.mdb;"

conn = New OleDbConnection (strConn)

da = New OleDbDataAdapte r("Select * From Customers", conn)

da.Fill(ds, "Customers" )

daOrders = New OleDbDataAdapte r("Select * From Orders", conn)

daOrders.Fill(d s, "Orders")

dv = New DataView(ds.Tab les("Orders"))

ComboBox1.DataS ource = ds.Tables("Cust omers")

ComboBox1.Displ ayMember = "CustomerID "

DataGrid1.DataS ource = dv

End Sub

Private Sub ComboBox1_Selec tedValueChanged (ByVal sender As Object, ByVal e
As System.EventArg s) Handles ComboBox1.Selec tedValueChanged

Dim drv As DataRowView

Try

drv = DirectCast(Comb oBox1.SelectedI tem, DataRowView)

dv.RowFilter = "CustomerID = '" & drv.Item("Custo merID").ToStrin g & "'"

Catch ex As Exception

End Try

End Sub

Ken
----------------------
"Larry Woods" <la***@NOSPAMlw oods.com> wrote in message
news:uy******** *****@TK2MSFTNG P11.phx.gbl...
I have a combobox that is populated with a list of names. When a name is
selected I want to populate a datagrid with name information. I have my
master-detail defined in my dataset and it works fine if I use a datagrid
for the master, instead of a combobox. But the combobox won't cause the
repopulation of the datagrid with the appropriate data. What's the trick?

TIA,

Larry Woods
cross-posted on ...dotnet.langu ages.vb.control s