Auto increment the number after clicking submit button in c#.net calling store procedure

Question

Hi,

 Can you explain me how to auto increment the value like C00001,C00002 and go on.. using c#.net with asp.net webapplication and connection with sql server

thank you,

regards,
karthika