private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if ((e.ColumnIndex == 0) && (start.role == 0) || (start.role == 1) || (start.role == 2))
{
//del
if (MessageBox.Show("Вы действительно хотите удалить запись?", "Внимание", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (SqlConnection sqlConnection = new SqlConnection(url))
{
sqlConnection.Open();
var rowIndex = e.RowIndex;
var cell = dataGridView1.Rows[rowIndex].Cells[2].Value;
var com1 = new SqlCommand("DELETE FROM Table_Subject WHERE [Код дисциплины] = '" + cell + "' ", sqlConnection);
SqlDataReader sqldr = com1.ExecuteReader();
dataGridView1.Rows.RemoveAt(rowIndex);
}
MessageBox.Show("Данные успешно удалены!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
if ((e.ColumnIndex == 1) && (start.role == 0) || (start.role == 1) || (start.role == 2))
{
//edit
SubjectInfo subjectInfo = new SubjectInfo(subjectsList[e.RowIndex], false, this);
subjectInfo.Show();
}
}
private void buttonAddSubject_Click(object sender, EventArgs e)
{
SubjectInfo subjectInfo = new SubjectInfo(null, true, this);
subjectInfo.Show();
}
