How can i insert multiple records only single unique key

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Here I want to insert more then one records using only single id like

order id-1
item amount total
rin 5 29
lux 10
wheel 2
excel 12

Please give code or query for such type of insert records.

Posted 16-Sep-10 20:04pm

call to .net

Updated 16-Sep-10 21:35pm

Dalek Dave

v2

Add a Solution

Comments

Hiren solanki 17-Sep-10 2:14am

Can you please clarify your question again ? i am not getting what actually you want to ask

nagendrathecoder 17-Sep-10 2:22am

Here, are all these, "order id","item","amount" & "total" are columns of the same table? Or "Order id" is in different table?

Dalek Dave 17-Sep-10 3:35am

Minor Edit for clarity.

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)

nagendrathecoder · Answer 1 · 2010-09-16T20:48:00

Solution 1

After looking at your last few questions, its clear that you have not learned concepts of ADO.Net.
You are asking some very basic questions here and this will continue till you don't learn ADO.Net.
I suggest you to first buy a book and learn all concepts of ADO.Net.
It will definitely help you.

Posted 16-Sep-10 20:48pm

nagendrathecoder

Comments

Dalek Dave 17-Sep-10 3:36am

Harsh but fair!

Baji Jabbar · Answer 2 · 2010-09-16T20:48:00

Solution 3

Use one-to-many relationship. Create OrderTable and store the orderdetails such as id and date etc. Create OrderItemTable to store the Order Item details , here you can refer the order id from the orderTable to relate each item with a particular order.

Hope this will help you :)

Posted 16-Sep-10 20:48pm

Baji Jabbar

Charlesdhinakaran · Answer 3 · 2010-09-16T20:48:00

Solution 2

uses of unique key is to avoid duplicate entries and it enforce entity integrity as the primary key constraints, more than one record with single unique key is not possible.

Posted 16-Sep-10 20:48pm

Charlesdhinakaran