![]() That match the search and can be retrieved using ExecuteScalar. Instead of SELECT *, SELECT Count(*) will return the amount of records Also, you r using a datareader to check if a record is retrieved, which is unnecessary. In your example code your using a OleDbConnection (which is OK), a Command and a SQLDataReader.įurthermore, you don't close and dispose the connection, which is very important when using Access. Maybe you should take more time to answer. I also try some code but it bypasses the password, meaning if the username is exsisting on the db it will not confirmĭecker. Mydb = "SELECT * FROM accdb where = '" & idtext.Text Mystr = ("Provider=.4.0 " & _Ĭonnection = New OleDb.OleDbConnection(mystr) Private Sub login_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles login.Click 2 text boxes namely loginid.text and loginpass.text. ![]() While in my vb.net my main page form has the followings Uname and UPassword, the table is named as accdb and saved as useracc.mdb in 2k3 format. I am biginner regarding Database in vb.net Pls help on the codes that im working on. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |