Loading

how to generate a autoincreament value serially in a textbox

how to generate a autoincreament value serially in a textbox

prabha haran

9y1.7kLearn iOS Programming

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ananth G9y ago
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 Beg9y ago
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.