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: 9942

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

vinayak

0 15

Reply
User: vinayak
Replied: on Oct 30, 2012 03:08 AM
Report

create following stored procedure,

create procedure GetNextIdAsbegindeclare @empcode varchar(100)
select top 1 @empcode = 'eoo'+ CAST(SUBSTRING(ecode,4,LEN(ecode))+1 as varchar(100)) from @emp1 order by ecode desc
select @empcodeend

And to call this storeprocedure from code refer :

http://aspsnippets.com/Articles/Getting-ID-of-the-newly-inserted-record-in-SQL-Server-Database-using-ADO.Net.aspx

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