Automatically generate Auto Incremented Code from Database in ASP.Net TextBox

rifayeem

SOLVED CLOSED ACTIVE ANSWERED
User: rifayeem
Posted: on Oct 25, 2012 11:48 PM
Forum: ASP.Net Web Forms
Replies: 18
Views: 9941

how to generate a employee code in textbox automatically while in run time in web application.......when i run the page it will check the employee code in the database and it automatically shows the next value in the textbox how?

Download FREE API for Word, Excel and PDF in ASP.Net

rifayeem

0 10

Reply
User: rifayeem
Replied: on Oct 29, 2012 03:47 AM
Report

1.CREATE PROCEDURE [dbo].[getnextid2]
      @Empcode varchar(50),
      @FirstName varchar(50),
      @LastName varchar(50),
      @dob datetime,
         @Country varchar(50)
AS
BEGIN
     
      select top 1 @empcode=empcode from emp1 order by empcode desc
      select @Empcode 
      INSERT INTO  Emp1 (empcode  ,fname , lname , dob , Country)
      VALUES (@empcode ,@FirstName, @LastName, @dob,  @Country)
END

2.in register form
3.vb.net

thanks dude

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Automatically generate Auto Incremented Code from Database in ASP.Net TextBox

Company

Explore

Follow us

Contact Us