Add columns

Question

i have student table and student_id is primary key ,there is another column adm_no and i want when i admit new student adm_no increment by one without skipping i.e 1001 ,1002 etc int x = 0; x = x + 1; tStudent.adm_no = Convert.ToInt32(txtadm.Text) + x; i have the above code but not working . any assistant will be highly appreciated

Jagdev Mishra · Answer

I think you need to work this operation in database then it will easy. When you are going to add new student then get the identity of primary key value and add +1. Like Insert into tableName adm_no values( SELECT IDENT_CURRENT('tableName ')+1) It should work. Thanks

Upendra Pratap Shahi · Answer

Hello, Use this concept. This is a standard coding concept- for this you put a prefix table and this table you should define the prefix category for all details. e.g.- admission-100 course-200 faculty-300 nad many more and you put your data in admission table as auto-incremented form and when you want to show the details then you join your details with prefix table - e.g.- if your admissionnnumber in admission table is 1 then it shows 1001('100'+'1')[Here 100 from prefix table and 1 from admission table] If this is satisfied you kindly mark the answer as Accepted Answer

Khargesh Rajput · Answer

your query is not fully visible here INSERT INTO students VALUES ( (select isnull(max(admin_no),0) from students) ,@first_name,@last_name,@sir_name,@id_no,@dob,@Sex,@date_admisio ......

Carlos kambui · Answer

below is my sql statement help to add adm_no value by one INSERT INTO students VALUES (@adm_no,@first_name,@last_name,@sir_name,@id_no,@dob,@Sex,@date_admision,@comment,@branch_id) SET @student_id = (SELECT SCOPE_IDENTITY())"

Khargesh Rajput · Answer

Insert into tableName (adm_no) values( SELECT isnull(max(adm_no),0) from tblname)

Carlos kambui · Answer

student_id is working properly i want to know how to add adm_no by one after every registration,i.e if am regestering Student i don have to input adm_no it also increment by 0ne am using c#

Jagdev Mishra · Answer

Is Your student_id is auto incremented column? If not then please allow to auto increment to student_id, then you will get every time a new incremented value.

Carlos kambui · Answer

student_id is primary key adm_no is another column and i want adm_no to start with 1001,1002, while student_id start from 1,2 without skipping number

Carlos kambui · Answer

i don mean to increment primay key