Using ASP.NET to mimick MS Access forms/navigation/and reports
Posted on 2006-05-08
As a learning project I would like to recreate a project that I made in
MS Access within ASP.NET. Could someone help by commenting on the
correctness of my statements below and also by making suggestions?
1) In Access, you can create a form that gets it's values from a
multi-table query. In ASP you can create a web page that gets it's
values from a multi-table DataSet. This is the first step to complete
2a) In Access, at the bottom of the form you can show Navigation
buttons which allow you to select which record you are viewing...and
you can view one record at a time. The form's information is stored in
a RecordSet. Also, using the center mouse wheel you can quickly scroll
through records one-by-one within the recordset.
2b) In ASP, the Dataset (as apposed to the RecordSet in Access) can be
stored several different places from the Session to the ViewState among
others. (I'm still fully grasping all of the places to store this
information.) So, my question is this--the Dataset could be a large
table so I've been reading that this information shouldn't be stored in
the ViewState for performance reasons...however, if I want to make a
web page that acts just like the Access form with Nav buttons and mouse
scroll record selecting:
**how should I store DataSet information?
**what's the best way to program the Nav buttons? Is there a
pre-built web object that does this?
3) MS Access makes it easy to create Reports for printing by just linking them to queries and designing them in design view. What options (free??) are there to print good looking reports easily in the ASP.NET platform?
I'd love coding samples if you have them!