(Scott Mitchell) The ASP.NET 2.0 data source controls provide a declarative means for accessing and working with data. Simply set a few properties of the data source control, bind it to a data Web control, and, voila, data is being retrieved and displayed without having written a single line of code
Other News
Dynamic XML document construction with the PHP DOM
(Melonfire) When working with XML-based applications, developers often find themselves facing the requirement to generate XML-encoded data structures on the fly. Examples of this include an XML order template based on user input in a Web form, or an XML representation of a server request or client r
MySQL Administration Via ColdFusion
(Raymond Camden) A user asked me if it was possible to backup and restore a MySQL database from ColdFusion.
Designing High Performance Stored Procedures
(Gene Pinski) Managing large amounts of data is always a challenge. Several major database vendors claim that their database engines are ready for terabytes of data, which is true to a certain extent. However, when those terabytes are not static data, but live information that people update constant
Creating a Custom ExpressionBuilder in ASP.NET 2.0
(Bilal Haidar) A new feature in ASP.NET 2.0 has been introduced, the ExpressionBuilder. The ExpressionBuilder allows declarative binding for control properties for data that is coming either from the ConnectionStrings and AppSettings section of the web configuration file or from the web application
Data Bound Applications with ADO.NET and Custom Objects
(John Papa) The Windows Forms binding controls are vastly improved descendents of the data binding controls of the past. They get you going quickly and handle the redundant tasks associated with setting up forms, and you can customize and extend their behavior significantly. Data can travel in a var
XForms tip: Using accesskeys for greater accessibility
(Tyler Anderson) XForms, the Web 2.0 of forms, could not possibly be Web 2.0 without providing accessibility features. I’m sure you’ve used the Alt key before, or accidentally typed it while typing up a document. The Alt key focuses in on the File tab at the top of most applications. XForms has simi
SQL Server 2005 Integration Services – Part 41 – XML Task
(Marcin Policht) The importance of XML-based technologies is steadily increasing and this trend is reflected by a variety of new features in this category introduced in SQL Server 2005 Integration Services. One of the most prominent ones is the XML Control Flow task, which provides assistance with p
How To Compare Two Files with VB.NET and VB2005
(Mike McIntyre) This article and source code demonstrate how to use Visual Basic 2005 to compare two files to determine if they are equal. This comparison looks at file paths, file lengths, and file contents. NOTE: While source code for VB.NET is not provided, the CompareFiles function included in t
Calculate columns and averages with SQL Server’s HAVING clause
(Arthur Fuller) As an instructor of database language and usage, I find some topics particularly difficult to explain. One of those subjects is SQL Server’s HAVING clause. In this tip, I offer a brief overview of the clause and then provide code examples, which I think best convey the proper usage o