I am doing programming in ASP and database is SQL Server I am finding problem in ID field This should be autogenerate and increment by 1. Please anyone can help me for the same.

You can make the column into an Identity column with increment step as 1.

Use your enterprise manager for this.

SQL Statement to create auto-generated ID field:

CREATE TABLE [MyTable] (
    [ID] [int] IDENTITY (1, 1) NOT NULL ,
    [Column1] [varchar] (50) NOT NULL ,
    [Column3] [datetime] NULL
)
GO

Cheers,
Pooja Falor

kinshuk-

In the SQL Server Enterprise Manager, you can click the database you are working with.

Once the DB is open, you can right click the Table name and select "Design Table"

Click on the Column Identity row of the column you would like to set to autogenerate. Select 'Yes' from the dropdown.

-------------------
namaste,

mike