/// <summary>
/// This is the cell click event of the grid view.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridStudentInformation_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var element = gridStudentInformation.Columns["Delete"].Index;
if (e.ColumnIndex == element)
{
int ID;
ID = Convert.ToInt32(gridStudentInformation.Rows[e.RowIndex].Cells[0].Value);
string cmd;
SqlCommand command;
SqlDataReader reader;
cmd = "Delete from StudentAttendance where StudentId = @id";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id", ID));
conn.Open();
command.ExecuteReader();
conn.Close();
cmd = "DELETE FROM StudentResult WHERE StudentId = @id1";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id1", ID));
conn.Open();
command.ExecuteReader();
conn.Close();
cmd = String.Format("DELETE FROM Student WHERE Id = @ID");
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@ID", ID));
conn.Open();
reader = command.ExecuteReader();
conn.Close();
conn.Open();
cmd = String.Format("SELECT *FROM Student");
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
gridStudentInformation.DataSource = table;
TabViewStudent.Refresh();
conn.Close();
}
else
{
var item = gridStudentInformation.Rows[e.RowIndex].Cells[0].Value;
//int IdOfItem;
//var SecondItem = gridStudentInformation.Rows[e.RowIndex].Cells[6].Value;
string cmd = String.Format("SELECT * FROM Student WHERE Id = @item");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@item", item));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
Student s = new Student();
//tabControl1.SelectedTab = tabControl1.TabPages["View Student"].Show;
TabADDStudent.Show();
btnAddStudent.Text = "Update Student";
while (reader.Read())
{
lblID.Text = Convert.ToString(reader[0]);
txtFirstName.Text = Convert.ToString(reader[1]);
txtLastName.Text = Convert.ToString(reader[2]);
txtContact.Text = Convert.ToString(reader[3]);
txtEmail.Text = Convert.ToString(reader[4]);
txtRegistrationNumber.Text = Convert.ToString(reader[5]);
cmbStatus.Text = Convert.ToString(reader[6]);
}
conn.Close();
}
}
