private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e) { bool admin = Convert.ToBoolean(dGVUsers.CurrentRow.Cells[3].Value) == true ? true : false; string ID_User = manipulationDB.generationID("SELECT ИД FROM Пользователь WHERE Имя='" + Convert.ToString(dGVUsers.CurrentRow.Cells[1].Value) + "' " + "AND Администрирование='" + admin + "'"); manipulationDB.Delete(dGVUsers, manipulationDB.queryUserDel, ID_User); }
private void Delete6_Click(object sender, EventArgs e) { string ID_Val1 = manipulationDB.generationID("SELECT ИД FROM Валюта WHERE [Сокращенное наименование]='" + Convert.ToString(metroGridMoneySize.CurrentRow.Cells[2].Value) + "'"); string ID_Val2 = manipulationDB.generationID("SELECT ИД FROM Валюта WHERE [Сокращенное наименование]='" + Convert.ToString(metroGridMoneySize.CurrentRow.Cells[4].Value) + "'"); string ID_MoneySize = manipulationDB.generationID("Select ИД FROM [Курс валют] " + "WHERE Единица1='" + Convert.ToString(metroGridMoneySize.CurrentRow.Cells[1].Value) + "' AND Валюта1='" + ID_Val1 + "' " + "AND Единица2='" + Convert.ToString(metroGridMoneySize.CurrentRow.Cells[3].Value) + "' AND Валюта2='" + ID_Val2 + "'"); manipulationDB.Delete(metroGridMoneySize, manipulationDB.queryMoneySizeDel, ID_MoneySize); }