You often need to display a result set one page at a time while maintaining ease-of-navigation between those pages, particularly when you’re working with a Web site. Although it is possible to page through result sets using the ADO Recordset object, that solution is not scalable.To solve the
Other News
Manipulate Schema Information
by Dino Esposito – ADO.NET doesn’t provide classes for schema manipulation, although Microsoft plans to build an all-encompassing .NET object model for the data source’s Data Definition Language (DDL). In this column, I’ll examine the three options you have today to manipulate a table’s schema progr
Using Metadata
The simplest definition I can find for metadata is simply "data about data". SQL Server has a number of different functions that you can use to query your database structure. This articles discusses the Information Schema views and functions such as ObjectProperty and ColumnProperty.
Oracle’s ‘Mr. Linux’
When Larry Ellison asked him to design a Linux-based Internet appliance, Wim Coekaerts reported back with a plan a couple of weeks later–and won himself a new task.
Generate Web Output in Multiple Formats and Languages with StrutsCX
by Bernhard Woehrlin – StrutsCX overcomes the limitations of the Struts Framework by enabling you to utilize XML, XSLT, and XPath technologies instead of its standard JavaServer Pages.
Defining Web Services
The label “web services” is incredibly generic. Like any promising and loosely defined technology trend, the concepts it describes will be subject to a great deal of speculation and bandwagoneering in the months to come. With the aim of providing a reference benchmark—and of separating posturing fro
An XML Hero Reconsiders?
by Kendall Grant Clark – In a recent weblog entry, one which has been picked up by Slashdot, Bray asks whether XML has become too hard for programmers. Faced with writing code “to process arbitrary incoming XML”, Bray confesses that the experience was “irritating, time-consuming, and error-prone” —
App servers key to integration, Oracle exec says
By Paul Krill – Application servers utilizing Web services and Java will enable integration of multiple information systems for e-business, according to an Oracle official.
Adding Columns to Replicated Tables
We often add columns to replicated tables. How can we add a column without having to reinitialize the entire publication?
Eyes Slammed Open
The havoc wreaked by the SQL Slammer, or Sapphire, worm starkly illustrated the vulnerability of Internet-accessible database servers. Fortunately, the worm didn’t compromise any stored data. However, it exploited a flaw in Microsoft’s SQL Server to propagate itself and consequently (according to pu