how to generate automatic employee ids in sqlserver using c#

Try generating a random number of integer. If you do want to generate other than integer than you can also do that !
And then store that in the table along with the primary key...


Regards
Akiii

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

Here are two links that will help you :-

http://www.dotnetperls.com/random

http://www.c-sharpcorner.com/UploadFile/mahesh/RandomNumber10272005160549PM/RandomNumber.aspx


Thanks and Regards
Akiii

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

when ur creating employee table u can use identity function. Identity function will automatically generate number.

for example:

create table emp(ename varchar(20),eno int identity,sal int)

k.m.j.kiran

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

Keep the Column autogenrate means make it primary Key .It will Hold a only one value for every employee.

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

U CAN USE IDENTITY COLUMN TO AUTOMATIC GENERATE EMPLOYEE TABLE...


CREATE TABLE EMPLOYEE(EMPID INT IDENITY(1,1),EMPNAME VARCHAR(90))

REGARDS

sriram

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

public string generate_holidayid()
{
try
{
string holidayid;
if (conn.State == ConnectionState.Closed)
conn.Open();

cmd = new SqlCommand("holiday_mast", conn);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@HOLIDAY_ID","JP"));
cmd.Parameters.Add(new SqlParameter("@HOLIDAY_NAME", "JP"));
cmd.Parameters.Add(new SqlParameter("@HOLIDAY_DESC", "JP"));
cmd.Parameters.Add(new SqlParameter("@HOLIDAY_FROMDATE", "12/12/12"));
cmd.Parameters.Add(new SqlParameter("@HOLIDAY_TODATE", "12/12/12"));
cmd.Parameters.Add(new SqlParameter("@mode", 6));
DataSet dtset = new DataSet();

SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(dtset);
conn.Close();

if (dtset.Tables[0].Rows.Count <= 0)
{
holidayid = "HOL" + 01;
return holidayid;
}
else
{
char[] ch = { 'H', 'O', 'L'};
int id = int.Parse(dtset.Tables[0].Rows[0].ItemArray[0].ToString().Trim(ch)) + 1;
holidayid = "HOL" + id;
return holidayid;
}
}
catch (Exception e)
{
return null;
}
}

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

CREATE TABLE TABLE NAME(COLUMN1 INT IDENTITY(1,1) PRIMARY KEY NOT NULL,COLUMN2 VARCHAR(10))

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

Hi Reddysankark,
If you want to generate the Employee id automatically then you can do it in SqlServer itself, no need to write a Single line of code in C#.
If you want to see your Employee id like 1, 2, 3, 4 ....... then use AutoIncrement Column.
If you want to see your Employee id looks like xyz001, xyz002...... then you can use Computed Column for this type of Employee id.

Thanks

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator