private void button5_Click(object sender, EventArgs e) { User_Options ob = new User_Options(); ob.Show(); this.Hide(); }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Fill up all the fields for Login"); return; } try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; thisCommand.CommandText = "SELECT * FROM New_User_SignIn WHERE username='******' AND password='******'"; OracleDataReader thisReader = thisCommand.ExecuteReader(); if (thisReader.Read()) { User_Options oform = new User_Options(); oform.Show(); this.Hide(); } else { MessageBox.Show("username or password incorrect"); } CN.thisConnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button6_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "update New_User_SignIn set email = '" + textBox1.Text + "',mobile= '" + textBox2.Text + "'where password= '******'"; thisCommand.Connection = sv.thisConnection; thisCommand.CommandType = CommandType.Text; try { int a = thisCommand.ExecuteNonQuery(); if (a == 1) { MessageBox.Show("Updated Successfully"); } else { MessageBox.Show("Not Updated...Insert your old Password Perfectly"); return; } } catch (Exception ex) { MessageBox.Show("Not Updated"); } sv.thisConnection.Close(); this.Close(); User_Options ob = new User_Options(); ob.Show(); this.Hide(); }