Hi All !!

I need to generate an Alphanumeric Code for products for my Application where I have to add products to the database starting with 'P001' , 'P002' and so on. Everytime I add a new product the code will check for the last code entered, increment it and generate the next code. For example if the last Code in the database is 'P085' then it will create a new code as 'P086'

The code is a Text field in Access Database.

If someone has a code for this in C# please give. Any help would be appreciated.

Thanks in Advance

Since it's an Access DB, you can't do it all in the DB, unfortunately. With MySQL or SQL Server (or Oracle or...) you could.

But the answer is trivial:

Create *another* field, say call it PNUM, which is a simple AUTOINCREMENT (aka AUTONUMBER, aka COUNTER) field.

Create you PRODUCTCODE field as a CHAR(4) or VARCHAR(4) or whatever works for you, giving it a default value of NULL (which you don't have to specify...that's what it will be by default).

And every timy you insert a record, PNUM will increase. And *AFTER* each insert, you just then execute a simple SQL query:
Presto.