Click here to Skip to main content
13,351,682 members (44,410 online)
   

ASP.NET

 
QuestionDataset Issue Pin
Abhismart5527-Feb-13 4:18
memberAbhismart5527-Feb-13 4:18 
AnswerRe: Dataset Issue Pin
Abhismart5527-Feb-13 8:15
memberAbhismart5527-Feb-13 8:15 
QuestionBinding gridview from two tables Pin
demoninside925-Feb-13 23:45
memberdemoninside925-Feb-13 23:45 
AnswerRe: Binding gridview from two tables Pin
David Mujica26-Feb-13 6:09
memberDavid Mujica26-Feb-13 6:09 
Questioncustom MVC authorization and Authorize Pin
Super Lloyd25-Feb-13 21:07
memberSuper Lloyd25-Feb-13 21:07 
QuestionMVC Model + Entity Design Guidance Needed. Pin
nlarson1125-Feb-13 12:51
membernlarson1125-Feb-13 12:51 
QuestionMaintaining Array Data in an SQL Database. Pin
Bram van Kampen24-Feb-13 16:23
memberBram van Kampen24-Feb-13 16:23 
AnswerRe: Maintaining Array Data in an SQL Database. Pin
David Mujica25-Feb-13 4:02
memberDavid Mujica25-Feb-13 4: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:
Questiondelete a table data&structure Pin
Member 870181322-Feb-13 4:25
memberMember 870181322-Feb-13 4:25 
QuestionRe: delete a table data&structure Pin
Richard MacCutchan22-Feb-13 5:01
mvpRichard MacCutchan22-Feb-13 5:01 
AnswerRe: delete a table data&structure Pin
Member 870181322-Feb-13 5:30
memberMember 870181322-Feb-13 5:30 
GeneralRe: delete a table data&structure Pin
Richard MacCutchan22-Feb-13 5:45
mvpRichard MacCutchan22-Feb-13 5:45 
GeneralRe: delete a table data&structure Pin
Member 870181322-Feb-13 6:53
memberMember 870181322-Feb-13 6:53 
GeneralRe: delete a table data&structure Pin
Richard MacCutchan22-Feb-13 7:07
mvpRichard MacCutchan22-Feb-13 7:07 
AnswerDROP TABLE Pin
David Mujica22-Feb-13 5:20
memberDavid Mujica22-Feb-13 5:20 
GeneralRe: DROP TABLE Pin
Member 870181322-Feb-13 5:31
memberMember 870181322-Feb-13 5:31 
QuestionMVC and Web.config(ssssss)???!!!!!?? Pin
Super Lloyd21-Feb-13 15:14
memberSuper Lloyd21-Feb-13 15:14 
AnswerRe: MVC and Web.config(ssssss)???!!!!!?? Pin
Sandeep Mewara21-Feb-13 20:06
mvpSandeep Mewara21-Feb-13 20:06 
GeneralRe: MVC and Web.config(ssssss)???!!!!!?? Pin
Super Lloyd21-Feb-13 22:49
memberSuper Lloyd21-Feb-13 22:49 
GeneralRe: MVC and Web.config(ssssss)???!!!!!?? Pin
Sandeep Mewara21-Feb-13 23:09
mvpSandeep Mewara21-Feb-13 23:09 
QuestionDynamically update price based on exchange rate Pin
Deepa420-Feb-13 21:06
memberDeepa420-Feb-13 21:06 
AnswerRe: Dynamically update price based on exchange rate Pin
Sandeep Mewara20-Feb-13 22:49
mvpSandeep Mewara20-Feb-13 22:49 
GeneralRe: Dynamically update price based on exchange rate Pin
Deepa420-Feb-13 23:00
memberDeepa420-Feb-13 23:00 
GeneralRe: Dynamically update price based on exchange rate Pin
Sandeep Mewara20-Feb-13 23:59
mvpSandeep Mewara20-Feb-13 23:59 
AnswerRe: Dynamically update price based on exchange rate Pin
Richard MacCutchan21-Feb-13 0:02
mvpRichard MacCutchan21-Feb-13 0:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web02 | 2.8.180111.1 | Last Updated 20 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid