Automatic generated Id should be constant for all the orders placed by the customer

Question

0.00/5 (No votes)

See more:

A customer is entering the order details.Each time he can enter only one order from the list.He want to place an order for 5 items.order id will be automatically generated.But as long as he places the order the id should be constant

Posted 6-Nov-11 19:41pm

sirisha89

Add a Solution

Comments

amitit1989 7-Nov-11 1:57am

can you please explain "But as long as he places the order the id should be constant",
Please explain in more detail what do you want?

sirisha89 7-Nov-11 2:18am

I mean to say for all the 5 items the order id should be same

2 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)

thatraja · Answer 1 · 2011-11-06T21:33:00

Your question is not clear. But based on my guess I give you this answer.
Actually you need 3 tables(Just sample & add more fields you want). You should separate the items details. One to many.

TblCustomer
-------------
CustomerID
CustomerName

TblOrderMaster
-------------
OrderID
OrderDate
CustomerID

TblOrderDetails
-------------
OrderID
Items
Qty

So the data will be like this

Customer Details
CustomerID CustomerName
----------------------------------------------------
1          Customer 1
2          Customer 2

Order Master
OrderID  OrderDate    CustomerID
----------------------------------------------------
101      01-Nov-2011  1
102      02-Nov-2011  1
103      03-Nov-2011  1

Order Details
OrderID  Items        Qty
----------------------------------------------------
101      BACON        10
101      PIZZA        5
102      BACON        5
102      PIZZA        15
102      DIET COKE    10
103      PIZZA        5

Here the Order 101 contains 2 items, 102 contains 3 items.

Use this[^] for Identity insert.

deepakdynamite · Answer 2 · 2011-11-06T20:08:00

Solution 1

Hello,

As per my understanding of question, You can do one thing :

Whenever customer selects first item, at that time just insert record in DB and keep your ID in Session or somewhere else , and then on every insert fetch it again..

I am not sure if this will help you as question isn't clearly written.

Posted 6-Nov-11 20:08pm

deepakdynamite

Comments

sirisha89 7-Nov-11 2:46am

In which context of the query u did't have the clarity