internal static void UpdateTableTrains(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++) { TrainsToUpdate trains = new TrainsToUpdate() { _Id = new int(), Name = string.Empty, Capacity = new int() }; for (int j = 0; j < DGV_ToUdpate.ColumnCount; j++) { trains._Id = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j++].Value); trains.Name = DGV_ToUdpate.Rows[i].Cells[j++].Value.ToString(); trains.Capacity = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j].Value); } Database.DeleteRow("Поезда", trains._Id); Database.UpdateTrains(trains); } }
internal static void UpdateTrains(TrainsToUpdate trains) { connection.Open(); string values = trains._Id + ", "; values += "\"" + trains.Name + "\", "; values += trains.Capacity; SQLiteCommand command = new SQLiteCommand("INSERT INTO Поезда VALUES (" + values + ")", connection); try { command.ExecuteNonQuery(); } catch { connection.Close(); MessageBox.Show("Ошибка ввода.", "Ошибка!"); return; } connection.Close(); }