//Opening Non Teaching Staff page when click on Non teaching staff button
private void button3_Click(object sender, EventArgs e)
{
Non_Teaching_Admission nad = new Non_Teaching_Admission();
this.Hide();
nad.ShowDialog();
}
//Creating Next sequence value
void sequencenextval()
{
//Creating Next sequence value
string str = "DATA SOURCE=localhost:1521/xe; USER ID=IMS;password=enteryourchoice";
OracleConnection con = new OracleConnection(str);
string query = "Select NONTEACHERSEQ.nextval from DUAL";
string query1 = "select PERSONSEQ.nextval from DUAL";
OracleCommand cmd = new OracleCommand(query, con);
OracleCommand cmd1 = new OracleCommand(query1, con);
OracleDataReader rdr, rdr1;
try
{
con.Open();
rdr = cmd.ExecuteReader();
rdr1 = cmd1.ExecuteReader();
rdr.Read();
rdr1.Read();
MessageBox.Show("Record Inserted Successfully");
Non_Teaching_Admission tsa = new Non_Teaching_Admission();
this.Hide();
tsa.ShowDialog();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
del();
}
}