Login User and User Registration in C# and SQL Server 2005

Login User and User Registration in C# and SQL Server 2005

In this Login user and user registration in C#,  you can’t gain access to the full content because you need to login first by filling up the fields on the registration form to have complete access to it.

It’s very important for a system to have a login form to provide security to any user who wants to access your system.

That’s why this tutorial will show you how to create a user registration form and login user. This is so easy and this is best for anyone who plans to build a system in the future.

But if you want to start how to code using visual studio 2019, you can start your lesson here on how to connect Mysql to visual Studio 2019.

Let’s begin:

Create a database and name it “dbguest“.

After that, do the following query for creating a table in the database that you have created.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblguest](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [GNAME] [nvarchar](50) NULL,
 [GUSERNAME] [nvarchar](50) NULL,
 [GPASS] [nvarchar](50) NULL,
 CONSTRAINT [PK_tblguest] PRIMARY KEY CLUSTERED 
(
 [ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Open Microsoft Visual Studio and create new windows form application. Then, do the form just like this.

Go to the solution explorer and hit the “code view” to fire the code editor.

In the code editor, declare all the classes and variables that are needed.

Note: Put “using System.Data.SqlClient;” above the namespace to access sql server library.

//initializes new instance 
 SqlConnection con = new SqlConnection();
 SqlDataAdapter da = new SqlDataAdapter();
 SqlCommand cmd = new SqlCommand();
 DataTable dt = new DataTable();
 //declare a variable
 string query;
 int result;

After that, create a method for registering the user.

 private void RegisterUser(string query)
 {
 //opening connection
 con.Open();
 try
 {
 //initialize a new instance of sqlcommand
 cmd = new SqlCommand();
 //set a connection used by this instance of sqlcommand
 cmd.Connection = con;
 //set the sql statement to execute at the data source
 cmd.CommandText = query;

 result = cmd.ExecuteNonQuery();

 if (result > 0)
 {
 MessageBox.Show("You are succesfully registered!");
 }
 else
 {
 MessageBox.Show("Failed to save.", "Failed", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
 }


 }
 catch (Exception ex)
 {
 //catching error 
 MessageBox.Show(ex.Message);
 }
 //closing connection
 con.Close();
 }

Then, create a method for logging in the user.

 private void LoginUser(string query)
 {
 //opening connection
 con.Open();
 try
 {
 //initialize a new instance of sqlcommand
 cmd = new SqlCommand();
 //set a connection used by this instance of sqlcommand
 cmd.Connection = con;
 //set the sql statement to execute at the data source
 cmd.CommandText = query;
 //initialize a new instance of sqlDataAdapter
 da = new SqlDataAdapter();
 //set the sql statement or stored procedure to execute at the data source
 da.SelectCommand = cmd;
 //initialize a new instance of DataTable
 dt = new DataTable();
 //add or resfresh rows in the certain range in the datatable to match those in the data source.
 da.Fill(dt);

 if (dt.Rows.Count > 0)
 {
 MessageBox.Show("You have login succesfully!");
 }
 else
 {
 MessageBox.Show("Account does not exist.","Failed" ,MessageBoxButtons.OK ,MessageBoxIcon.Exclamation);
 }


 }
 catch (Exception ex)
 {
 //catching error 
 MessageBox.Show(ex.Message);
 }
 //release all resources used by the component
 da.Dispose();
 //closing connection
 con.Close();
 }

Go back to the design view, double-click the form and do the following codes for the connection between SQL server and C#.net.

 private void Form1_Load(object sender, EventArgs e)
 {
 //set a connection between SQL server and Visual C#
 con.ConnectionString = "Data Source=.\\SQLEXPRESS;Database=dbguest;trusted_connection=true;";

 }

Go back to the design view again, double-click the “Register” button and call the method for registering the users that you have created.

 private void btnSave_Click(object sender, EventArgs e)
 {
 query = "INSERT INTO tblguest (GNAME,GUSERNAME,GPASS) VALUES ('" + txtName .Text +"','" + txtRegUsername.Text +"','" + txtRegPass.Text +"')";
 RegisterUser(query);
 }

Go back to the design view again, double-click the “Login” button and call the method for logging in the users that you have created.

private void btnLogin_Click(object sender, EventArgs e)
 {
 query = "SELECT * FROM tblguest WHERE GUSERNAME='" + txtUsername .Text + "' AND GPASS='" + txtPass .Text + "'";
 LoginUser(query);
 }

Output of Login user and user registration in C#:

For inquiries

If you have any questions or suggestions about this Login user and user registration in C# and SQL server 2005, please leave a comment below.

For all students who need a programmer for your thesis system or anyone who needs a source code in any programming language. You can contact me @ :
Email – [email protected]
Mobile No. – 09305235027 – talk’nText

Download the full source code Login user and user registration in C# below.

Download Source Code