Auto Increment Of Alphanumeric number using c#

Question

Hi,

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

thank you,

regards,
NagaRaju