Solved

Enrollment Application

Posted on 2008-09-30
8
184 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
Reading the Web.Config using IIS 7.5? 4 49
transaction in asp.net, sql server 6 43
C# LINQ ForEach() question 6 54
asp.net open new page without popup blocker 8 19
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…
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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