ow to display auto generate id with username with year in as

Anjali Khan

8y1.1k.NET

ow to display auto generate id with username with year in asp.net

How to display auto generate id like Ashu/2017/1

here 1 is auto generate id and ashu id login name .how to do this

note - i created form n submit in db aftr dispaly records in gv i want UserId - Ashu/year/1

in my table todays date column is there for generate today date .so here is showing year also so how to bind year with userid column

My procedure is

ALTER PROC [dbo].[Records_Display]

(

@UserId int = null,

@PageIndex INT = NULL,

@PageSize INT = NULL ,

@RecordCount INT OUTPUT

)

BEGIN

BEGIN TRY

SET NOCOUNT ON;

BEGIN

SELECT UserId,Designation,

CONVERT(varchar(20),LetterDate,103) as LetterDate,Convert(varchar(20),ReceivedDate,103) as ReceivedDate,[Subject],

year(TodayDate) as todaydate

FROM tbl_Records

order by UserId desc

END

and i kept in gv my cloumn like

4 Replies

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

Ankit Sharma8y ago
Accepted answer
Hi Anjali,

Use the below SQL to get the output in your desired format as name/year/id
Select (tbl.UserName+'/'+CAST(YEAR(tbl.TodayDate)as varchar)+'/'+CAST(tbl.UserId AS VARCHAR)) as result
from tbl_Records tbl
Then bind this to column in your gridview.
+1
Anjali Khan8y ago
Thanks ankit

it is working for me
0
Ankit Sharma8y ago
I don't think identity column will make any difference. if your table has userid column in it then this query will work.
Please share your table definition and some sample data , i will look into it
0
Anjali Khan8y ago
Hi Ankit

In my db UserId is Identitycolumn like auto generate and if i kept this so i am getting error like UserId column is invalid
0