Data Pager Control [.NET Framework 3.5] in VS2008

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.

 

Want to know how it is done?

Read the following article at Packt Site...

Data Pager in VS 2008

Creating a Cube in SSAS 2008

As noted in Part 1, OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the buried intelligence compared to the structured querying where the overhead of 'Joins' makes it inefficient. Taking the example of a 'Sales' Cube having everything related to sales we can identify the dimensions as the Sales Outlet, The Customers , The Products and the Time period over which sales are being audited or looked into, etc. We also notice that there are certain measures that we are interested in related to these 'dimensions' , like 'Store Sales', 'Cost of Products, 'number of units sold' etc. The Analysis Services analyzes these intricate relationship that exist in a cube. In this part we will see the process of creating a Cube in VS 2008.

Read on ---> Part 2

Cube with SSAS using VS2008

Integration Services 2008 bug_Bug001

The picture shows it all. The number of rows selected by the Conditional Split looks good [14601+4511=19112]. But the progress tab shows it has started and one of the component is still yellow. The program hangs. This appears to be a real bug and it is repeatable. I use an evaluaion copy of VS Studio 2008 Professional Edition [trial software], the Feb 2008 CTP of SQL Server 2008 and using the Adventure Works database and a ADO.NET source for this example.

At first I thought that there were too many rows to fetch and reduced the number of rows fetched to be small to weed this bug out for observation.

Multi-version support in VS 2008

Multi-version targetting is a new feature in VS 2008 that makes it easier to target applications to different NET Framework versions from a single IDE. Of course this does not include 1.1. You choose the version you want to target while creating a project. Notice the top right drop-down in the next figure which allows you to choose the version. The IDE and all related code will be applicable to that version. In this new project window targeting the 2.0 version you see the templates for VS projects applicable to this version.



When you choose 3.0 the window changes as shown in the next figure.



You see lot more templates and the WPF and WCF related templates.
All aspects of the IDE to support the chosen version will be active.

This one is for the 'Data' in version 2.0



This one is for Data in version 3.5



For developers this makes it easier to handle user complaints about version problems.
VS2008 Professional Edition with Visual Basic as the chosen language were used.

Visual Studio 2008 Installation could be taxing

Trying to install VS 2008 did not succeed as it failed in the first step of installing NET Framwork 3.5.



Looking at my Add/Remove progams I had the following listed which I assumed had direct bearing on VS 2008 Installation:



MSFT .NET Framework 1.1 -->35.97 MB

MSFT .NET Framework 2.0 SDK ENU-->418 MB

MSFT .NET Framework 2.0 SP1 -->185MB

MSFT .NET Framework 3.0 ---------->58 MB

MSFT FXCop--->6.99MB



My /Windows/MSFT.net/Framework folder had the following:

v1.0.3705

v1.1.1.4322

v2.0.50727

v3.0

v3.5.20404

-------------

I removed the 2.0 SDK ENU and 2.0 SP1

I reinstalled .NET Framework 2.0

Tried to install NET Framework 3.5 and failed

-----------------------

Tried removing the existing .NET 3.0 with cleanup tool

I had to run the cleanup tool twice to clean the Net 3.0 but looks like NET 2.0 installed in the previous iteration had also disappeared.

I confirmed using the NET Verifier tool.

I made sure that the Media Center App was still working as well as SQL 2008

--------------------

I tried to install NET Framework 3.5 [dotnetfx35.exe, Version:3.5.21022.08].

Voila! It succeeded.

Now I see the following new ones in my add/remove programs:

MSFT .NET Framework 2.0 SP1 185 MB

MSFT .NET Framework 3.0 SP1 184 MB

MSFT .NET Framework 3.5 29.1MB

--------------------------------

After this VS 2008 installed without any problem.
Log files are great if only I could use them effectively or I find a sympathetic MVP.