Hi

I have a simple question . I need to bind data to two drop down list box . I have two drop down list box ( Dropdownlist1 & Dropdownlist2 ) which need be populated by two XML file ( XML1 & XML2 ) . The data coming out of SQL server database in XML format . I have to populate the first drop down box and based on the value user choose I have to populate the second drop down box with second box . How to do that . Please help . Hete is my code

artial Class WebUserControl
Inherits System.Web.UI.UserControl

Private connectionstring As String ''= webConfigurationManager.ConnectionString("MDMORT").ConnectionString
Public Shared dsConfigarator As New DataSet
Private Sub binddata()

' Closed for testing by kaushik
If Not Me.IsPostBack Then
Dim con As New SqlConnection(connectionstring)
'Dim selectSQL As String = ("")
' Dim cmd As New SqlCommand(selectSQL, con)
DropDownList1.DataSource = dsConfigarator.Tables(0)
DropDownList1.DataTextField = "SABLE_PROD_GRP"
DropDownList1.DataValueField = "PROD_FAMILY_DESC"
dsConfigarator.ReadXml("C:\XML1")
DropDownList1.DataBind()
'con.Close()


DropDownList1.SelectedIndex = -1



End If
End Sub



Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
binddata()
End Sub
End Class