Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            //create object for SQL connection and connect to data source. Go to Server Explorer>right click database>modify connection>advanced>copy from there.
            SqlConnection sqlcon = new SqlConnection(@"Data Source=DESKTOP-9D9LNHM\SQLEXPRESS;Initial Catalog=userLogin;Integrated Security=True");
            //write sql query to get what the user entered
            string query = "select * from logins where username = '******' and '" + textBox2.Text.Trim() + "'";
            //new instance of class SqlDataAdapter to fill the data set and update database. Pass in local variable and SqlConnection as parameters.
            SqlDataAdapter sda = new SqlDataAdapter(query, sqlcon);
            //new instance of class that represents a table in memory data.
            DataTable dtbl = new DataTable();

            //use Fill to add or refresh rules in specified range in data set. Pass dtbl to sda.
            sda.Fill(dtbl);
            //once user enters username and password, this if statement will check to see if that row is in the database.
            if (dtbl.Rows.Count == 1)
            {
                //if username and password are correct, it will pull up the success form and hide the login form.
                frmLoggedIn objfrmLoggedIn = new frmLoggedIn();
                this.Hide();
                objfrmLoggedIn.Show();
            }
            //if the username/password does not match something in the database, it will show this error message.
            else

            {
                MessageBox.Show("Please check your username and password");
            }
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection  sqlconn = new SqlConnection(@"Data Source=KAGUYA\SQLEXPRESS;Initial Catalog=userLogin;Integrated Security=True");
            string         query   = "select * from logins where username='******'and password='******'";
            SqlDataAdapter sda     = new SqlDataAdapter(query, sqlconn);
            DataTable      dtbl    = new DataTable();

            sda.Fill(dtbl);
            if (dtbl.Rows.Count == 1)
            {
                frmLoggedIn objfrmLoggedIn = new frmLoggedIn();
                this.Hide();
                objfrmLoggedIn.Show();
            }
            else
            {
                MessageBox.Show("Please check your credentials and try again.");
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection sqlcon = new SqlConnection(@"Data Source=DVRLT4VKDYF2;Initial Catalog=UdemyUserLogin;Integrated Security=True");
            string        query  = "select * from logins where username ='******'and password ='******'";

            SqlDataAdapter sda  = new SqlDataAdapter(query, sqlcon);
            DataTable      dtb1 = new DataTable();

            sda.Fill(dtb1);
            if (dtb1.Rows.Count == 1)
            {
                frmLoggedIn objfrmLoggedIn = new frmLoggedIn();
                this.Hide();
                objfrmLoggedIn.Show();
            }
            else
            {
                MessageBox.Show("Please check your username and password");
            }
        }