private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) //by default datagridview gives added column starting indexes. { if (e.RowIndex != -1) //managelevel { DataGridViewRow rows = dataGridView1.Rows[e.RowIndex]; rubric_id = rows.Cells[5].Value.ToString(); rub_name = rows.Cells[6].Value.ToString(); Add_display_levelcs form_rub = new Add_display_levelcs(); this.Hide(); form_rub.Show(); } }//end of managelevel if (e.ColumnIndex == 1)//edit { if (e.RowIndex != -1) {// binding of comobox with clo's names. using (SqlConnection conn = new SqlConnection(constr)) { using (SqlDataAdapter da = new SqlDataAdapter("SELECT Name FROM Clo ORDER BY Name", conn)) { DataTable dt = new DataTable(); da.Fill(dt); comboBox1.DisplayMember = "Name"; comboBox1.DataSource = dt; } } DataGridViewRow rows = dataGridView1.Rows[e.RowIndex]; rubric_id = rows.Cells[5].Value.ToString(); clo_id = rows.Cells[4].Value.ToString(); textBox2.Text = rows.Cells[6].Value.ToString(); comboBox1.Text = rows.Cells[3].Value.ToString(); } }//end of edit if (e.ColumnIndex == 2)//delete { SqlConnection conn = new SqlConnection(constr); conn.Open();//open connection DataGridViewRow rows = dataGridView1.Rows[e.RowIndex]; rubric_id = rows.Cells[5].Value.ToString(); for (int i = 0; i < 3; i++) { // RubricId=rubric which user wants to delete. //delete rubriclevel where Rubric.Id equals to RubricLevel.rubricId string delete_rubric_level = "DELETE RubricLevel WHERE EXISTS ( SELECT * FROM Rubric WHERE Rubric.Id= RubricLevel.RubricId and Rubric.Id ='" + rubric_id + "')"; SqlCommand cmd3 = new SqlCommand(delete_rubric_level, conn); SqlDataReader reader3 = cmd3.ExecuteReader(); } string delete_rub = "DELETE from Rubric WHERE Rubric.Id ='" + rubric_id + "'"; SqlCommand cmd2 = new SqlCommand(delete_rub, conn); SqlDataReader reader2 = cmd2.ExecuteReader(); MessageBox.Show("Deleted Successfully"); show(); } }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { Add_display_levelcs obj = new Add_display_levelcs(); this.Hide(); obj.Show(); }