private void button2_Click(object sender, EventArgs e)
        {
            Form f = new profile_d(n);

            f.Show();
            this.Hide();
        }
Beispiel #2
0
      private void b_submit_Click(object sender, EventArgs e)
      {
          int x = int.Parse(textBox1.Text) / 1000;

          connect();
          cmd = new OracleCommand();
          if (x == 1)
          {
              cmd.CommandText = "select * from patient_pers";
              cmd.CommandType = CommandType.Text;
              DataSet ds = new DataSet();
              da = new OracleDataAdapter(cmd.CommandText, con);
              da.Fill(ds, "patient_pers");
              dt = ds.Tables["patient_pers"];
              int t = dt.Rows.Count;

              for (i = 0; i < t; i++)
              {
                  dr = dt.Rows[i];
                  if ((textBox1.Text == dr["patient_id"].ToString()) && (textBox2.Text == dr["password"].ToString()))
                  {
                      string a = dr["name"].ToString();
                      Form   f = new profile_p(a);
                      f.Show();
                      this.Hide();
                      break;
                  }
              }
              if (i == t)
              {
                  label2.Visible = true;
              }
          }
          else if (x == 2)
          {
              cmd.CommandText = "select * from doc_pers";
              cmd.CommandType = CommandType.Text;
              DataSet ds = new DataSet();
              da = new OracleDataAdapter(cmd.CommandText, con);
              da.Fill(ds, "doc_pers");
              dt = ds.Tables["doc_pers"];
              int t = dt.Rows.Count;

              for (i = 0; i < t; i++)
              {
                  dr = dt.Rows[i];
                  if ((textBox1.Text == dr["doc_id"].ToString()) && (textBox2.Text == dr["password"].ToString()))
                  {
                      string a = dr["name"].ToString();
                      Form   f = new profile_d(a);
                      f.Show();
                      this.Hide();
                      break;
                  }
              }
              if (i == t)
              {
                  label2.Visible = true;
              }
          }
          else
          {
              label2.Visible = true;
          }
      }