auto generate serial number in asp.net

Question

1.00/5 (1 vote)

See more:

VS2010

Hi
I have a project in hand. where i have to enter serial number,category description,cost price,sale price and image upload.

I want serial number to come automatically through auto generated but not with is identity property.

so if one user enters 20 records and logs off. and then say after 2hrs another user logs in and enters data, that time serial number 21 should get displayed so that the 2nd user understands that 1st user has entered 20 records before her.

is it possible to do this way in asp.net?

i dont want the code. i just want if it can be done and if yes is there any technique?

and i want the serial number should get auto generated sequentialy like 1,2,3....

for example.

user 1 enters 20 records

when user 2 logs in she will see 21 number on serial number field while adding. so that she is aware that 20 records already entered in database.

Thanks
Sudeshna

Posted 24-Nov-14 23:17pm

sudeshna from bangkok

Add a Solution

Comments

Richard_Michael_RM 25-Nov-14 5:49am

Go To Database Right click table select design mode then select itemcode field goto properties in Identitiy Specification expand it and set Is Identity Yes and set Indentity Increment.

sudeshna from bangkok 25-Nov-14 5:51am

i dont want to use is identity property. i have used that. if some one deletes any data, then in that place no data will get inserted.

Richard_Michael_RM 25-Nov-14 6:00am

sudeshna dont use is identity
insert values from code as i told you by query

sudeshna from bangkok 25-Nov-14 6:02am

ok i will try this code and will let you know how its working.Thanks. even i also dnt want to use is identity

2 solutions

Solution 1

[^]

cheers

Posted 24-Nov-14 23:24pm

Richard_Michael_RM

Comments

sudeshna from bangkok 25-Nov-14 5:31am

hello. i dnt want that to show in gridview serial number. i have one field in database where serial number exists. that field is my product item code and i have to enter from user end and gets stored in db.

next time when user enters new item, serial number displays new number in textbox field

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)

Richard_Michael_RM · Accepted Answer · 2014-11-24T23:40:00

Solution 2

MAX Query on pageload

int query= select max(product_code) from table
SqlDataAdapter da= new SqlDataAdapter(query, SQLCONNECTION);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.rows.count>0)
{
query = query+1;
query= textbox.text
}

It would be really helpful

Posted 24-Nov-14 23:40pm

Richard_Michael_RM

Updated 24-Nov-14 23:46pm

v2

Comments

sudeshna from bangkok 25-Nov-14 5:51am

Thanks, i will implement this. if it runs will let you know

[no name] 25-Nov-14 5:53am

The big disadvantage is, that there is a small chance that you generate same serial number for different products in case last product will be deleted.

I suggest to use sequence if available (is available in MySql and MSSQL).

Richard_Michael_RM 25-Nov-14 5:56am

Agreed #Bruno

sudeshna from bangkok 25-Nov-14 5:58am

ya i have different products category, so for different products serial number will start from 1

Richard_Michael_RM 25-Nov-14 6:03am

use where clause for product in max query ...

Abid Shk 25-Nov-14 8:03am

u write max if no data in table then it will return NULL just change a query little bit use
max(coalesce(Product_code,0)) it will work perfectly

sudeshna from bangkok 25-Nov-14 22:11pm

Thanks all of you for the help