hi!

can anyone help me how to generate autonumber in sql2000 when i insert a row using vb.net 2003

thank you

Nothing to do with VB or anything else relevant to ASP.NET or the .NET framework.

You just have to declare the field in the table as IDENTITY when you create (or modify) the table.

Example:

CREATE TABLE foo
(
    id INT IDENTITY PRIMARY KEY,
    name NVARCHAR(80),
    ...
)

If you don't use SQL to create your tables, then look at the tool you are using to create/modify your tables and figure out what it needs you do to tell it that you want in IDENTITY column.