I need to pass information between 2 new web pages in a new C# 2010 web form application.
I will need to pass information that would update two different tables. One table contains about 50 columns that would update one row in the table called 'main'. The second table called 'sub' only has 4 columns in each row. However the second table is joined to the fist table and can have from 1 to 400 rows that ties to the 'main' table.
Could I pass the information between the passes using a dataset that contains two data tables? Is that a possibility?
Thus I am wondering what option would be the best for my situation?
Loading
Posted Jun 13, 2012, 11:15 PM
Session["Dataset"] = "YourDataSet";
or
Session["main"] = "MainTable";
Session["Sub"] = "Sub";
The number of rows also not huge, it just about 400 records.
scampercatPosted Jun 14, 2012, 12:00 AM
I still have the following questions:
1. For data that will end up on the main table, I currently have all kinds of individual columns.
How would you organize the data from page one that goes to page two that will eventually end up in the main table? Would you set up a struct, start a new class, send all the values across as individual columns?
2. When the user enters information that will end up in the sub table that contains 1 or 400 columns, how would you setup the dataset?