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();
}
