How to Gnerate Unique ID for particular Student while registration

Question

0.00/5 (No votes)

See more:

i want to generate unique id for Student while registration with combination of three values
1-first two letters of the school name ex:(WiseTime)
2-Autogenerated Number ex:(1)
3-year of registration ex:(2013)

//i want that unique ID as like below
wi12013 - first student
wi22013 - second student
-
-
//like that i want to generate the id for student.

//is it possible

i am having only one value that is school name.rest of the two values Auto generated number,current year

//this was my code sir in the @student_id i want to pass the value with aboue criteria

SqlCommand cmdAdmission = DBManager.DataAccess.command();
cmdAdmission.Parameters.Add(new SqlParameter("@option", SqlDbType.VarChar, 50));
cmdAdmission.Parameters["@option"].Value = "SubmitAdmission";

cmdAdmission.Parameters.Add(new SqlParameter("@Student_id",SqlDbType.VarChar,20));
cmdAdmission.Parameters["@Student_id"].Value = ?????

cmdAdmission.Parameters.Add(new SqlParameter("@School_Name", SqlDbType.NVarChar,100));
cmdAdmission.Parameters["@School_Name"].Value = Session["SchoolName"].ToString();

cmdAdmission.Parameters.Add(new SqlParameter("@Date_of_birth",SqlDbType.VarChar,20));
cmdAdmission.Parameters["@Date_of_birth"].Value = DOB;

string sqlquery = "SchoolProc";
DBManager.DataAccess.executeQuery(sqlquery);
if (DBManager.DataAccess.i > 0)
{
string strScript = "<script>";
strScript += "alert('Child Details Taken Successfully');";
strScript += "</script>";
strScript += "window.location='welcome.aspx';";
Page.RegisterClientScriptBlock("strScript", strScript);
DBManager.DataAccess.EmptyTextBoxes(this.Page);
}

Posted 18-Feb-13 22:36pm

ntitish

Updated 19-Feb-13 0:12am

v5

Add a Solution

4 solutions

Solution 2

Yes, it's possible. Exactly how you would do it will depend on what kind of systems you are interfacing, and where you are storing the info, and where you want to generate it.

However, I would suggest that you re-think your scheme a little: firstly work out how many students you can get in a year and allocate a suitable number of digits as a fixed length. So if you can expect 250 students in a year, allow three digits and pad with zeros, if you can expect 950 than allow four digits and again pad with zeros.

Secondly, change the order slightly: swap the year and student number.

ssYYYYnnnn
where
  ss    is the school,
  YYYY  is the year,
  nnnn  is the student number

Is a lot easier to search for and sort than dealing with variable length student numbers in the middle.

"sir i am coding through front end that means through asp.net...."

I see from you modifications to the question that you are using SQL - OK, here is how I would do it.

SQL Server has the facility to generate automatic number fields: it can add a value (one for example) to an integer field each time you insert a record. If you use this, you can preset it to the year and a start number each academic year:

20120001 for the year 2012-2013
20130001 for the year 2013-2014
20140001 for the year 2014-2015

And it will generate the number for you.
If you set up two fields in your table:

SchoolId   CHAR(2)
StudentID  INT, Identity

You can return the whole code by:

SQL

SELECT SchoolId + CAST(StudentId AS varChar(8)) AS ID FROM myTable

At the start of registrations for the new academic year, you reset the starting value of the identity field to the new year value, and let SQL handle all the rest! The beauty of this is that it lets SQL do the work, so this will always work in a multiuser environment - so if you have five clerks entering new student data, they can't end up with two students with the same number!

Posted 18-Feb-13 22:50pm

OriginalGriff

Updated 18-Feb-13 23:59pm

v2

Comments

ntitish 19-Feb-13 4:58am

then how to get the current year sir...and number of the student.

OriginalGriff 19-Feb-13 5:43am

As I say, it depends on what you are trying to use. If it;s an SQL database, then there are a number of solutions, if it's an XML file there are differernt methods. Single user methods will also be very different from multiuser solutions. The year is easy, regardless of wht you do - but how you get it may also change depending on what you are doing!

So tell us what you want to do in enough detail! :laugh:

ntitish 19-Feb-13 6:06am

sir u not getting my problem i think so. it was my fault only. i am unable to explain my problem.

OriginalGriff 19-Feb-13 6:16am

Try teh suggestion I gave a little while ago - it's easier than you think, and it will do what you want. Trust me on this...

ntitish 19-Feb-13 6:20am

I want that id with school_name also sir, for example wisetime is my school name means my ID for current year should be in this format
WI20130001

OriginalGriff 19-Feb-13 6:29am

Yes, I know. If you look at what I suggested, the "WI" goes in the SchoolID, and the SELECT returns a single string which includes the WI and the number in a column called "ID"

ntitish 19-Feb-13 7:09am

actually i am developing a web application for multiple schools...so i want generate different ids for different schools....actually i am getting the out put can u see that and, can u say it is proper are not..i am displaying my code below.

public void AutoGeneratedCode()
{
con.Open();
int newid = 1;
string strnewid = " ";
SqlCommand cmd = new SqlCommand("select max(student_id) from student_details", con);
object obj = cmd.ExecuteScalar();
if (obj.ToString() != "")
{
string s = DateTime.Now.Year.ToString();
newid = Convert.ToInt32(obj.ToString()) + 1;
strnewid = newid.ToString();
strnewid = strnewid.PadLeft(4, '0');
string UID = strnewid + s;
ViewState["UID"] = UID;
}
else
{
string s = DateTime.Now.Year.ToString();
strnewid = newid.ToString();
strnewid = strnewid.PadLeft(4, '0');
string UID = strnewid + s;
ViewState["UID"] = UID;
}
con.Close();
}

protected void btnsave_click(object sender,eventargs e)
{
string SchoolName = Session["SchoolName"].ToString();
string prefix = SchoolName.Substring(0, 2);
string uid = ViewState["UID"].ToString();
SqlCommand cmdAdmission = DBManager.DataAccess.command();
cmdAdmission.Parameters.Add(new SqlParameter("@option", SqlDbType.VarChar, 50));
cmdAdmission.Parameters["@option"].Value = "SubmitAdmission";

cmdAdmission.Parameters.Add(new SqlParameter("@Student_id",SqlDbType.VarChar,20));
cmdAdmission.Parameters["@Student_id"].Value =

cmdAdmission.Parameters.Add(new SqlParameter("@School_Name", SqlDbType.NVarChar,100));
cmdAdmission.Parameters["@School_Name"].Value = Session["SchoolName"].ToString();

string sqlquery = "SchoolProc";
DBManager.DataAccess.executeQuery(sqlquery);
if (DBManager.DataAccess.i > 0)
{
string strScript = "<script>";
strScript += "alert('Child Details Taken Successfully');";
strScript += "</script>";
strScript += "window.location='welcome.aspx';";
Page.RegisterClientScriptBlock("strScript", strScript);
DBManager.DataAccess.EmptyTextBoxes(this.Page);
}
}

//sir i am having one dought if i write sql query on fron end means it will create any problem ha sir.....

ntitish 19-Feb-13 5:45am

sir i am coding through front end that means through asp.net.... not from sql ..just i will store that ID in one variable and i will pass that variable into table..

ntitish 19-Feb-13 5:55am

//this was my code sir in the @student_id i want to pass the value with aboue criteria

SqlCommand cmdAdmission = DBManager.DataAccess.command();
cmdAdmission.Parameters.Add(new SqlParameter("@option", SqlDbType.VarChar, 50));
cmdAdmission.Parameters["@option"].Value = "SubmitAdmission";

cmdAdmission.Parameters.Add(new SqlParameter("@Student_id",SqlDbType.VarChar,20));
cmdAdmission.Parameters["@Student_id"].Value = ?????

cmdAdmission.Parameters.Add(new SqlParameter("@School_Name", SqlDbType.NVarChar,100));
cmdAdmission.Parameters["@School_Name"].Value = Session["SchoolName"].ToString();

cmdAdmission.Parameters.Add(new SqlParameter("@Date_of_birth",SqlDbType.VarChar,20));
cmdAdmission.Parameters["@Date_of_birth"].Value = DOB;

string sqlquery = "SchoolProc";
DBManager.DataAccess.executeQuery(sqlquery);
if (DBManager.DataAccess.i > 0)
{
string strScript = "<script>";
strScript += "alert('Child Details Taken Successfully');";
strScript += "</script>";
strScript += "window.location='welcome.aspx';";
Page.RegisterClientScriptBlock("strScript", strScript);
DBManager.DataAccess.EmptyTextBoxes(this.Page);
}

OriginalGriff 19-Feb-13 5:59am

Answer updated

Solution 3

Check some similar threads I have answered before:
AutoGenerate Id For Insert Operation[^]
How can we Re-Generated sequencial user id in autogenerated column in sql.[^]

..and more on CP Search[^]

Posted 18-Feb-13 22:53pm

Prasad_Kulkarni

Solution 4

SQL

select 'QA /' + substring(convert(varchar(11),getdate(),102),3,2) +
substring(convert(varchar(11),getdate(),100),1,3) + '/' +
ltrim(substring(convert(varchar(11),getdate(),100),5,2))

output :--
QA/Curentyear and month/currentDate

Posted 18-Feb-13 23:59pm

Gaurang231

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)

NarenDx · Accepted Answer · 2013-02-18T22:48:00

Use this Code for Auto Generate...

C#

public void autogencode()
    {
        con.Open();
        int newid = 1;
        string strnewid = " ";
        cmd = new SqlCommand("select max(ProjectNo) from TblNewProject ", con);
        object obj = cmd.ExecuteScalar();
        if (obj.ToString() != "")
        {
            newid = Convert.ToInt32(obj.ToString()) + 1;
            strnewid = newid.ToString();
            strnewid = strnewid.PadLeft(3, '0');
            autoid = "CAS" +"/"+ (txtprojectcode.Text).ToUpper() +"/"+ strnewid;
            auto = newid;
        }
        else
        {
            autoid = "CAS" +"/"+ (txtprojectcode.Text).ToUpper() +"/"+ "001";
            auto = 1;
        }
        con.Close();
    }