How to increase ID in MS SQL database when inserting data via textbox's on ASP.NET site

Question

Possible Duplicate:
Auto-increment primary key in SQL tables

i have a question about how i can get auto increase and enter the ID in my MS SQL Database, when i'm inserting data via textbox's on my ASP.NET Website, i will try this guide..

http://mrbool.com/inserting-data-into-sql-server-database-using-csharp-and-asp-net/25091

But as you can see it, the user needs to write an ID, but that's not what i wanted.. Can you help me ? :)

The ID is assigned by the database; you don't need to write it. — Robert Harvey, Dec 18 '12 at 16:25
In SQL Server, define your ID column as an identity and don't give the user any way to edit it. It'll be assigned a number automatically when a record is inserted. — Bridge, Dec 18 '12 at 16:25
http://msdn.microsoft.com/en-us/library/dd338603.aspx read this it's straight and to the point.. — MethodMan, Dec 18 '12 at 16:29

score 1 · Accepted Answer · edited May 23 '17 at 12:04

1

You need to make the id column type int and set auto increment property of this field. This is a similar post.

edited May 23 '17 at 12:04

Community

1
1

answered Dec 18 '12 at 16:24

Adil

146,340
25
209
204

Did you check the article he linked? It's not coming up for me here, so I can't see it. – Robert Harvey Dec 18 '12 at 16:26
1

I think you mean "Identity" as this is for SQL Server - AUTO_INCREMENT is for MySql. – Bridge Dec 18 '12 at 16:27
I take it the article writer didn't explain this part. – Robert Harvey Dec 18 '12 at 16:27
Sry that im new on this website... I could just not find it.... But thanks for the help :) – user1913474 Dec 18 '12 at 16:50

How to increase ID in MS SQL database when inserting data via textbox's on ASP.NET site

1 Answers1