In my code below as soon as the dropdownlist gets a selected value, the sub GETUSERINFO should load the textboxes but nothing happens
Protected Sub ddlAcctNum_TextChanged(sender As Object, e As System.EventArgs) Handles ddlAcctNum.SelectedIndexChanged
GETUSERINFO()
End Sub
Public Sub GETUSERINFO()
SqlUsrMaint.SelectCommand = "SELECT ACCTNUM, USERFIRST, USERLAST, CHANGEPASS, FTPPASS" & _
" 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)
txtFirstName.Text = dr.Item(1).ToString
txtLastName.Text = dr.Item(2).ToString
' Checking to se ...
Go to the complete details ...