Interview Question in Visual Studio 2003
Interview Question :: URGENTHELPhow to update the Database without over writing the data inside |
I am doing a programming on visual studio.net 2003 using the Asp.net mobile Web form. I am trying to update the Microsoft access database that i have created using the statement : Update.
According to the Update Statement that i had written, It directly replaces the value in the attribute of the table. Which is not what i am looking for. here's my quote of example for a better explanation:
I have a table name : Pen
Attributes are : ItemID, Color,Quantity,ItemDetails
As such my quantity inside have 10 and when i want to order another 40, i do not want it to replace to 40. i want to replace it to show 50. As such its an addition method.
However in my Update sentence it overwrite it. Is there any other method to make it add?Thanks. Its urgent. |
|
|
|
Loading ...