internal static void UpdateTableStops(DataGridView DGV_ToUdpate, string selectedOperation) { int rowCount; if (selectedOperation == "Add") { rowCount = DGV_ToUdpate.RowCount - 1; } else { rowCount = DGV_ToUdpate.RowCount; } for (int i = 0; i < rowCount; i++) { StopsToUpdate stops = new StopsToUpdate() { _Id = new int(), Name = string.Empty }; for (int j = 0; j < DGV_ToUdpate.ColumnCount; j++) { stops._Id = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j++].Value); stops.Name = DGV_ToUdpate.Rows[i].Cells[j].Value.ToString(); } Database.DeleteRow("Остановки", stops._Id); Database.UpdateStops(stops); } }
internal static void UpdateStops(StopsToUpdate stops) { connection.Open(); string values = stops._Id + ", "; values += "\"" + stops.Name + "\""; SQLiteCommand command = new SQLiteCommand("INSERT INTO Остановки VALUES (" + values + ")", connection); try { command.ExecuteNonQuery(); } catch { connection.Close(); MessageBox.Show("Ошибка ввода.", "Ошибка!"); return; } connection.Close(); }