i want to autogenerate my empid

@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.

0

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

0

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.

0

This post will help you solve the same

http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/

0