I have one drop down list with acct numbers, once you select an account number it should populate the username dropdown list but it doesnt?
Protected Sub ddlAcctNum_SelectedIndexChanged(sender As Object, e As System.EventArgs) Handles ddlAcctNum.SelectedIndexChanged
If ddlAcctNum.SelectedIndex <> 0 Then
GETUSERNAMES()
GETUSERINFO()
End If
End Sub
Public Sub GETUSERNAMES()
SqlUsrMaint.SelectCommand = "SELECT ACCTNUM, USERNAME" & _
" FROM FTPUsers WHERE ACCTNUM='" & ddlAcctNum.Text & "'"
Dim dv As DataView = CType(SqlUsrMaint.Select(DataSourceSelectArguments.Empty), DataView)
If dv.Count > 0 Then
Dim i As Integer = 0
Do Until i = dv.Count
Dim dr As DataRowView = dv.Item(i)
ddlUsername.Text = dr.Item(0).ToString
...
Go to the complete details ...