Login Form Using Visual Basic 2010 with Embbeded database Microsoft Access Tutorial

Submitted by ClydeTiu on Thursday, December 13, 2018 - 22:25.

Language


In this source code you will learn on how to create a login form and connect VB.net to Microsoft Access.

Creating Database
Database
- First you create a database in microsoft access
- copy what is on the image shown above.

Step 1
Open Microsoft Visual Studio 2010 and create a new windows form application for vb.
Open VB

Step 2
Create your User Interface.
U.I

Step 3
Connect VB to MS ACCESS
Step 1

Step 2

Step 3

Step 4

Step 5

Step 4
Code for Log in Button

  1. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  2. 	Dim con As New System.Data.OleDb.OleDbConnection("Provider = Microsoft.jet.OleDB.4.0;Data Source = " & Application.StartupPath & "\datastorage.mdb;")
  3. 	Dim cmd As OleDbCommand = New OleDbCommand( _
  4. 	"SELECT * FROM logininfo WHERE Username = '" & _
  5. 	TextBox1.Text & "' AND [Password] = '" & txtPassword.Text & "' ", con)
  6.  
  7. 	con.Open()
  8.  
  9. 	Dim sdr As OleDbDataReader = cmd.ExecuteReader()
  10.  
  11. 	If (sdr.Read() = True) Then
  12. 		MessageBox.Show("You are Now Logged In")
  13. 		frm1.Show()
  14. 		TextBox1.Focus()
  15. 		TextBox1.Clear()
  16. 		txtPassword.Clear()
  17.  
  18. 		Me.Hide()
  19. 	Else
  20. 		MessageBox.Show("Invalid Username or Password!")
  21. 	End If
  22. End Sub

Code for cancel button

  1. If MsgBox("Do you want to exit?", vbYesNo + vbQuestion) = vbYes Then
  2. 	Application.Exit()
  3. End If
  4.  
  5. Code for show password check box:
  6.  
  7. <vbnet>
  8. If CheckBox1.Checked = True Then
  9. 	txtPassword.PasswordChar =""
  10. Else
  11. 	txtPassword.PasswordChar = "•"
  12. End If

Hope you learn basic coding guys .... if you have questions contact me:
Support Developer by donation GCASH : 09454339345
SMART: 09100047158

gmail : [email protected]
Facebook : Clyde Chectopher A. Tiu

Tags

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

About text formats
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
  • 139 views