>Dear The Expert,
>
>I have autonumber field, there is a delete all record process in my vb.net application, my question is simple how to reset the value of autonumber field back to 0.. I need advise .. thanks
>
>Regards
>Winan

Winan,

Are you asking about resetting the seed in a DataSet or in SQL Server? In SQL Server, the command is "DBCC CHECKIDENT(myTableName,RESEED)". Do not enclose the myTableName parameter in quotes.

For a DataSet, I believe the seed and increment values are stored in the DataTable object. I don't have the property names in front of me, but you should be able to find them very quickly in the VS.NET help files.