Click here to Skip to main content
       

ASP.NET

 
AnswerRe: Develop a Custom Login page PinmvpSandeep Mewara25-Feb-13 18:13 
AnswerRe: Develop a Custom Login page PinmvpRahul Rajat Singh25-Feb-13 20:04 
Questionproblem with intelligencia.urlrewriter PinmemberC#Programmer201224-Feb-13 22:32 
AnswerRe: problem with intelligencia.urlrewriter PinmemberC#Programmer201225-Feb-13 17:57 
QuestionRe: problem with intelligencia.urlrewriter Pinmemberryanb3126-Feb-13 10:35 
AnswerRe: problem with intelligencia.urlrewriter PinmemberC#Programmer201226-Feb-13 17:48 
QuestionMaintaining Array Data in an SQL Database. PinmemberBram van Kampen24-Feb-13 15:23 
AnswerRe: Maintaining Array Data in an SQL Database. PinmemberDavid Mujica25-Feb-13 3:02 
Yes, SQL can store the data you describe quite well.
 
Here are a few terms you may want to research:
 
1) Primary key
2) Foreign key
3) Transaction
 
Basically what you describe is a classic Master-detail relationship where the Order is the master and the Items are the details. You would define a primary key on the Order table which uniquely defines the order, then that primary key is used in the Items table as a foreign key (relating all of the Items back to the single Order).
 
When you do updates to the Order/Items, you will use a transaction which ensures that all of the updates across all of the records are performed consistently or not at all.
 
Hope this helps.
Cool | :cool:
Questionsaving and retrieving recent activities PinmemberJassim Rahma24-Feb-13 4:40 
AnswerRe: saving and retrieving recent activities Pinmemberjkirkerx26-Feb-13 11:04 
Generalasp.net export to excel Pinmemberpppppsssss24-Feb-13 0:50 
GeneralRe: asp.net export to excel PinmvpSandeep Mewara24-Feb-13 1:18 
AnswerRe: asp.net export to excel Pinmemberryanb3126-Feb-13 10:37 
Questionhow to linbutton's text on another page button click event PinmemberMember 870181323-Feb-13 2:56 
AnswerRe: how to linbutton's text on another page button click event PinmvpSandeep Mewara23-Feb-13 3:28 
GeneralRe: how to linbutton's text on another page button click event PinmemberMember 870181323-Feb-13 6:55 
GeneralRe: how to linbutton's text on another page button click event PinmemberMember 870181323-Feb-13 22:40 
GeneralRe: how to linbutton's text on another page button click event PinmvpSandeep Mewara23-Feb-13 22:46 
Questionhtml5 with vs2010 Pinmembermanoranjan gupta23-Feb-13 2:07 
AnswerRe: html5 with vs2010 PinmvpSandeep Mewara23-Feb-13 3:10 
Question70-480 Course Book Pinmembersilentspeaker23-Feb-13 0:35 
AnswerRe: 70-480 Course Book PinmvpRichard MacCutchan23-Feb-13 1:07 
Questionvisul studio installing Pinmemberagrigold22-Feb-13 22:48 
AnswerRe: visul studio installing PinmemberMarco Bertschi23-Feb-13 1:42 
AnswerRe: visul studio installing PinmvpSandeep Mewara23-Feb-13 3:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140905.1 | Last Updated 15 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid