Skip to main content

How to Create a Login System in C# and MS Access Database


In this tutorial, I will teach you how to create a simple login system using c# and ms access database. This method is a good start for you when you are dealing with MS Access database and c#. This is very easy to understand most especially by beginners in programming. All you have to do is follow the instructions that are shown below.

Creating Application

Step 1

Open Microsoft Visual Studio 2015 and create a new windows form application for c#.
ps1

Step 2

Do the form just like shown below.
ps2

Step 3

Open the code editor by pressing the F7 on your keyboard. In the code editor, add a namespace to access OleDB libraries

  1.  
  2. using System.Data.OleDb;

Step 4

Create a connection between C# and MS Access database. After that, declare all the classes and a string variable that is needed.

  1.  
  2. OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application .StartupPath + "\\logindb.accdb");
  3. OleDbCommand cmd;
  4. OleDbDataAdapter da;
  5. DataTable dt;
  6. string sql;

Step 5

Create a function for retrieving the total number of rows in the database.

  1.  
  2. private int login(string sql)
  3. {
  4. int maxrow = 0;
  5. try
  6. {
  7. con.Open();
  8. cmd = new OleDbCommand();
  9. da = new OleDbDataAdapter();
  10. dt = new DataTable();
  11.  
  12. cmd.Connection = con;
  13. cmd.CommandText = sql;
  14.  
  15. da.SelectCommand = cmd;
  16. da.Fill(dt);
  17.  
  18. maxrow = dt.Rows.Count;
  19. }
  20. catch(Exception ex)
  21. {
  22. MessageBox.Show ( ex.Message);
  23. }
  24. finally
  25. {
  26. da.Dispose();
  27. con.Close();
  28. }
  29. return maxrow;
  30. }

Step 6

Write the following code for the login process.

  1.  
  2. private void button1_Click(object sender, EventArgs e)
  3. {
  4. int maxrow = 0;
  5. sql = "Select * From tbluser WHERE u_name = '" + textBox1.Text + "' AND u_pass='" + textBox2.Text + "'";
  6. maxrow = login(sql);
  7.  
  8. if(maxrow > 0)
  9. {
  10. MessageBox.Show("Welcome User");
  11. groupBox1.Enabled = false;
  12. label3.Text = "Welcome " + dt.Rows[0].Field<string>("fullname") + " | Logout" ;
  13.  
  14. textBox1.Clear();
  15. textBox2.Clear();
  16. }
  17. else
  18. {
  19. MessageBox.Show("Your username and Password is incorrect.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
  20. }
  21. }

Step 7

Write the following code in the logout process.

  1.  
  2. private void label3_Click(object sender, EventArgs e)
  3. {
  4. groupBox1.Enabled = true;
  5. label3.Text = "Login System";
  6. }

The complete source code is included you can download it and run it on your computer.

For any questions about this article. You can contact me @
Email – [email protected]
Mobile No. – 09305235027 – TNT
Or feel free to comment below.

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

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.