Re: Question about Datasets and ASP.NET

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This is probably a good example of where you want to compile your business
layer in a separate dll, and have that support both the thin and thick
clients. Ideally your UI layers shouldn't care at all about the details of
data access - that means they won't see data sets.

Also, you may want to think about moving away from data binding - raw SQL,
even if it's automatically generated for you, does not belong in compiled
code. Any data access details that you do have in code, such as column name
mapping to particualr object fields, should be kept non-declarative (i.e.
attributes).

Paul

"Ryan" <Tyveil@xxxxxxxxxxxxxxxxx> wrote in message
news:%23toFE6slGHA.2180@xxxxxxxxxxxxxxxxxxxxxxx
I'm in the process of learning more about building my ASP.NET website to
use my SQL datastore and am a bit confused about how ADO.NET works with
ASP.NET. This Microsoft article implies that using ADO.NET with ASP.NET
applications is the way of the past because newer controls allow you to do
all your data binding declaratively.
http://msdn2.microsoft.com/en-us/library/ms178359(d=ide).aspx

However, I haven't been able to get my application to work just using
these controls. There is a lot of complex dataprocessing that needs to be
done with code. For example, once a user completes filling out a resume
form I need to create a new item in the resume table, using the new
resumeid I then need to add rows to multiple tables (lets just say these
resume forms are pretty complex, the questions are created dynamically by
backend users and each form is related to positions they're applying for,
the dynamic question table, etc). So anyways, to cut a long story short,
I'm thinking using ADO.NET Datasets and Datatables is the way to go. I've
done pretty well using these features with my backend application (a
Windows project using Windows forms - not ASP.NET), but for the ASP.NET
website user end I'm missing the Data Sources window and the easy
drag-drop capabilities of creating and managing Datasets (including the
Dataset designer). Is Microsoft trying to discourage me from using
Datasets with ASP.NET? What should I be using to code the database
queries? SQLdatasource is nice but I'm finding it hard to use
programmatically. It works nice to bind to controls but that seems to be
the only way it is usable.

Thanks for any advice.
Ryan



.

Relevant Pages

  • Re: Layering in Windows Forms
    ... Find great Windows Forms articles in Windows Forms Tips and Tricks ... objects collection in that layer. ... I was thinking of using the transparent COntrols for each layer -- what ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: How Can I disable autosaving when quitting Access?
    ... The compile option is disabled, I thought you could only compile if you're ... Doug Steele, Microsoft Access MVP ... that some of the controls are unboud such as the date pickers is because ... There are a few other anomalies of the sort (iCheck ...
    (microsoft.public.access.formscoding)
  • Re: Howto structure a GUI?
    ... Create a base form or set of forms, with common set of controls or properties, which has a wide usage and needn't be repeated manually on every form. ... Don't Mix GUI and Data Layer at any point, again create the data Layer as a separate dll, where you can have a class for each type data Storage in memory structure and play around. ... It has refernce to UIP layer dll. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Access control on a page from inside an external class
    ... pass the controls to this class in the UI and then change ... code in Data access layer then to be able to grab the UI controls of the ... ContractTypeTextBox - A textbox that will contain the type of contract ... Private string strName; ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Is CMUCL insane? P.S. Me vs. CLM (Common Lisp Music)
    ... Or to build Windows without a working version of Windows. ... why are you trying to compile CMUCL?" ... let's assume I use Linux and not an emulator here... ...
    (comp.lang.lisp)