Alan, Yes, ASP.NET 2.0 has some very useful new stuff added to it, including the Membership and User Security classes and controls that you mentioned. The GridView and DetailsView controls that you are using for the list and details are also very cool, especially when combined with the new ObjectDataSource object working against Business Object classes OR the SQLDataSource working directly against a database.
I'm doing a project right now in ASP.NET 2.0 that is using business object classes that call into a Data Access layer of classes, using a "provider" pattern with abstract data access methods and a VFP-specific concrete set of classes that use the VFP OLE DB provider to query and update tables also used by a VFP7 Web Connection app. If in the future the data gets moved to a different backend database, we just code a new concrete provider set of classes and the switch is pretty much painless. The ObjectDataSource does most of the hard work of data-binding, but it and the GridView/DetailsView classes all provide lots of Event hooks that allow you to customize the default behavior if needed. I have been very impressed with the new features in 2.0 that show the impact of YAG and other VFP people on the direction .NET is taking with data access (For example, YAG mentioned recently that Gene Goldhammer, who did much of the design work on VFP's CursorAdapter, also worked on the early concepts that became the .NET ObjectDataSource). Anyone working with .NET and wanting to use a multi-tier architecture (at least logically) should look closely at the ObjectDataSource in combination with the GridView, DetailsView and FormView. David Stevenson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: Tuesday, July 18, 2006 5:52 AM To: [EMAIL PROTECTED] Subject: [NF] ASP.Net 2.0 - I'm impressed. On Tue, 18 Jul 2006 10:28:35 +0100, "Alan Bourke" <[EMAIL PROTECTED]> said: > I've just created a simple site which: > > Has complete login functionality with SQL Server storing the users and > passwords. > You can change your password or have an auto-generated one emailed to > you if you forget it. > Based on your user you can have access an enquiry page. > On that page you can partial search on a name and have a sortable, paged > grid of SQL 'LIKE' results. > Clicking on a grid row highlights the row and displays the address > details below. > > Had to set up some permissions on SQL Server and run a supplied script > to create the users database, but all the above was achieved by > drag-and-drop controls and setting some properties in Visual Web > Developer - I have written no code behind anything as of yet. > > You could do the same with the free-as-in-beer express editions of SQL > Server and Web Developer. > > > -- > Alan Bourke > [EMAIL PROTECTED] > > -- > http://www.fastmail.fm - One of many happy users: > http://www.fastmail.fm/docs/quotes.html > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

