NEW LISTINGS  HOT LISTINGS  TOP RATED  EDITOR PICK  ADD A LISTING  UPDATE A LISTING  GET RATED  UPGRADE A LISTING
  HOME     MY ACCOUNT     POWER SEARCH     REGISTER     MEMBER LIST     SUGGEST CATEGORY  

Average Visitor Rating: 0.00 (out of 5)
Number of ratings: 0 Votes

Visitor Rating

Wielding the Power of the DataView
2538 Wielding the Power of the DataView http://www.asp101.com/articles/stuart/dataview/default.asp It?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-related Oct 10, 2006

Write a Review   Add to My Favorite   Refer it to Friend   Report Broken Link  

Bookmark Wielding the Power of the DataView:


Other links at ASP > Tips and Tutorials > Database-related
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.
Category:

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
Category:

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.
Category:

You can test the demo for dynamically dependent dropdown lists here:
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
Category:

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.
Category:




Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175

Join Mailing List
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.



Top 10
Directory Statistics

Links: 19871
Categories: 1275
Registered Users: 766
Mailing List Subscribers: 2047
Unique Outgoing Hits: 231131

Pagerank Statistics
PR 10
1 site(s)
PR 9
14 site(s)
PR 8
43 site(s)
PR 7
233 site(s)
PR 6
689 site(s)
PR 5
1775 site(s)

PHP News