private void новыйСтудентToolStripMenuItem_Click(object sender, EventArgs e)
{
New_Student newStudent = new New_Student();
newStudent.ShowDialog();
if (newStudent.DialogResult == DialogResult.OK)
{
string sql = $"INSERT INTO Students (Имя, Фамилия, Отчества, Оценка, Курс, Факультет, Направление, Рост,Дата_рождения, Телефон)" +
$" VALUES('{newStudent.Imya}', '{newStudent.Famil}','{newStudent.Otches}'," +
$"'{newStudent.Otsenka.ToString()}', '{newStudent.Kurs.ToString()}','{newStudent.Fakul}'," +
$"'{newStudent.Naprav}','{newStudent.Rost.ToString()}','{newStudent.DataRoj}', '{newStudent.Tel}')";
datatable = DB.db.Query(sql);
datatable = DB.db.Query("select * from Students");
dgvMain.DataSource = datatable;
}
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
New_Student newStudent = new New_Student(dgvMain.CurrentRow);
newStudent.ShowDialog();
if (newStudent.DialogResult == DialogResult.OK)
{
string sql = $"UPDATE Students SET Имя='{newStudent.Imya}', Фамилия='{newStudent.Famil}'," +
$" Отчества='{newStudent.Otches}', Оценка='{newStudent.Otsenka.ToString()}', " +
$" Курс='{newStudent.Kurs.ToString()}', Факультет='{newStudent.Fakul}'," +
$" Направление='{newStudent.Naprav}', Рост='{newStudent.Rost.ToString()}'," +
$" Дата_рождения='{newStudent.DataRoj}',Телефон='{newStudent.Tel}'" +
$" WHERE Код={dgvMain.CurrentRow.Cells[0].Value.ToString()}";
datatable = DB.db.Query(sql);
datatable = DB.db.Query("select * from Students");
dgvMain.DataSource = datatable;
}
}