Auto Generation of EMP Numbers

asela nuwan

I just need to implement employee registration form, it include auto generation of employee number that will begins from 0001. right after the filling all the fields in the form record data in to data base and clear all the data withing form and increment the emp number by one 0002
how could i do this ?

4 Replies

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

SUNIL GUTTA12y ago
Friend Vulpes way is suggestable if you want try like this also i.e no need to create SP's simple stuff here .

command cmd=new command();
cmd.commandtext="select isNull(Max(eno),0001)+1 from employee";

txteno.text= cmd.executescalar();

Like this you can generate eno's automatically using simple sql statement using ado command classes .

Any issues revert back . Happy to help
Vulpes12y ago
I don't think the article is suggesting that you should somehow write the stored procedures in C#.

Just write them in SQL Server as you normally would and then call them from C# code.
asela nuwan12y ago
check this link

http://www.dotnetfunda.com/articles/show/2264/generating-custom-auto-numbers-and-using-it-in-application

this is what i want, but i'm confusing about "stored procedure" how can i create that in my current C# project
Vulpes12y ago
In principle you can create an auto-incrementing Employee ID as follows:

private int empId; // declare at form level

private Form1_Load(object sender, EventArgs e)
{
empId = 1; // or read previous value from database and add 1
}

private void ProcessRecord()
{
lblEmpId.Text = empId.ToString("D4");
empId++;
// rest of code
}