autogenerate id

Question

how to set id as autogenerate in asp.net with ms-sql.For example I have the table.When i insert some values to that table the id was generate automatically(i send only name the id -autogenerate).

Krishna Garad · Answer

While creating table you can create It as Autoincremented. If you want it now just open table in design mode select column it will show you a property window bellow in that there is a property called IsIdentity set it to true and specify seed and increament values it will done.

Amit Choudhary · Answer

Hi shashi, There's two way to achieve this: 1) you can create a column in your Table in database that have a autoIncrementId. First insert the data in data in table and then either you can have the MAXId to get the recently added row. or there's some other options exist like environment var can be used in Sqlserver to get the latest inserted ID's. 2) First you can find the highest ID and increment it to one in your code. and then insert it to your database. Thanks.

shashi reddy · Answer

hai Krishna Garad thanQ for giveing me a nice solution

Dorababu Meka · Answer

In sql you will have an option to set that. Sample CREATE TABLE Persons ( P_Id int PRIMARY KEY IDENTITY, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) )

shashi reddy · Answer

hai amit i created a table now i wanted to give id autoincrement how can we give autoIncrement to that id ... give me one example..amit i am new to this dotnet and sql

autogenerate id

Answers (5)