コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Admin1 newForm3 = new Admin1();

            newForm3.Show();
            this.Hide();
        }
コード例 #2
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         connection CN = new connection();
         CN.thisConnection.Open();
         OracleCommand thisCommand = new OracleCommand();
         thisCommand.Connection = CN.thisConnection;
         if (textBox1.Text == "admin")
         {
             thisCommand.CommandText = "SELECT * FROM admin WHERE name='" + textBox1.Text + "' AND password='******'";
             OracleDataReader thisReader = thisCommand.ExecuteReader();
             if (thisReader.Read())
             {
                 Admin1 newForm3 = new Admin1();
                 newForm3.Show();
                 this.Hide();
             }
             else
             {
                 MessageBox.Show("username or password incorrect");
             }
         }
         else
         {
             thisCommand.CommandText = "SELECT * FROM users WHERE u_name='" + textBox1.Text + "' AND password='******'";
             OracleDataReader thisReader = thisCommand.ExecuteReader();
             if (thisReader.Read())
             {
                 Form5 newForm5 = new Form5();
                 newForm5.Show();
                 this.Hide();
             }
             else
             {
                 MessageBox.Show("username or password incorrect");
             }
         }
         //this.Close();
         CN.thisConnection.Close();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }