How to generate Registration Id for Students?

Question

1.00/5 (1 vote)

See more:

Hai Sir,

How to generate auto generated Student Id based on Branch and Course likewise two Modules for College Registration..??

Posted 18-May-15 20:27pm

Kanaparthi Sureshma Reddy

Add a Solution

Comments

OriginalGriff 19-May-15 2:36am

We'd need to know a little more about what the final Id should look like: Remember that we can't see your screen, access your HDD, or read your mind.
And there are a lot of different information types here - we have no idea what exactly you need.
Use the "Improve question" widget to edit your question and provide better information.

Vinay Haravi 19-May-15 3:06am

Whether you wanted to generate Registration ID or Student ID ?
Provide more information on this, so that we can help you to resolve this issue.

Hemant Singh Rautela 19-May-15 4:00am

There are many ways :
1) just use auto generated column(int) for it.
2) create a code for update student-id column (first 2 digit for year, then 2/3 digit for branch code , 2/3 digit for course code - and last use 3 digit number for uniquely define student).

ZurdoDev 19-May-15 8:12am

Where are you stuck?

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Dnyaneshwar**@Pune · Answer 1 · 2015-05-19T22:01:00

Solution 1

refer

declare @Count int
declare @id varchar(10)

SET @Count = 1
WHILE (@Count <=10)
BEGIN
set @id='C'+RIGHT(REPLICATE('0', 4) + CAST(@Count AS VARCHAR(4)), 4)
PRINT @id
SET @Count = @Count + 1
END

Posted 19-May-15 22:01pm

Dnyaneshwar@Pune

How to generate Registration Id for Students?

1 solution

Solution 1

Add your solution here

Preview 0

How to generate Registration Id for Students?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us