Solved

Enrollment Application

Posted on 2008-09-30
8
186 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 500 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

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.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

622 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