Generate serial number in asp.net

Question

1.00/5 (1 vote)

See more:

Hi I have a table whose query is given below

SQL

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbl_stud_detail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tbl_stud_detail]
GO

CREATE TABLE [dbo].[tbl_stud_detail] (
	[id] [int] NULL ,
	[std_form_no] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[std_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[std_dob] [datetime] NULL ,
	[std_religion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[std_sex] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[std_father_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]

I have a multiple user that fill the form and data will go into this table. Problem is that I have to create form number unique. What I did I am creating auto genrate number and fill it in the form no column after getting max value of id column. But when multiple user request at single point of time then same max number will go into the std_form_no column. Then how to generate unique value for each user when multiple user request at single point of time.
Thanks in advance.

Posted 18-Oct-12 22:49pm

singh7pankaj

Add a Solution

Comments

vivektiwari97701 19-Oct-12 5:08am

u can use GUID for genrate unique no every time .

singh7pankaj 19-Oct-12 5:20am

But I want Sequential number e.g 0001,0002,0003,0004 etc. But Guid give different number.

4 solutions

Solution 2

Get Id from Sequence..
Insert sequence nextval as ID while inserting records.
OR
you can you identity for ID column

Posted 18-Oct-12 23:21pm

manak chand

Updated 18-Oct-12 23:24pm

v2

Comments

singh7pankaj 19-Oct-12 5:29am

Sequence is not working in sql server 2008 and identity column may get problem when fetching the record because when 4 user request for the identity value at that single point of time then identity value for all the user is same. at that time what I'll have to do?

Ambesha 19-Oct-12 5:31am

identity number for n number of user can't be same.. :)

manak chand 19-Oct-12 6:33am

sql server will insert record one by one. you can save the ID while inserting Record...
If you want to get values before inserting record Sequence will work... I had user it..

manak chand 19-Oct-12 6:34am

for more precautions, you can set ID column as Primary key

Solution 3

SQL

CREATE TABLE [dbo].[tbl_stud_detail] (
    [id] [int] IDENTITY(1,1) PRIMARY,
    [std_form_no] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [std_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [std_dob] [datetime] NULL ,
    [std_religion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [std_sex] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [std_father_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

Add a primary key to the table having identity column
so that the SQL server will auto-generate the column value and you dont need to pass it everytime you insert a new row.

Posted 19-Oct-12 0:27am

Nitin S

Solution 4

you can use this code in aspx.cs page>>>>

C#

string id = System.DateTime.Now.ToFileTime().ToString().Substring(5, 9);

Posted 19-Oct-12 0:31am

arnabdattachaudhuri

Updated 19-Oct-12 1:04am

v2

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)

Ambesha · Accepted Answer · 2012-10-18T23:18:00

Solution 1

Use the random class in frontend or use GUID form backend.

Thanks,
Ambesha

Posted 18-Oct-12 23:18pm

Ambesha

Comments

singh7pankaj 19-Oct-12 5:26am

when I am using GUID then it gives different number but What my no is in sequential way e.g 0001,0002,0003,0004 etc.

Ambesha 19-Oct-12 5:30am

in this case create identity colomn and give the seed value as you required.

Thanks,
Ambesha