How to Create Login Form in Visual Studio and Connect With SQL Server

Now the final design looks like this type.

Step 8. To connect with a SQL Server database right-click on the form and click on properties then go to the upper second option (Data Binding). In Data Binding click the text area and it will look like this.

Now click on Add Project data Source.

Step 9. Then open these windows select “Database” click Next then select “Dataset” and click Next again select “Dataset” and click Next then click on New Connection then click the Refresh Button then select your SQL Server name. For example, my SQL name is KRISHNA-PC\SQLEXPRESS for the select radio button select or enter a database name for example my database name is STUDENT then click Test Connection and click the OK Button.

Click the connection string to show this type of connection string then select and copy then click on "Next" again click the Next tick table and the finish button now see the window:

This is SQL Server 2008 Database Details and show here the user id and Password. You use only these three passwords for this login form.

Step 10. This is the coding part of this application below.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace login_form
{
    public partial class Form1 : Form
    {
        SqlConnection con = new SqlConnection();
        public Form1()
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=KRISHNA-PC\\SQLEXPRESS;Initial Catalog=STUDENT;Integrated Security=True";

            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'sTUDENTDataSet.login' table. You can move, or remove it, as needed.
            //this.loginTableAdapter.Fill(this.sTUDENTDataSet.login);
            SqlConnection con = new SqlConnection("Data Source=KRISHNA-PC\\SQLEXPRESS;Initial Catalog=STUDENT;Integrated Security=True");
            con.Open();

            {
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=KRISHNA-PC\\SQLEXPRESS;Initial Catalog=STUDENT;Integrated Security=True";
            con.Open();
            string userid = textBox1.Text;
            string password = textBox2.Text;
            SqlCommand cmd = new SqlCommand("select userid,password from login where userid='" + textBox1.Text + "'and password='" + textBox2.Text + "'", con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
                MessageBox.Show("Login sucess Welcome to Homepage http://krishnasinghprogramming.nlogspot.com");
                System.Diagnostics.Process.Start("http://krishnasinghprogramming.blogspot.com");
            }
            else
            {
                MessageBox.Show("Invalid Login please check username and password");
            }
            con.Close();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
    }
}

So friends this article will help you to create a Login Form in Visual Studio and connect with SQL Server. The next time I will put some more interesting commands, thank you. I hope this is helpful for you. Enjoy :).