how can generate auto incremented alpha numeric no?

Question

i have a registration page in asp.net c# language, and Sql database.
In registration page there are 2 Text Box.
and database table have 3 field. id no, name , f_name.
when we inter the text box 1= "lokesh"
and TextBox2= "kumar" then how can we store in the database Id ="lokesh0001"
and the next registration time Id ="name0002"
please give me some proper method