How to generate employee ID in c# asp.net

Question

Hi I using Visual Studio 2010 Please Share generate Employee ID for Register user in c# asp.netPlease post answer Thanking You Venkat

Govinda Rajulu Yemineni · Answer

DECLARE @EMPID INT SET @EMPID = ISNULL (@EMPID( SELECT MAX (EMPID) FROM tbl_Employee) + 1) Insert into tbl_Employee (EMPIDEMPFirstNameEMPLastName .....) Values (@EMPID .....)

Jaipal Reddy · Answer

Try to se procedure as in the following way - Create Procedure InsertEmpDetails ( @Name NVARCHAR(100) ) AS Begin DECLARE @ID INT SET @ID = ISNULL(@ID(SELECT MAX(Id) FROM tblEmployee) + 1) Insert into tblEmployee (ID Name ...) Values(@ID ) End

Rajeesh Menoth · Answer

Hi Try this one : http://www.c-sharpcorner.com/forums/thread/201196/generate-empid-automatically-in-Asp-Net-C-Sharp.aspx

Venkat Govind · Answer

Hi I want Code for generate Employee ID Card for Register user in c# asp.net

Rajeesh Menoth · Answer

Hi select 'FHMS' + max ( SUBSTRING ( employeeId  5  5 ))+ 1 as nextkey from employeemaster Try this : http://www.dotnetspark.com/Forum/3698-how-to-generate-user-id-automatically.aspx