i want to autogenerate my empid

Question

I have created form empdetails where employee will enter his details like name,address etc the empid will be generated automatically in my case empid starts with usr0001 i have created table with empid column made it as identity
when user clicks on the this form i have textbox empid this textbox should display this auto genereated id. like usr002

How can i do that i'm using sql server 2005 in asp.net using c#

Can any1 help me on this.

Nitin Sontakke · Answer

@Lipika with respect to solution given by Saillesh how does it matter if it is a web application or a win form application? Can you please indicate a specific location where there is a problem.

lipika parida · Answer

ya saillesh ur ryt.but i want ado.net code in c# windows form

Nitin Sontakke · Answer

The round trip is involved and you can get the value of recently generated id column by calling functions like scope_identity But seriously think of removing usr i don't think it adds any value.

Saillesh Pawar · Answer

This post will help you solve the same http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/