public static void RemoveRecord(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter) { try { AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(1); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName); rowToDelete = table.FindByCarId(2); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName); } catch (Exception ex) { WriteLine(ex.Message); } }
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter) { try { AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(table.Last().CarId); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.Name); rowToDelete = table.FindByCarId(table.Last().CarId - 1); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.Name); adapter.Update(table); } catch (Exception ex) { WriteLine(ex.Message); } }
private static void RemoveRow(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter, int n) { var rows = table.Rows; if ((n = ((AutoLotDataSet.InventoryRow)rows[rows.Count - n]).CarId) > 12) { WriteLine($"- remove row with CarId {n}"); AutoLotDataSet.InventoryRow row = table.FindByCarId(n); adapter.Delete(row.CarId, row.Make, row.Color, row.PetName); } }
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable table, InventoryTableAdapter adapter) { try { Write("Enter ID of car to delete: "); string carID = ReadLine() ?? "0"; AutoLotDataSet.InventoryRow rowToDelete = table.FindByCarId(int.Parse(carID)); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName); } catch (Exception ex) { WriteLine(ex.Message); } }
private static void RemoveRecords(AutoLotDataSet.InventoryDataTable tb, InventoryTableAdapter adapter) { try { Console.WriteLine("Enter carId what you want delete: "); int carIdToDelete = int.Parse(Console.ReadLine().ToString()); AutoLotDataSet.InventoryRow rowToDelete = tb.FindByCarId(carIdToDelete); adapter.Delete(rowToDelete.CarId, rowToDelete.Make, rowToDelete.Color, rowToDelete.PetName); adapter.Update(tb); } catch (Exception ex) { Console.WriteLine(ex.Message); } }