Header Ads Widget

Responsive Advertisement

Ticker

6/recent/ticker-posts

Windows Login form using (C#)



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Air_Reservation_System
{
    public partial class Form1 : Form
    {
        SqlConnection con;
        SqlDataReader read;
        SqlCommand cmd;

        public Form1()
        {
          
            con = new SqlConnection("Data Source=SAADCHIPPA\\SQLEXPRESS;Initial Catalog=air_reservation;Integrated Security=True");
        }

     
    
               public void clear() {

            textBox1.Text = "";
            textBox2.Text = "";
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            this.ActiveControl = textBox1;

        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                con.Open();
                cmd = new SqlCommand("select username,password from Login where username=@user and password=@pass", con);
                cmd.Parameters.AddWithValue("@user", textBox1.Text);
                cmd.Parameters.AddWithValue("@pass", textBox2.Text);
                read = cmd.ExecuteReader();

                if (read == null)
                {
                    MessageBox.Show("The data is not fatched by the reader", "Data Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

                }
                else
                    if (read.HasRows)
                    {
                       
                        MessageBox.Show("Welcome" + " " + " " + textBox1.Text + " ", "Welcome", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        this.Hide();
                        Search sc = new Search();
                        sc.Show();
                    }
                    else
                    {
                        MessageBox.Show("User Name & Password is invalid", "Information Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        con.Dispose();
                        con.Close();
                    }
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message, " ", MessageBoxButtons.OK, MessageBoxIcon.Error);
                MessageBox.Show(ex.StackTrace, " ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

        }

    }
}