VB.NET autogenerated item number

[nullclick]

i want to make auto generated item number look like this
item001
item002
and so on
when i saved the item001 the next time i try to input new item it will give me item002 and so on...

Thank You.
i am using ACCESS

[Saikalyankumar]

Where you are saving the items in database or some where else?

[nullclick]

Where you are saving the items in database or some where else?

i am using access sir.

[debasisdas]

since you are storing the data in the DB , need to read the max of existing number and increment the same by 1 to get the new number and concatenate the same with your string.

[Saikalyankumar]

You follow the process given by debasisdas or else make the auto increment in the access, and the get the incremented value and concatenate to the string, for auto increment to access using vb coding refer to this http://forums.asp.net/t/999557.aspx/1?How+to+Auto+Increment+a+Primary+Key+value+using+Access+and+Forms+View+in+VS+2005