(Jack Xia, Anthony Corrente and Savio Pereira) DB2 Cluster running on MSCS is popular, but setting up MSCS requires expensive hardware, like shared disks, making it difficult to setup for test and education purposes. (pdf)
Author: SSWUG Research
Paging in DataGrid
(Sanjay David) This is application logic this code demonstrates the access to the access Database. The result sets are stored in the DataSet and it is assigned to the Datagrid for Datasource.
Pop Rivett and the Suspect Database
(Pop Rivett) Blake Savage gazed in horror at the string of errors in the database activity log of his communications module. It was always at the worst possible moment that SQL Server grenaded itself and produced a corrupt database. Without the database data, all off-planet communications were impos
XForms tip: Dynamically create controls with the repeat, select1, and itemset elements
(Tyler Anderson) Forms can have lists of data, which are difficult to display using regular HTML forms. The select1 and itemset elements have a lot of flexibility and are very similar to the select or option tags in HTML. The repeat element really shows its power here in that you can have a list of
Msql — A Little Wrapper Goes a Long Way
(Linchi Shea) Have you ever run into a situation where you’d like to search many of your SQL Server instances to look for a specific piece of information? Ideally, you should maintain an inventory database of all your SQL Server instances so that all you need to do is query that database. In case yo
How To Browse Folders with FolderBrowserDialog and Visual Basic 2005
(Mike McIntyre) This article and source code demonstrate how to use the .NET Windows Forms FolderBrowserDialog class and Visual Basic 2005 to provide a way to prompt the user to browse, create, and eventually select a folder. Use this class when you only want to allow the user to select folders, not
Retrieving Data from a SQL Server 2005 Database Using the SQL DataSource Control in ASP.NET 2.0
(Jayaram Krishnaswamy) SQL Data source control together with other data controls hide most of the hardwiring needed for connecting to and retrieving data from the server by presenting simplified higher level features. Sql Data Source Control together with the GridView data aware control makes data a
Concurrent Model in ADO.NET
(Michael Milonov) The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet, and DataAdapter. DataReader is able only to read data and can’t work as data so
Troubleshooting .NET Applications: Knowing Which Tools to Use and When
Learn how to avoid application failures and performance degradations that threaten core business systems and their users worldwide. Analysts agree that at least 80 percent of all software released into production will fail due to quality issues; and 70-80 percent of the cost of ownership of such bus
Is XML 2.0 Under Development?
(Micah Dubinko) XML, one has to admit, has been pretty successful. Despite having a sufficient quantity of annoyances to merit a dedicated column on these pages, XML has powered applications almost anywhere–anywhere except the web, if recent murmurings are an indication.