(Pawan Bangar) Microsoft designed ADO+ hand in hand with the .NET XML framework. Both are components of a single architecture. The unification of ADO+ with the XML framework happens in the dataset.
Author: SSWUG Research
XSD Restrictions/Facets
Restrictions are used to control acceptable values for XML elements or attributes. Restrictions on XML elements are called facets.
Sending Alerts via a custom SMTP procedure
(Chris Kempster) The following article shows, through code, how to enable SQL Agent alerts and using a simple stored procedure and DLL, send emails via an SMTP server rather than using SQL Mail. We will cover these items: SQL Agent Event Alerts SQL Agent Tokens Calling DLL’s via sp_OA method
Retrieving Identity or Autonumber Values into Datasets
You can set a column in a DataTable to be an auto-incrementing primary key in order to ensure a unique value for each row in the table. However, you may have multiple clients for your application, and each of those clients can be working with a separate instance of the DataTable. In this case, y
SQL Server Alerts
(Leo Peysakhovich) SQL Server alerts provide an elegant administrative tool to automatically notify pre-designated operators of server event occurrences. Organizations benefit quickly, as alerts make their DBAs more proactive to conditions requiring their attention. You can enable automation of
Stuck in the Senate
(Paul Ford) Last month we created an RDF representation of the United States Senate, and this month I was going to do the same for the House of Representatives. But after looking closely at my Senate RDF, and thinking about the sort of queries I wanted to make of it, I realized that it’s a mess. So
Managing Software Entropy with RefactorIT and Oracle JDeveloper 10g
(Dr. Robert J. Pefferly, Jr., Yuri Schimke, and Tanel Unt) The Second Law of Thermodynamics, also known as "entropy," dictates that the chaos of a system increases with time and decreases if and only if outside energy (work) is applied to order the system. In the world of programming, this law often
Ease Swing development with the TableModel Free framework
(Michael Abernethy) This article introduces the TableModel Free (TMF) framework which eliminates the need to use TableModels with Swing JTables. The TMF framework allows for more configurable JTables by moving all of table-specific data outside of the compiled code and into a configurable XML file.
Introduction to IBM Content Manager Portlet Version 2.0.1
(Jane Kohn) The primary focus of this article is on the DB2 Content Manager (DB2 CM) Portlet Version 2.0.1. The DB2 CM Portlet is a DB2 CM Web application that invokes the DB2 CM Java Web Component Toolkit (JWT) and DB2 CM Java Beans components to interface with a DB2 CM server. The portlet implemen
Data Validation Using .NET and External Metadata
(Jonathan Schafer) Using .NET reflection and external metadata makes it easy to add data validation to your objects. Nearly every application that collects data, whether from a Windows- or Web-based form or from a file, needs to validate that the data is in the correct format.