1.Center Name By
Textbox Name Enter New Delhi - ID Generation Ex: - ND001, ND002……
And
Next Time other Center Name (Dhanbad) Enter - Change ID Generation Ex: - DH001, DH002……
2.Center ID By
Dropdown List Center ID Select (ND001) –Next ID Generation Ex: - ND001A, ND001B, ND001B
Table View


Munesh SharmaPosted Apr 23, 2014, 12:40 AM
Jignesh TrivediPosted Apr 23, 2014, 12:20 AM
Is this auto Generated Column?
you can take the idea from my article
http://www.c-sharpcorner.com/UploadFile/ff2f08/auto-incremented-column-with-varchar-and-nvarchar-data-type/
hope this will help you.