Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Arights a = new Arights();

            a.Show();
            Hide();
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string Aname = textBox_Aname.Text;
            string id    = textBox_id.Text;
            string pwd   = textBox_Apwd.Text;

            SqlConnection con   = new SqlConnection(constr);
            string        query = "select * from Admin11";
            SqlCommand    cmd   = new SqlCommand(query, con);

            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            DataTable     dt = new DataTable();

            dt.Load(dr);
            con.Close();
            int f = 0;

            foreach (DataRow d in dt.Rows)
            {
                string aname_db = d["Name"].ToString();
                string pwd_db   = d["Password"].ToString();
                string id_db    = d["Id"].ToString();

                if (aname_db == Aname && pwd == pwd_db && id == id_db)
                {
                    f = 1;
                    break;
                }
            }

            if (f == 0)
            {
                MessageBox.Show("Login failed");
                textBox_Aname.Text = "";
                textBox_Apwd.Text  = "";
                textBox_id.Text    = "";
            }
            else
            {
                MessageBox.Show("success");
                Arights a = new Arights();
                a.Show();
                Hide();
            }
        }