how to generate a autoincreament value serially in a textbox

Question

hi i have a form employee in that have a text box in that i wanted autogenerated value as e001 to last when create new employee in mvc

Ananth G · Answer

Sample Code: CREATE TABLE tbEmployee ( EmpId INT NOT NULL IDENTITY(1,1) PRIMARY KEY , EmpCode AS 'EMP' + RIGHT ( '0000' + CONVERT ( VARCHAR (5),EmpId),5) PERSISTED, EmployeeName VARCHAR (50), Age INT , Gender VARCHAR (10) ) --INSERT RECORDS IN TABLE INSERT INTO tbEmployee (EmployeeName,Age,Gender) VALUES ( 'Mayank' ,25, 'Male' ), ( 'Ankita' ,24, 'Female' ), ( 'Anuj' ,26, 'Male' ), ( 'Jaswinder' ,25, 'Male' ), ( 'Simran' ,25, 'Female' ) --CHECK INSERTED RECORD SELECT * FROM tbEmployee --CREATE A TEMPORARY TABLE CREATE TABLE # Temp ( Id INT NOT NULL IDENTITY(1,1), AutoId AS 'ABC' + RIGHT ( '0000' + CONVERT ( VARCHAR (5),Id),5) ) --INSERT DEFAULT 10000 RECORDS AT ONCE INSERT INTO # Temp DEFAULT VALUES ; GO 10000 --CHECK INSERTED RECORD SELECT * FROM # Temp Refer below reference:http://www.webcodeexpert.com/2015/08/auto-generate-auto-incremented-unique.html

Salman · Answer

Hi. For that first you need to save a value in db as 0 and when you create a new employee you need to retrieve the value from db. If the value is 0 then you need to increment by 1 and append e with that number and assign it to that textbox. And make sure that textbox is readonly so that nobody can change it. For reference use this link, http://www.dotnetspider.com/resources/43204-How-create-Alphanumeric-Auto-Increment.aspx thanks.

how to generate a autoincreament value serially in a textbox

Answers (2)