Solved

Enrollment Application

Posted on 2008-09-30
8
185 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
Technology Partners: 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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 an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
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.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

734 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