Esempio n. 1
0
        private void btnBack_Click(object sender, EventArgs e)
        {
            formHome frmHome = new formHome(uName);

            frmHome.Show();
            this.Hide();
        }
Esempio n. 2
0
        private void btnSignIn_Click(object sender, EventArgs e)
        {
            SqlConnection  con  = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\Documents\GitHub\CRUD-Operations-App\SeasideSouthPark\SeasideDB.mdf;Integrated Security=True;Connect Timeout=30");
            string         qry  = "Select * from tblUser where Username='******' and Password='******'";
            SqlDataAdapter sda  = new SqlDataAdapter(qry, con);
            DataTable      dtbl = new DataTable();

            sda.Fill(dtbl);

            try
            {
                if (dtbl.Rows.Count == 1)
                {
                    formHome frmHome = new formHome(txtUserName.Text.Trim());
                    frmHome.Show();
                    this.Hide();
                }

                else
                {
                    MessageBox.Show("Please check your username and password");
                }
            }

            catch (Exception ex)
            {
                MessageBox.Show("Login Failed, Error Generated: " + ex);
            }

            finally
            {
                txtUserName.Text      = "Username";
                txtUserName.ForeColor = Color.Gray;

                txtPassword.Text      = "Password";
                txtPassword.ForeColor = Color.Gray;
            }
        }