Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Enrollment Application

Posted on 2008-09-30
8
Medium Priority
?
190 Views
Last Modified: 2012-05-05
I have a question about an application i'm going to create but haven't yet. I will have 5 tables with 1 table being the main table and having a relation to the others based on the PK from the main table.

I was wondering what the best method would be for me to create an application that has 5 sections of data to collect with all data going to different tables in my DB.
0
Comment
Question by:asp_net2
  • 4
  • 4
8 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22614494
Depends on the context of your application. Our comments would be more useful if you describe your application context in detail. You could use datasets and datatableadapters to ease the updating of the database.
0
 
LVL 4

Author Comment

by:asp_net2
ID: 22615323
The tables structure is listed above. I do plan on using DataSets with DataTables and DataAdapters. I'm just looking for some type of blueprint how i'm going to have a user fill out data on section 1 going to table 1 and then have on the same session submit data to different tables based upon the page there on.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22615393
If its a wizard like data entry then you can use multiple pages to enter data to each table. You can keep track of existing information entered at previous stages through the session. Or you could use a single page to add information if its not wizard type.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 4

Author Comment

by:asp_net2
ID: 22615567
I would like to use the ASP.NET wizard type interface/functionality. However i'm not sure nor have i seen any tutorials that show how to insert data into DB at the end and also how to use the wizard by inserting data into different tables on each wizard step. How do you relate the data to each table based on the first entry with the Primary Key.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 22615610
You have to define a dataset in memory and add relationships to it. Then you would add data to the dataset during the wizards and commit the data to the db at the end. OR if you are using the identity column in primary key then you have to save that before you can save any data into child tables.
0
 
LVL 4

Author Comment

by:asp_net2
ID: 22615838
Yeah i was thinking of using the identity. However, how would i use that once i finish step 1 for say, before going to step 2 and how would i be able to relate step 2 to step1?

What method would you choose?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 1000 total points
ID: 22616065
You have to save to table 1 in step 1 and retrieve the primary key. In the later steps, you would use that key to add data to child tables.
0
 
LVL 4

Author Comment

by:asp_net2
ID: 22617636
i thought if you use a Wizard Control that you have to submit all results at the very end. How do you submit results in Step2, 3, and 4 and then what about the final step?

Can you provide me an example of how i would retrieve the identity id after step1. I would define a DataTable probally for each step.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question