private void button2_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(CString); con.Open(); SqlCommand exe = new SqlCommand("INSERT INTO RubricLevel(RubricId,Details,MeasurementLevel) values('" + Convert.ToInt32(comboBox1.SelectedValue) + "','" + Details.Text + "','" + Convert.ToInt32(comboBox2.SelectedItem) + "')", con); exe.ExecuteNonQuery(); MessageBox.Show("Added!"); this.Hide(); Form10 frm = new Form10(); frm.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { SqlConnection con = new SqlConnection(CString); con.Open(); if (e.ColumnIndex == dataGridView1.Columns["del"].Index) { int row = e.RowIndex; int sel = Convert.ToInt32(dataGridView1.Rows[row].Cells["Id"].Value); SqlCommand exe = new SqlCommand("DELETE FROM RubricLevel WHERE Id = '" + sel + "'", con); exe.ExecuteNonQuery(); MessageBox.Show("Deleted!"); this.Hide(); Form10 form = new Form10(); form.Show(); } }