>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only