Dropdownlist - relations-asp.net-how to?

[Ravi]

I am trying to represent master-detail records from a database
The general logic will be populating the first dropdownlist with the master records and on change of the first dropdownlis
getting the selectedindex and querying the database and populating the childrecords in the second dropdownlist

But my question is how the same can be acheieved by using "Relations"

The following code fragment i tried, but i have no idea how to proceed

Thanks in advanc
Ravichandra

Dim myconn As Strin
Dim oledataadapt As New OleDbDataAdapte
Dim oledataadapt1 As New OleDbDataAdapte
Dim ds As New DataSe
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Loa
'Put user code to initialize the page her

myconn = "Provider=MSDAO RA;User ID=x;Password=x ;Data Source=xxx;
oledataadapt = New OleDbDataAdapte r("Select Organization_id from bengine.cb_orga nization", myconn
oledataadapt.Fi ll(ds, "Sector"

oledataadapt1 = New OleDbDataAdapte r("Select Superbu_id, organization_id from bengine.cb_supe r_businessunit" , myconn
oledataadapt1.F ill(ds, "SBU"
ds.Relations.Ad d("Sec_sbu", ds.Tables("Sect or").Columns("O rganization_id" ),
ds.Tables("SBU" ).Columns("Orga nization_id")
If Not IsPostBack The
DropDownList1.D ataSource = ds.Tables(0).De faultVie
DropDownList2.D ataSource = ds.Tables(1).De faultVie
DropDownList1.D ataMember = "Organization_i d
DropDownList2.D ataMember = "superbu_id
DropDownList1.D ataTextField = "Organization_i d
DropDownList1.D ataValueField = "Organization_i d
DropDownList2.D ataTextField = "superbu_id
DropDownList2.D ataValueField = "superbu_id
DropDownList1.D ataBind(
DropDownList2.D ataBind(
End I
End Su

Private Sub DropDownList1_S electedIndexCha nged(ByVal sender As Object, ByVal e As System.EventArg s) Handles DropDownList1.S electedIndexCha nge
Dim i As Intege
i = DropDownList1.S electedInde
DropDownList2.D ataSource = ds.Tables(0).Ro ws(i).GetChildR ows("Sec_sbu"
DropDownList2.D ataTextField = "superbu_id
DropDownList2.D ataValueField = "superbu_id
DropDownList1.D ataBind(
DropDownList2.D ataBind(
End Su

[Mary Chipman]

If I understand you correctly, you're trying to do is fetch data from
the server to populate the second dropdown. So don't think Relations,
think WHERE clause in your SELECT statement. If you've already fetched
the data into another DataTable in the DataSet, then you can set the
relations.

--Mary

On Sun, 16 May 2004 21:16:02 -0700, "Ravi"
<an*******@disc ussions.microso ft.com> wrote:

I am trying to represent master-detail records from a database.
The general logic will be populating the first dropdownlist with the master records and on change of the first dropdownlist
getting the selectedindex and querying the database and populating the childrecords in the second dropdownlist.

But my question is how the same can be acheieved by using "Relations" ?

The following code fragment i tried, but i have no idea how to proceed.

Thanks in advance
Ravichandran

Dim myconn As String
Dim oledataadapt As New OleDbDataAdapte r
Dim oledataadapt1 As New OleDbDataAdapte r
Dim ds As New DataSet
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here

myconn = "Provider=MSDAO RA;User ID=x;Password=x ;Data Source=xxx;"
oledataadapt = New OleDbDataAdapte r("Select Organization_id from bengine.cb_orga nization", myconn)
oledataadapt.Fi ll(ds, "Sector")

oledataadapt1 = New OleDbDataAdapte r("Select Superbu_id, organization_id from bengine.cb_supe r_businessunit" , myconn)
oledataadapt1.F ill(ds, "SBU")
ds.Relations.Ad d("Sec_sbu", ds.Tables("Sect or").Columns("O rganization_id" ), _
ds.Tables("SBU" ).Columns("Orga nization_id"))
If Not IsPostBack Then
DropDownList1.D ataSource = ds.Tables(0).De faultView
DropDownList2.D ataSource = ds.Tables(1).De faultView
DropDownList1.D ataMember = "Organization_i d"
DropDownList2.D ataMember = "superbu_id "
DropDownList1.D ataTextField = "Organization_i d"
DropDownList1.D ataValueField = "Organization_i d"
DropDownList2.D ataTextField = "superbu_id "
DropDownList2.D ataValueField = "superbu_id "
DropDownList1.D ataBind()
DropDownList2.D ataBind()
End If
End Sub

Private Sub DropDownList1_S electedIndexCha nged(ByVal sender As Object, ByVal e As System.EventArg s) Handles DropDownList1.S electedIndexCha nged
Dim i As Integer
i = DropDownList1.S electedIndex
DropDownList2.D ataSource = ds.Tables(0).Ro ws(i).GetChildR ows("Sec_sbu")
DropDownList2.D ataTextField = "superbu_id "
DropDownList2.D ataValueField = "superbu_id "
DropDownList1.D ataBind()
DropDownList2.D ataBind()
End Sub