Login Page Creation in C#

This blog defines login page in C#.

Lets we see how to create a login page in C#.NET. The Beginners can easily create a login page in C#.net using the following Steps

Steps:

1. Create a Database in SQL Server 2005
2. Create a C#.net project in c#.net
3. Connect the Created Database with the Created C#.net project
4. Generate Code
5. Check the Login page(Testing)

Step 1: Create a Database in SQL Server 2005

Give your correct local Server name, Username and Password

After that you can see the following window

Then follow the steps:



Give the Database name as Login

Now the Database has been created successfully. The following steps will show the table creation in SQL Server. Double click the Database, Now you can see the following window and select the table



Column Creation

Give a name for Table

Created Table

Open the Table

Entering Contents into the Table

Step 2: Create a C#.net project in c#.net

Open visual studio

Create a new project

Choose Visual C# windows application

Give the Project name

Place controls on form

Now the project has been created...!

Step 3: Connect the Created Database with the Created C#.net project

Give the correct servername , Username and password The Servername, Username,Password all are same as the sqlserver 2005

Choose the Use SQL Server Authentication

After entering Correct servername,Username and Password you can choose the Database form list of Databases

Choose the Login Database

Check the Connection

Step 4: Generate Code

Add the namespace : using System.Data.SqlClient;

The connection String is mus need for connect the Database with our project

Click the server explorer and then click the login database

Now you can see the connection string in properties window:

Copy the Connection string and paste it in the code window

Now click F5 to check the Database Connection

Now Copy the Following code and paste it with in the button click method

if (textBox1.Text == "" || textBox2.Text == "")
{

}

else

{

    SqlCommand scmd;

    SqlDataReader sdr;

    scmd = new SqlCommand("select Username,Password from tbl_Check where USername=@Username and Password=@Password",sc);

    scmd.Parameters.AddWithValue("@Username",textBox1 .Text .ToString ());

    scmd.Parameters.AddWithValue("@Password",textBox2 .Text .ToString ());

    sdr = scmd.ExecuteReader();

    if (sdr.HasRows)

   {

       sdr.Close();

       MessageBox.Show("Welcome- The Username and Password is Correct", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);

  }

   else

   {

        MessageBox.Show("Invalid Username or Password", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);

   }

} 

Step 5: Check the Login page(Testing)

Give the Correct username and password, that is already stored in the tbl_Check table

Give the Wrong username and Password

The Beginners can use this way to create a simple Login page