question realated to registration no of student

Question

0.00/5 (No votes)

See more:

.NET4.5

i want to auto genrate student registration no in textbox according to selected class from dropdownlist in such format..classname/registrationno/2014 how we can do

Posted 15-Jan-14 19:33pm

Member 10426233

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Deviprasad Das · Answer 1 · 2014-01-15T20:09:00

Solution 2

In every DB server auto increment feature exist.

In SQL Server you have IDENTITY.
In Oracle you have SEQUENCE.

So you can use any of the feature to achieve this.

Posted 15-Jan-14 20:09pm

Deviprasad Das

Rajkumar_Blr · Answer 2 · 2014-01-15T19:41:00

Solution 1

SQL

something like below,

registrationNumber.Text=ClassnameDropDownList.SelectedValue+"/"+(Query database to get no.of students in the class)+"/"+DateTime.Now.Year

C#

Database Query should be something like below

select count(S.No) from Student where classname='ABC' and year='2014'

Posted 15-Jan-14 19:41pm

Rajkumar_Blr

Updated 15-Jan-14 19:43pm

v3

sp_suresh · Answer 3 · 2014-01-15T20:19:00

For id generation acc to client then dont use database id generation
becse it will create itself format and also it will create problem in deleting .
For this use class and see below
your database query may be like this
select isnull(max(S.No),0) + 1 from Student where classname='ABC' and year='2014'
and registrationNumber.Text=ClassnameDropDownList.SelectedValue+"/"+(Query)+"/"+ DateTime.Now.Year