Hi

Gud morning...

I am working with Windows Application.. VB.NET

My requirement is , i have one table like dcno., id , name etc..

i want to increment the dcno manually in code

for first time it will check whether any data is inserted for dcno, if not , , i want to set

dcno =1 and the record has been saved , then again i am loading the form

it wil check the database , if any data is ther i t will increment automatically by 1 ...

can any one post the code ...pls.......

Thanks.,....


Regards,
Venkatesan.M

Doing this manually is generally regarded as a bad practice. What happens if two instance of the problem get the last value (let's say 1) at the same time? They will each try to save a new one as 2 and one will fail.

This is why there are auto increment field settings in many database platforms which makes this operation trivial. The place you set this behavior will vary based on the database you are using.

-Peter
peterlanoie.blog