Llenado dropdown en base a otro

[mrprogman]

si funciona pero me vuelve a cargar todos los registros y solo necesito que cargue, el utimo...que puede ser..? este es el codigo


Dim DS As DataSet
Dim MyConnection As SqlConnection = New SqlConnection("Data Source=192.168.10.20;Initial Catalog=papeleria;User ID=sa;Password=stm01")
Dim MyCommand As SqlDataAdapter
Dim suborden As String
DropDownList8.AppendDataBoundItems = True

For i As Integer = 0 To DropDownList1.Items.Count - 1

suborden = DropDownList1.Items(i).ToString
MyCommand = New SqlDataAdapter("SELECT id FROM [articulos] where descripcion= '" & suborden & "' ", MyConnection)


DS = New DataSet()
MyCommand.Fill(DS, "articulos")


DropDownList8.DataSource = DS.Tables("articulos").DefaultView
DropDownList8.DataBind()


Next i
MyConnection.Close()