Auto Generate IdFor Student

Question

Can you please give me the idea about Auto generated Id For Student In c#. And i want to Start Id From 501 and store this id in database table please give me code for that.

Rahul Chavan · Answer

You can use below solutions but please go through below link before implementing the solution. There are some disadvantages of Setting Identity column. Below article shares the soultion for same http://www.codeproject.com/Tips/668042/SQL-Server-Auto-Identity-Column-Value-Jump-Is

Amit Kumar · Answer

HI Dear Click on EmpId Column then below this form fill open then set the Identity Seed =500 which id you want to start and set Identity increment id which you want to increment for every row. OR CREATE TABLE ( ID_column INT NOT NULL IDENTITY(5001) PRIMARY KEY ... ); Thanks Amit

Ravi Patel · Answer

Hi  try this way CREATE TABLE Student ( ID int IDENTITY(5011) PRIMARY KEY LastName varchar(255) NOT NULL FirstName varchar(255) Address varchar(255) City varchar(255) ) INSERT INTO Student(FirstNameLastName) VALUES ('Lars''Monsen')

Nirmal Roy · Answer

ex- CREATE TABLE [dbo].[t]( [id] [int] IDENTITY(5001) NOT NULL [name] [nchar](10) NULL ) insert into t values('sam roy') select * from t use this code........