Question data vanished which stored using data binding

[master_2013]

when i used to store data enter in vb.net form using data binding from access database its store data in access which i enter in vb.net forms after i stop debugging and next start debugging the data vanished from database and again starts from serial no 1 i just cannt understand

my database name is Gym.mdb and having table name products

1 id
2 product name
3 name
4 date of issue
5 quantity
6 price
7 grand total
8 invoice no

i also want a pattern like nuel-001 and auto increment like nuel-002,nuel-003 and so on in invoice number

can anyone help me on this

 

[jmcilhinney]

Follow the first link in my signature to learn why your data is disappearing and how to configure your database to prevent it.