private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source = HAIER-PC; Initial Catalog = ProjectA; Integrated Security = True; MultipleActiveResultSets = True");
if (e.ColumnIndex == 2)
{
ViewGroupStudents sdr = new ViewGroupStudents();
sdr.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
sdr.Show();
}
if (e.ColumnIndex == 3)
{
GroupEvaluation grp = new GroupEvaluation();
grp.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
grp.Show();
}
if (e.ColumnIndex == 4)
{
GroupProjects prg = new GroupProjects();
prg.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
prg.Show();
}
//for deleting stuff
if (e.ColumnIndex == 5)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item ??",
"Confirm Delete!!",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
con.Open();
String cmd45 = string.Format("Delete FROM GroupEvaluation WHERE GroupId = {0};Delete FROM GroupStudent WHERE GroupId = {0};Delete FROM GroupProject WHERE GroupId = {0};Delete FROM [Group] WHERE Id = {0}",
Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()));
SqlCommand query45 = new SqlCommand(cmd45, con);
query45.ExecuteNonQuery();
con.Close();
MessageBox.Show("Deleted");
object sende = null;
EventArgs er = null;
dataGridView1.Rows.Clear();
this.Group_Load(sende, er);
}
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 2)
{
ViewGroupStudents sdr = new ViewGroupStudents();
sdr.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
sdr.Show();
}
if (e.ColumnIndex == 3)
{
GroupEvaluation grp = new GroupEvaluation();
grp.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
grp.Show();
}
if (e.ColumnIndex == 4)
{
GroupProjects prg = new GroupProjects();
prg.Id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
prg.Show();
}
if (e.ColumnIndex == 5)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item ??",
"Confirm Delete!!",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
//SqlConnection conn = new SqlConnection("Data Source=TALHAALI;Initial Catalog=ProjectA;User ID=sa;Password=talhaali");
conn.Open();
String cm4 = string.Format("Delete from GroupEvaluation where GroupId={0};Delete from GroupStudent where GroupId={0};Delete from GroupProject where GroupId={0};Delete from [Group] where Id={0}", Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()));
SqlCommand comm4 = new SqlCommand(cm4, conn);
comm4.ExecuteNonQuery();
//SqlDataReader reader2 = comm4.ExecuteReader();
//int studentid = 0;
//while (reader2.Read())
//{
// studentid = Convert.ToInt32(reader2["Id"]);
//}
conn.Close();
MessageBox.Show("Deleted");
object sende = null;
EventArgs er = null;
dataGridView1.Rows.Clear();
this.Groups_Load(sende, er);
}
}
}
