lipika parida

lipika parida

  • 2k
  • 37
  • 512

i want to autogenerate my empid

Jan 17 2017 2:25 AM
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 using c#

Can any1 help me on this.

Answers (4)