2538Wielding the Power of the DataViewhttp://www.asp101.com/articles/stuart/dataview/default.aspIt?s hard to imagine what the creators of ADO.NET were thinking as they were designing it.? It has been challenge enough just understanding and mastering all of the many objects and their capabilities.? Just think, to physically access a column of data you have to now maneuver through at least five objects instead of two in ADO.?
As part of my effort to learn ADO.NET, I decided to first determine how to reproduce the basic functionality that I had in ADO, especially with the Recordset.? That is where I discovered the new and many uses of the DataView class (although I prefer the term object to class).?ASP > Tips and Tutorials > Database-relatedOct 10, 2006
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo.
Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header. The problem with coming up with a solution such as requested, is to find out how to do a page break after a certain number of rows
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
In this example we have used our old database. There was a rating column holding the votes of our articles. We were using this simple script to check sum of ratings.
The following code can be used to compact MS Access(MDB) database using ASP code. Compacting the database is requuired to reduce the growing MDB file size. This can be achieved by using DAO or JRO.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.