Updating database
I have this table in a database
StockLineItem:
ID(Primary Key)
StockID
ProductID
LevelID
Quantity
When I pull it from the database into a datagridview, I use the the foreing keys(StocKID, ProductID, LevelID) to pick up data from other tables where those keys are primary keys. the resulting table is this
StockLineItem:
ID(Primay key)
StockID
ProductName
Description
RetailPrice
Cost
I now want to update the database how do I go about it.
|