private void my_Cancel_Click(object sender, EventArgs e) { InputsForm fd = new InputsForm(controler); this.Hide(); fd.setLabel(mail.Text); fd.Show(); }
private void button1_Click(object sender, EventArgs e) { string mail = (id.Text) + "@" + maskedTextBox1.Text; string pass = password.Text; string dbprovider = controler.m.getDBprovider(); String strSql = "SELECT * FROM users WHERE email= '" + mail + "'"; OleDbConnection conn = new OleDbConnection(dbprovider); if (id.Text == "" || maskedTextBox1.Text == "") { MessageBox.Show("you must add your mail"); id.Clear(); maskedTextBox1.Clear(); id.Focus(); } else { try { conn.Open(); OleDbCommand cmd = new OleDbCommand(strSql, conn); OleDbDataReader reader = cmd.ExecuteReader(); reader.Read(); string passw = reader.GetString(9); if (passw != pass) { MessageBox.Show("wrong password"); password.Clear(); password.Focus(); } else { InputsForm fi = new InputsForm(controler); this.Hide(); fi.Show(); fi.setLabel(mail); } } catch (Exception ex) { MessageBox.Show("user didn't exist or wrong mail try again"); id.Clear(); maskedTextBox1.Clear(); id.Focus(); password.Clear(); } finally { conn.Close(); } } }
private void Ok_Click(object sender, EventArgs e) { String t1, t2, t3, t5, t6, t4; t4 = id.Text; t1 = desc.Text; t2 = num.Text; t3 = max.Text; t5 = date.Text; t6 = name.Text; string strSql = "INSERT INTO domain (domaim_id,description,partnersNum,maxNumOfPartners,date,name) VALUES (?,?,?,?,?,?)"; string dbprovider = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= C:\Users\USER\Documents\Visual Studio 2015\Projects\myIS\myIS\db\" + @"partners.mdb"; OleDbConnection conn = new OleDbConnection(dbprovider); try { OleDbCommand dbCmd = new OleDbCommand(strSql, conn); dbCmd.Parameters.AddWithValue("domaim_id", t4); dbCmd.Parameters.AddWithValue("description", t1); dbCmd.Parameters.AddWithValue("partnersNum", t2); dbCmd.Parameters.AddWithValue("maxNumOfPartners", t3); dbCmd.Parameters.AddWithValue("date", t5); dbCmd.Parameters.AddWithValue("name", t6); conn.Open(); dbCmd.ExecuteNonQuery(); } catch { MessageBox.Show("domain exist choose another"); id.Clear(); id.Focus(); } finally { conn.Close(); } MessageBox.Show("Domain Data saved successfuly...!"); InputsForm fi = new InputsForm(); fi.Show(); }