public void Login(Login_Form log) { string constr = "Data Source=orcl;User Id=hr;Password=hr;"; string emaill = "select email from customer"; adapterr = new OracleDataAdapter(emaill, constr); dataSett = new DataSet(); adapterr.Fill(dataSett); for (int i = 0; i < dataSett.Tables[0].Rows.Count; i++) { if (dataSett.Tables[0].Rows[i]["email"].ToString() == log.email_txt_box.Text) { Catalogue cat = new Catalogue(); cat.setCustomerEmail(log.email_txt_box.Text); string constrr = "Data Source=orcl;User Id=hr;Password=hr;"; string password = "******"; OracleDataAdapter adapterrr = new OracleDataAdapter(password, constrr); adapterrr.SelectCommand.Parameters.Add("email", log.email_txt_box.Text); DataSet dataSettt = new DataSet(); adapterrr.Fill(dataSettt); for (int j = 0; j < dataSettt.Tables[0].Rows.Count; j++) { if (dataSettt.Tables[0].Rows[j]["CUSTOMER_PASSWORD"].ToString() == log.password_txt_box.Text) { MessageBox.Show("U R N"); cat.Show(); break; } } break; } else if (dataSett.Tables[0].Rows[i]["email"].ToString() != log.email_txt_box.Text && i == dataSett.Tables[0].Rows.Count - 1) { MessageBox.Show("this email or password does not exist"); } } }
private void Buy_Button_Click(object sender, EventArgs e) { Catalogue cat = new Catalogue(); cat.Show(); }