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.

Add new comment