How to Create Login Window in C# using SQL Server Database in Visual Studio

 Hello Everyone, If you are planning to study C# programming for your project or if you are interested to learn C# Programming, Then, i am going to write one article about the C# related project (a small project/application) using Window Form Application in Visual Studio which is the very basic but very important guideline for you. But this will be very important project for you if you do not try before. As you all know C# is an Event Driven Programming Language this features enable us to drag and drop some controls like button, textbox, labels etc directly rather than writing code for them and this actually save your time when you are programming and also make us easy to program. This project will show you how to drag and drop controls from tools into your window form and how to connect your application to database which is the important and most basic knowledge you should know when you are making a complex system using C#.

So, i am going to give you demonstration about how to create login window using C# which is based on windows form application through the video. So, please do watch following video for this little but very important project.

Source Code: Inside the Login Button Click Event!

       
{
            SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\RanBahadurBK\Documents\testlogin.mdf;Integrated Security=True;Connect Timeout=30");
            SqlDataAdapter sda = new SqlDataAdapter("select count(*) from login where username ='" + textBox1.Text + "' and password='" + textBox2.Text + "'", conn);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            if (dt.Rows[0][0].ToString() == "1")
            {
                this.Hide();
                Main mm = new Main();
                mm.Show();
            }
            else
            {
                MessageBox.Show("please enter correct username and password", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }


       
 

Watch Video