Login form in window application through sqlserver connectivity using App.config file in ASP.Net with C#

*These namespaces are must be required for SqlServer Connectivity in your web form:-

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

App.config File

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

  <configSections>

  </configSections>

  <appSettings>

    <add key="ConnectionString" value="Data Source=PRADEEP-HP;Initial Catalog=Decofloore2;User ID=User_006;Password=user006"/>

  </appSettings>

</configuration>

Login.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace DemoWindowApplication

{

    public partial class Form2 : Form

    {            

        public Form2()

        {

            InitializeComponent();

        }

        private void btnLogin_Click(object sender, EventArgs e)

        {

            string StrCon = ConfigurationManager.AppSettings["ConnectionString"];

            SqlConnection SqlCon = new SqlConnection(StrCon);

            string SqlQuery = "Select UserName,Password from Registration where UserName='" + txtName.Text.Trim() + "' and Password='" + txtPass.Text.Trim() + "'";

            SqlCommand SqlComm = new SqlCommand(SqlQuery, SqlCon);

            SqlCon.Open();

            SqlDataReader dr;

            dr = SqlComm.ExecuteReader(CommandBehavior.CloseConnection);

            if (dr.Read())

            {

                if (txtName.Text.Trim() == dr["UserName"].ToString() && txtPass.Text.Trim() == dr["Password"].ToString())

                {

                    Form3 obj3 = new Form3();

                    obj3.Show();

                    this.Hide();

                }

            }

            else

            {

                lblMsg.Text = "Invalid User";

            }

        }

    }

}

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos