Add columns

Carlos kambui

11y1.2kSQL

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

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
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 Rajput11y ago
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 kambui11y ago
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 Rajput11y ago
Insert into tableName (adm_no) values( SELECT isnull(max(adm_no),0) from tblname)
Carlos kambui11y ago
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 Mishra11y ago
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 kambui11y ago
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 kambui11y ago
i don mean to increment primay key
Jagdev Mishra11y ago
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