I have master table called MCaste whose fields are as id int(identiity), cast_code (nvrchar(10)) , cast_desc varchar(50). then I design a C# windows form for this table as follows I want a code like user can only insert caste description and castcode should be generate automatic as like "CS00000001","CS00000002" AND so on. I dont have any idea. Plz help me to achieve this.
Thanks in advance.