Retrieving Integer from Table and Adding to it

[Vicky999]

Hi all,

I need to retrieve an integer value from an Access database, and display it on screen. I then need to add a value entered manually into another field to this existing number, which would update the database. For example:

Existing Integer: 7
Entered Integer: 8
Updated Integer (to take the plce of the existing integer): 15

Any help would be greatly appreciated!

 

[culshaja]

You would issue an update statement which used the following style of code:

UPDATE myTable SET myColumn = myColumn + 8 WHERE dataPrimaryKey = x

You need to pull and store thet data from tha row that will uniquely identify the row for the WHERE clause in the update statement.

You just do the rest using the OleDbCommand object.

James

James Culshaw
james@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.caninerescue.co.uk