Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Enrollment Application

Posted on 2008-09-30
8
Medium Priority
?
191 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 Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month15 days, 11 hours left to enroll

580 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