Hi, I'm trying to auto-increment reference numbers in my text box. Everytime a user enters my web form the reference number automatically increments, for example, 20060001 and so on.
I'm new to visual studio 2005 and I'm unsure how to go about doing it. Please help.

Shawn

when do you want it to increment, after you save some data?

Do I have to use session state?

Yes once the user submits the form I want the reference number to auto increment.

What database are you using. Most DBs have some type of autoincrement column. I would use that, and not rely on the front end to increment it.

My guess is you're using the included SQL Server Express db. If so, doubleclick the table you want to have an incrementally updated column for, then click the field in question (your_ID). In the Column properties, set Identity Specification to Yes and open its properties by clicking the + sign in front of the Idendity Spec. text.

Next, choose your values in increment (how big jumps you want) and also seed (the first value). That's it!

Good luck,
Pettrer

Coding is indeed a nine-to-five job; nine pm to five am.

Sorry for not stating this but my datatype for my reference number is char(9). It should begin like this, 2006-0001,2006-0002 etc