/* private void GetRecords()
* {
* cmd = new SqlCommand("select * from Lec_details", con);
* DataTable dt = new DataTable();
*
* con.Open();
*
* SqlDataReader sdr = cmd.ExecuteReader();
* dt.Load(sdr);
* con.Close();
*
* dataGridView1.DataSource = dt;
* }*/
private void button2_Click(object sender, EventArgs e)
{
sql = "delete from Lec_details where LecturerID = @LecturerID ";
con.Open();
cmd = new SqlCommand(sql, con);
state();
cmd.Parameters.AddWithValue("@LecturerID", LID.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Data Delete Successfully!!");
Showdata();
lvl.SelectedIndex = -1;
center.SelectedIndex = -1;
lecName.Clear();
LID.Clear();
faculty.SelectedIndex = -1;
depart.SelectedIndex = -1;
building.SelectedIndex = -1;
}
private void button1_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled) &&
lecName.Text == "" || lvl.Text == "" || LID.Text == "" || center.Text == "" || faculty.Text == "" || depart.Text == "" || building.Text == "")
{
MessageBox.Show("Please fill out the Empty Field(s)",
"Unable to Submit", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
}
else
{
sql = "update Lec_details set Lecturer_Name = @Lecturer_Name,Level = @Level,LecturerID = @LecturerID,Center = @Center,Faculty = @Faculty,Department = @Department,Building = @Building where LecturerID = @LecturerID ";
con.Open();
cmd = new SqlCommand(sql, con);
state();
cmd.Parameters.AddWithValue("@Lecturer_Name", lecName.Text);
cmd.Parameters.AddWithValue("@Level", lvl.Text);
cmd.Parameters.AddWithValue("@LecturerID", LID.Text);
cmd.Parameters.AddWithValue("@Center", center.Text);
cmd.Parameters.AddWithValue("@Faculty", faculty.Text);
cmd.Parameters.AddWithValue("@Department", depart.Text);
cmd.Parameters.AddWithValue("@Building", building.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Data Update Successfully!!");
Showdata();
lecName.Clear();
lvl.SelectedIndex = -1;
LID.Clear();
center.SelectedIndex = -1;
faculty.SelectedIndex = -1;
depart.SelectedIndex = -1;
building.SelectedIndex = -1;
}
}