i wonder how i can autom increment primary key of table when ever i insert a new record using asp.net web form? i want to insert some data to sql server db using web forms.Thank u and looking forward to your replyes.Thanks

If you are familiar with Access Autonumber, you can achieve similar functionality by using IDENTITY column in SQL server.
Create an ID column(field) in your db, set it as an identity column.

Search for "Identity" in SQL server books online

Thank u for u reply. do u mean i need to change the
data type of primary key to some thing diffrent in sql server? Can it be done inside the asp.net web form ?

No, maintaining integrity of data is a database issue and must be done in your database. if you are using SQL server, in the enterprise manager set primary key field data type to integer and set column property to identity.

If all of the above does not make sense, my humble request get a SQL server book and read..

Many thanks to your reply. Well i did that but now when i insert records it start incrementing from 113 not from 0/one !! Before the changes i already had some records do u think that is the problem or primary key datatype ?Thanks and looking forward to your reply.

No problem you can use DBCC CHECKIDENT to reseed the identity value to start from 1

This example forces the current identity value in the jobs table to a value of 30.

USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 30)
GO
Also,
The current identity value can be larger than the maximum value in the table. DBCC CHECKIDENT does not reset the current identity value automatically in this case. To reset the current identity value when it is larger than the maximum value in the column, use either of two methods:

Execute DBCC CHECKIDENT ('table_name', NORESEED) to determine the current maximum value in the column, and then specify that as the new_reseed_value in a DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value) statement.


Execute DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value) with new_reseed_value set to a very low value, and then run DBCC CHECKIDENT ('table_name', RESEED).