3tier Architecture using insert update delete

Question

1.00/5 (1 vote)

See more:

I am using 3 tier architecture for using insert update delete operations..
i want to generate number for prod_id in insert operation.
plz reply anyone

Posted 19-Sep-12 23:34pm

mohit jain

Updated 19-Sep-12 23:35pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 21-Sep-12 0:37am

Not a question. Not clear what's the problem.
--SA

3 solutions

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)

Dylan Morley · Answer 1 · 2012-09-20T00:41:00

Generating unique IDs in this context is the job of the database. You shouldn't be trying to manually create the prod_id value

You haven't mentioned what database you are using, I'm going to assume SQL Server.

* You probably have a 'Products' table or something like that. If prod_id is the unique identifier (primary key), then set the column to have the IDENTITY specification. Every time you insert into the table now, SQL Server will automatically generate the next available ID

* After inserting into the table, you can access the value that was generated by SQL by using the SCOPE_IDENTITY() function (are you using raw ADO.net? or an ORM like Entity Framework?)

vithal wadje · Answer 2 · 2012-09-19T23:42:00

Solution 2

this is a great artical will helps you click here
http://www.dotnetfunda.com/articles/article71.aspx[^]

Posted 19-Sep-12 23:42pm

vithal wadje

v2

Comments

[no name] 20-Sep-12 5:44am

great on my 5+

[no name] 20-Sep-12 5:46am

5+

Kuthuparakkal 20-Sep-12 6:54am

5+

[no name] 20-Sep-12 7:02am

again thanx Kuthuparakkal sir

DhavalBhattC# · Answer 3 · 2012-09-19T23:38:00

Solution 1

you can do this by two way

1 ) store your prod_id in global class and increment it by one before insert

2 ) pass your all data(without prod_id ) to database and after that find max existing prod_id from database and increment there in procedure

although first method is work fine but i prefer second method more.

Posted 19-Sep-12 23:38pm

DhavalBhattC#

Comments

mohit jain 20-Sep-12 5:40am

how to store prod_id in global class..
any sample code..

Dylan Morley 20-Sep-12 6:35am

Both of these options are just awful

3tier Architecture using insert update delete

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us