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

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 12

Reply
User: vinayak
Replied: on Oct 29, 2012 04:58 AM
Report

get logic from following query,

Declare @emp1 table(ecode varchar(100))
declare @empcode varchar(100)
insert into @emp1
select 'eoo1'
union
select 'eoo1'
union
select 'eoo2'
union
select 'eoo3'

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

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