private void button1_Click(object sender, EventArgs e) { try { connection CN = new connection(); CN.thisConnection.Open(); // OracleCommand thisCommand = new OracleCommand(); OracleCommand thisCommand1 = new OracleCommand(); thisCommand1.Connection = CN.thisConnection; { thisCommand1.CommandText = " SELECT MAX(U_ID) FROM USERS"; int id = Convert.ToInt32(thisCommand1.ExecuteScalar()); id++; CN.thisConnection.Close(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; thisCommand.CommandText = "insert into users values( " + id + ",'" + textBox1.Text + "','" + textBox5.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','no')"; OracleDataReader thisReader = thisCommand.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(thisReader); MessageBox.Show("Applied"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button3_Click(object sender, EventArgs e) { connection sv = new connection(); sv.thisConnection.Open(); OracleCommand thisCommand = sv.thisConnection.CreateCommand(); thisCommand.CommandText = "update applicant set status = '" + textBox2.Text + "'where u_id= '" + textBox1.Text + "'"; thisCommand.Connection = sv.thisConnection; thisCommand.CommandType = CommandType.Text; //For Insert Data Into Oracle// try { thisCommand.ExecuteNonQuery(); MessageBox.Show("Updated"); } catch (Exception ex) { Console.WriteLine(ex.Message); } sv.thisConnection.Close(); }
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()); } }
private void button4_Click(object sender, EventArgs e) { try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; { thisCommand.CommandText = "select * from applicant where status = 'yes'"; OracleDataReader thisReader = thisCommand.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(thisReader); dataGridView1.DataSource = dataTable; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } /* connection sv = new connection(); * sv.thisConnection.Open(); * OracleCommand thisCommand = sv.thisConnection.CreateCommand(); * * thisCommand.CommandText = * "update users set status = '" + textBox2.Text + "'where u_id= '" + textBox1.Text + "'"; * * thisCommand.Connection = sv.thisConnection; * thisCommand.CommandType = CommandType.Text; * //For Insert Data Into Oracle// * try * { * thisCommand.ExecuteNonQuery(); * MessageBox.Show("Updated"); * * } * catch (Exception ex) * { * Console.WriteLine(ex.Message); * } * * sv.thisConnection.Close(); */ }
private void textBox1_TextChanged(object sender, EventArgs e) { try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; { thisCommand.CommandText = "select u_name from users where u_id ='" + textBox1.Text + "'"; textBox2.Text = Convert.ToString(thisCommand.ExecuteScalar()); CN.thisConnection.Close(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button3_Click(object sender, EventArgs e) { try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; { thisCommand.CommandText = "select * from users"; OracleDataReader thisReader = thisCommand.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(thisReader); dataGridView1.DataSource = dataTable; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { try { connection CN = new connection(); CN.thisConnection.Open(); OracleCommand thisCommand = new OracleCommand(); thisCommand.Connection = CN.thisConnection; { thisCommand.CommandText = "insert into applicant values( '" + Int32.Parse(textBox1.Text) + "','" + textBox2.Text + "','" + dateTimePicker1.Value.ToString("dd/MM/yyyy") + "','" + dateTimePicker2.Value.ToString("dd/MM/yyyy") + "','no')"; OracleDataReader thisReader = thisCommand.ExecuteReader(); DataTable dataTable = new DataTable(); dataTable.Load(thisReader); MessageBox.Show("Applied"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }