(Irina Medvinskaya) Data access is the basis of any application. In this article, I will show you how to access SQL Server-based data using C# and ADO.NET, as well as how to display the data in a data-bound grid control. I use a simple C# application as an example.
Author: SSWUG Research
What is the DUAL table costing you?
(Jeffrey R. McCormick) The DUAL table is one of the first things we learn as Oracle professionals. It is created by default as a single row table, understood by the optimizer and available to everyone for selection. We typically use this table to select the name of the current user, ping the databas
Generating RSS with XSLT and Amazon ECS
(Craig Noeldner and Brian Swan) One choice you have to make when working with web services is how you will process the web service response. You could build the processing into a rich client, but that would likely require some type of installation for others to use your application. You could proces
Using the TreeView Control and a DataList to Create an Online Image Gallery
(Scott Mitchell) ASP.NET version 2.0 includes a wide array of Web controls not found in previous versions. One such control is the TreeView, which is ideal for displaying hierarchical data. The TreeView control can be bound to a hierarchical data source such as the XmlDataSource or SiteMapDataSource
Retrieve Oracle BLOB and save as a JPG using ASP.NET 2.0
(schola) The following code snippet shows how to retrieve an Oracle BLOB column data and save it as a JPEG file. Before using this code, you must create an OracleCommand object with a valid Oracle connection. To see how to create an OracleCommand and OracleConnection, see ADO.NET section of this sit
Open Source Apps Broadening the Human Resources World
(Curt Finch) Software is ultimately composed of congealed ideas, so ideas are very important in the minds of software developers. The key to market power in the software industry lies in the minds of developers. Fashion plays a role too; some ideas are fashionable and some are not. The idea, or phil
FIX: The Replication Merge Agent job may fail after you install SQL Server 2000 Service Pack 4
Consider the following scenario. • You install Microsoft SQL Server 2000 merge replication. • You install SQL Server 2000 Service Pack 4 (SP4) on the computer.
Secure Search Returns Best Results
(Ron Hardman) If your company is like most, data—some meant to be shared and some not—is stored in multiple locations. Those locations may include –File servers –E-mail messages and attachments –ERP modules –An intranet –Configuration management repositories –Multiple databases
IBM WebSphere Developer Technical Journal: Using DB2 Version 9 pureXML with WebSphere ESB
(Dinesh G Shetty, Srinandan K Sridhar and Andre Tost)IBM recently shipped a new version of its flagship database product, DB2 Version 9. With this release comes first class support for XML documents, including the ability to store and query XML documents without the need to map them into a relationa
Process Data With in XML File
(Arshad Raheed) This article illustrates how to process data within XML File. For this article I have developed a small application that allows users to: –Read data from XML file and display it in the ASP.NET DataGrid Control. –Write data in XML File. –Update data in XML File.