Data Pager Control [.NET Framework 3.5] in Visual Studio 2008

When query results exceed the display area then you resort to scrolling and wish you had some way to limit the number of results displayed and comfortable to view without scrolling. Paging functionality which provides an answer to this is therefore a much desired feature. The Data Pager Control in Visual Studio 2008 provides this functionality when you create an ASP.NET web form under .NET Framework 3.5. It can be configured automatically using the GUI, or it can be installed manually after installing the ListView. In this article both of them are described. While the number of items displayed in a list can be declaratively coded, it is possible to set it at page load time as well.

Krishnaswamy, Jayaram. Packt (2008). Articles>Web Design>Databases

Migrating from MS SQL Server 2008 to EnterpriseDB

With many database vendor products in the market and data intensive applications using them, it is often required to port the application to use the data or, migrate the data so that the application can use it. Migration of data is therefore one of the realities of the IT Industry. Some of the author's previous articles on migration can be found at the link.

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>SQL

Programmatically Creating SSRS Report in Microsoft SQL Server 2008

The process of programmatically creating the SQL Server Reporting Services (SSRS) tabular report is described. You will be creating a very simple report using the provided code. The approach is to introduce the programming by creating the three parts of a report: connection, dataset, and layout. Excerpt from the book, "Learning SQL Server 2008 Reporting Services.'

Krishnaswamy, Jayaram. Packt (2009). Articles>Information Design>Databases>Reports

jQuery Embedded in Dojo Accordion Panes

We will experiment embedding jQuery in DOJO 123's Accordion widget and try to identify if there exists any cross-code interactions. The code is also tested for cross-browser suitability.

Krishnaswamy, Jayaram. Packt (2009). Design>Web Design>DHTML>JavaScript

Transferring a Table in a MS Access 2003 Database to PostGres Using SQL Server Integration Services  

Describes the use of Microsoft SQL Server Integration Services to transfer a table from MS Access 2003 to Postgres on EnterpriseDB. Some of the problems are discussed.

Krishnaswamy, Jayaram. SSWUG (2009). Articles>Information Design>Databases>Microsoft Access