Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
how to set primary key after delete a record ?
Abolfazl
Mar 23 2014 3:43 PM
909
Reply
hi
i have a table with a column set to primary key and is identify as yes.when i delete a record from table, primary key field deleted but primary key steel start from where old data has primary key.for example a record with primary key set to 1,i delete it but new record primary key set to 2.
i need to set it automatically to 1.
i use linq to sql for connect to database and i don't know sql server commands.i want to set it with linq to sql and c#.
thanks
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
how to load database in a listview with linq to sql?
How to Store Current Data Time To Database automatically.