예제 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string query = "Select role from Table1 where name='" + textBox1.Text + "' and password='******'";


            SqlDataAdapter sda = new SqlDataAdapter(query, sqcon);
            DataTable      dt  = new DataTable();

            sda.Fill(dt);
            if (dt.Rows.Count == 1)
            {
                //    Admin_Page ad = new Admin_Page(textBox1.Text);
                //  ad.Show();
                if (dt.Rows[0][0].ToString() == "admin")
                {
                    Admin_Page ad = new Admin_Page(textBox1.Text);
                    this.Hide();
                    ad.Show();
                }
                else
                {
                    Client2 nw = new Client2(textBox1.Text);
                    this.Hide();
                    nw.Show();
                }
            }
            else
            {
                MessageBox.Show("invalid character");
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            string         qur = "Select name from Table1";
            SqlDataAdapter sdq = new SqlDataAdapter(qur, con);
            DataTable      dt  = new DataTable();

            sdq.Fill(dt);
            Client2 c2 = new Client2(label5.Text);

            this.Hide();
            c2.Show();
        }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            string         quer = "Select amount from Table1 where name='" + label9.Text + "'";
            SqlDataAdapter sdq  = new SqlDataAdapter(quer, con);
            DataTable      dt   = new DataTable();

            sdq.Fill(dt);
            Client2 c2 = new Client2(label9.Text);

            this.Hide();
            c2.Show();
        }