debrino4000
New Member
- Joined
- Jul 13, 2016
- Messages
- 1
Private Sub btnok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnok.Click
If Cmbusertype.Text = "Admin" Then
sql = "select * from tbl_login where log_usertype='" & Cmbusertype.Text & "' and log_username='" & Txtusername.Text & "' and log_pass='" & Txtpassword.Text & "'"
If rs.State = 1 Then rs.Close()
rs.Open(sql, conn, 1, ) <"this is where i get the error"
If rs.EOF = False Then
usertype = Cmbusertype.Text
userid = Txtusername.Text
Cmbusertype.Text = ""
Txtpassword.Text = ""
Txtusername.Text = ""
If Cmbusertype.Text = "Admin" Then
sql = "select * from tbl_login where log_usertype='" & Cmbusertype.Text & "' and log_username='" & Txtusername.Text & "' and log_pass='" & Txtpassword.Text & "'"
If rs.State = 1 Then rs.Close()
rs.Open(sql, conn, 1, ) <"this is where i get the error"
If rs.EOF = False Then
usertype = Cmbusertype.Text
userid = Txtusername.Text
Cmbusertype.Text = ""
Txtpassword.Text = ""
Txtusername.Text = ""