As title show. I still not able to connect my ms.access login database . Please help me ~
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb")
' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & "'", con)
Dim cmd As New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username = 'admin' AND Password = 'admin'", con)
con.Open()
Dim sdr As OleDb.OleDbDataReader
sdr = cmd.ExecuteReader()
' If the record can be queried, Pass verification and open another form.
If (sdr.Read() = True) Then
MessageBox.Show("The user is valid!")
Else
MessageBox.Show("The user is invalid!")
End If
sdr.Close()
con.Close()
2
Contributors
1
Reply
5 Hours
Discussion Span
3 Months Ago
Last Updated
3
Views
Related Article:SQL Problem - System.Data.OleDb.OleDbException was unhandled
is a solved VB.NET discussion thread by Tobyjug2222 that has 4 replies, was last updated 6 months ago and has been tagged with the keywords: sql, problem, visual, basic, 10, .net, oledb.