cara_ionutz
New member
- Joined
- Jan 29, 2013
- Messages
- 1
- Programming Experience
- Beginner
Hello,
I have this mysql data base
table 1
id userid username password site id
1 1 USER1 PASS1 1
2 1 user2 Pass2 1
table2
id siteid sitename
1 1 google
2 2 yahoo
i populate the combobx with table2 and when i select google site the results from table1 appear in two textboxes one for username and one for password.
this is my code for reading the result in textboxes, that show me only one results, what i need do for all results appear in textboxes, dynamical textboxes. when i add a new user and password for a specifc site to create automatic textboxes for viewing the results.
Private Sub ComboBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbCustID.SelectedIndexChanged
Label4.Text = cmbCustID.SelectedValue.ToString
Username.Clear()
Password.Clear()
connectiondb()
sql = "Select * from usernames where userid='" & Label4.Text & "' and siteid='" & cmbCustID.SelectedValue.ToString & "'"
cmd = New MySqlCommand(sql, cnn)
reader = cmd.ExecuteReader()
While reader.Read()
Username.Text = reader(2)
Password.Text = reader(3)
End While
connection_close()
End Sub
thank you
I have this mysql data base
table 1
id userid username password site id
1 1 USER1 PASS1 1
2 1 user2 Pass2 1
table2
id siteid sitename
1 1 google
2 2 yahoo
i populate the combobx with table2 and when i select google site the results from table1 appear in two textboxes one for username and one for password.
this is my code for reading the result in textboxes, that show me only one results, what i need do for all results appear in textboxes, dynamical textboxes. when i add a new user and password for a specifc site to create automatic textboxes for viewing the results.
Private Sub ComboBox2_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbCustID.SelectedIndexChanged
Label4.Text = cmbCustID.SelectedValue.ToString
Username.Clear()
Password.Clear()
connectiondb()
sql = "Select * from usernames where userid='" & Label4.Text & "' and siteid='" & cmbCustID.SelectedValue.ToString & "'"
cmd = New MySqlCommand(sql, cnn)
reader = cmd.ExecuteReader()
While reader.Read()
Username.Text = reader(2)
Password.Text = reader(3)
End While
connection_close()
End Sub
thank you