How to auto generate Serial Numbers in c# vs2010

puneet ahooja

10y7kC#

Dear All,

Year - Srl

I am creating a employee master form and i want to auto generate the PIN Number (personal identification number) i.e. EMP-1516-00001. in C# Vs2010

Database i am using MS Access 2007.

Can Anybody help , Thanks in Advance

Regards

Puneet Ahooja

5 Replies

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

siva M10y ago
Hai
Mr.Arunkumar
your code

public static string GetUniqueKey(int maxSize)
{
char[] chars = new char[62];
chars = "123456789".ToCharArray();
byte[] data = new byte[1];
RNGCryptoServiceProvider crypto = new RNGCryptoServiceProvider();
crypto.GetNonZeroBytes(data);
data = new byte[maxSize];
crypto.GetNonZeroBytes(data);
StringBuilder result = new StringBuilder(maxSize);
foreach (byte b in data)
{
result.Append(chars[b % (chars.Length)]);
}
return result.ToString();
}

private void auto()
{
txtInvoiceNo.Text = GetUniqueKey(8);
}
will automaticaly generate the number how can i change it into sequence number pls replay
Arun Kumar10y ago
Hi Puneet,
try this code.

public static string GetUniqueKey(int maxSize)
{
char[] chars = new char[62];
chars = "123456789".ToCharArray();
byte[] data = new byte[1];
RNGCryptoServiceProvider crypto = new RNGCryptoServiceProvider();
crypto.GetNonZeroBytes(data);
data = new byte[maxSize];
crypto.GetNonZeroBytes(data);
StringBuilder result = new StringBuilder(maxSize);
foreach (byte b in data)
{
result.Append(chars[b % (chars.Length)]);
}
return result.ToString();
}

private void auto()
{
txtInvoiceNo.Text = GetUniqueKey(8);
}
Mohammad Aman10y ago
CREATE TABLE [dbo].[EmployeeMaster](
[ID] [int] IDENTITY(1,1) NOT NULL,
[EmployeeNo] AS ('EMP-'+ RIGHT('0000-000' + CAST(Id AS VARCHAR(10)), 10)) PERSISTED,
[EmployeeName] VARCHAR(50),
CONSTRAINT [PK_AutoInc] PRIMARY KEY ([ID] ASC)
)

Create Table in MS-Accress like this

OR
Go through this given link:
http://stackoverflow.com/questions/2570728/how-to-auto-generate-an-alpha-numeric-id-in-c-sharp-using-ms-access-database

Other wise you have to use store procedure or whole CRUD operatrion.

if it help you then mark it correct ans.
puneet ahooja10y ago
Thanks Aman,

But i am not using SQL Database, I am using only MS Access 2007 database.

Regards
Puneet Ahooja
Mohammad Aman10y ago
I hope this will help you.
select 'FHMS' + max(SUBSTRING ( employeeId ,5 , 5 ))+1 as nextkey from employeemaster
I hope This is the query you are looking for
OR
Go to column's field -> Computed Column Specification
Past formula: ('EMP-'+right('0000-000'+CONVERT([varchar](10),[Id]),(10)))