Wednesday, September 30, 2009

MSXML 4.0 Service Pack 3 (Microsoft XML Core Services)

MSXML 4.0 Service Pack 3 (SP3) is a complete replacement of MSXML 4.0, MSXML 4.0 Service Pack 1 (SP1) and MSXML 4.0 Service Pack 2 (SP2). MSXML 4.0 SP3 provides a number of security and reliability bug fixes. Support will end for MSXML 4.0 SP2 in 4/13/2010. For more information about MSXML 4.0 SP3 see the release notes.

Tuesday, September 29, 2009

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack

When I tried Execute the Following Code,


catch (Exception Ex)

I got the following Error

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.

I removed the try ... catch ... block, then I tried only with


then it works fine. finally I came to know that Response.Redirect wont works with in
try ... catch ... block.

Hope it helps you too.

Find the Filename Of Current Page in ASP.NET

Here is an another piece of code to findout the filename of current page that is being viewed.

using System;
using System.IO;


How to Get Current Page URL thru ASP.NET?

The following Piece of code helps to get the current URL in Asp.Net.

using System;

Uri MyUrl = Request.Url;

"URL: " + MyUrl.AbsoluteUri + "<br>");

Hope this code will be helpful to beginners

Service Pack 6 for Visual Basic 6.0, Visual C++ 6.0 with Visual Source Safe 6.0d

Service Pack 6 for Visual Basic 6.0, Visual C++ 6.0 with Visual Source Safe 6.0d provides the latest updates to these products. It is recommended for all users of Visual Basic 6.0, Visual C++ 6.0 and Visual Source Safe 6.0.



The DataAdapter is a ADO.NET class, it provides disconnected data access, also acting as a middleman to provide all kind of interaction between the database and a DataSet.

The DataAdapter is used either to fill a DataTable or DataSet with data from the database by it's Fill method. After the memory-resident data has been manipulated, the DataAdapter can commit the changes to the database by calling the Update method.

The DataAdapter provides four properties that represent database commands:
  • SelectCommand
  • InsertCommand
  • DeleteCommand
  • UpdateCommand

Data Provider

The Data Provider is a one of the major components of ADO.NET architecture, it is responsible for providing and maintaining the connection to the database. A DataProvider is a collection of related components that work together to provide data in an efficient manner.

Currently, the following data providers are available in .NET Framework,

  • SQL Server
  • ODBC
  • Oracle

Each DataProvider consists of the following component classes:

The Connection object which provides a connection to the database
The Command object which is used to execute a command
The DataReader object which provides a forward-only, read only, connected recordset
The DataAdapter object which populates a disconnected DataSet with data and performs update

What is DataSet?

DataSet is an ADO.NET object, it helps to store the data in memory for program use. It is a disconnected in-memory cache. We can do the all the database process with dataset like update, delete and adding new record. After finished all the operation with dataset, changes can be made back with database for updating.

ADO.NET Data Architecture

ADO.Net is a Data Access Technology; it is classified into 2 major components

1. DataSet
2. Data Provider

Have a look at the diagram given, which is an Architecture of Ado.NET

Thursday, September 24, 2009

What is the difference between “Order By” And “Clustered Index”?

“Order By” clause Sorts the query results of data up to 8060 bytes, it may either single or multiple columns.

“Clustered Index” physically sorts the data while performing DML operations like Inserting and Updating.

What is Index in SQL?

Indexes in DB are very similar to indexes in the books. It helps to search the data very quickly without scanning whole data in a table. Index can be defined on either single column or multiple columns of a table. index will arrange the data in specific manner . Index is an data structure that improves the operation of a table.

There are many classification of index in SQL, the following Indexes are most often used by everyone, which are as Clustered, Non-Clustered and Unique Index.


A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemented as a B-tree index structure that supports fast retrieval of the rows, based on their clustered index key values.

Every table can have only one clustered index.


A Nonclustered index can be defined on a table or view with a clustered index or on a heap. Each index row in the Nonclustered index contains the Nonclustered key value and a row locator. This locator points to the data row in the clustered index or heap having the key value. The rows in the index are stored in the order of the index key values, but the data rows are not guaranteed to be in any particular order unless a clustered index is created on the table.

Every table can have maximum of 249 Nonclustered index.


A unique index ensures that the index key contains no duplicate values and therefore every row in the table or view is in some way unique.

Both clustered and nonclustered indexes can be unique.

Monday, September 21, 2009

Microsoft® SQL Server® StreamInsight CTP2

Microsoft® SQL Server® StreamInsight is a platform for the continuous and incremental processing of unending sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for timely and relevant processing of data.

StreamInsight allows software developers to create innovative solutions in the domain of Complex Event Processing that satisfy these needs. It allows to monitor, mine, and develop insights from continuous unbounded data streams and correlate constantly changing events with rich payloads in near real time. Industry specific solution developers (ISVs) and developers of custom applications have the opportunity to innovate on and utilize proven, flexible, and familiar Microsoft technology and rely on existing development skills when using the StreamInsight platform.

Some of the key feature areas are:
  • Derive meaningful and relevant information from data/events streams through complex patterns. These patterns can be defined using a declarative query paradigm based on well-defined streaming semantics with LINQ as query language.

  • For the development of applications, adapters, and analytics, the user can rely on well-established and powerful development frameworks and tools such as .NET, LINQ, and Microsoft Visual Studio.

  • The platform integrates with various data sources and sinks through input and output adapters. The framework to build domain-specific adapters utilizes a .NET API to make adoption of the platform easy. Independence between adapters and queries facilitates seamless integration of real-time and historical analysis.

  • The platform architecture supports a variety of deployment options, from scenarios with a low-footprint embedded option to high-end server deployments.

  • A rich set of manageability features such as a management interface, a diagnostic interface and a debugging tool are provided as part of the platform.
The Microsoft® SQL Server® StreamInsight CTP2 has two different methods to complete the installation process:
  • Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.

  • Un-attend Installation – this is a DOS command line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.

  • Here is the copy of the Microsoft® SQL Server® StreamInsight license terms for your review.
Download StreamInsight

Microsoft SQL Server Accelerator for BI

The Microsoft SQL Server™ Accelerator for Business Intelligence 1.2 has been removed to avoid customer confusion about support for this component. Microsoft does not provide any support for this solution accelerator and has no plans to release future versions. Most of the functionality of the accellerator is available in Microsoft SQL Server™ 2005 and later versions. For support information,

please refer to the Microsoft Product Lifecycle.

Friday, September 18, 2009

Microsoft Visual Basic Power Packs 10.0

Microsoft Visual Basic Power Packs 10.0 has same feature as Power Packs 3.0, but contains some bug fixes.

The DataRepeater control allows you to display rows of data in a scrollable container providing more flexibility and customization than standard grid controls.

The Line and Shape controls are a set of three controls that enable you to draw lines, ovals, and rectangles on forms and containers at design time making it much easier to enhance the look of your user interface. These shape controls also provide events such as click and double-click allowing developers to respond and interact with end users.

The Printer Compatibility Library allows projects that used the Printer and Printers Collection in Visual Basic 6.0 to be upgraded without having to re-write your printing logic. By simply adding a reference to the library, declaring a Printer and making a few minor syntax changes, your project will be able to print using the Printers collection and Printer object as it did in Visual Basic 6.0. This version adds a new Write method to the Printer object which allows you to print text without a forced carriage return similar to the semicolon syntax used by Print method in Visual Basic 6.0.

The PrintForm component is designed to bring back the ability to easily print a Windows Form. With this new PrintForm component you can layout the Windows Form exactly as you want it and allow your users to print the form as a quick report.


Thursday, September 3, 2009

Microsoft SharePoint Administration Toolkit v4.0 x64

The Microsoft SharePoint Administration Toolkit contains functionality to help manage Office SharePoint Server 2007 and Windows SharePoint Services version 3.0. This toolkit contains the ability to diagnose performance issues and perform bulk operations on site collections.

New Features:
  • SharePoint Diagnostics tool (updated)

  • Permissions Reporting tool, which includes the UnlockFGPReport Stsadm operation

  • UpdateQuota Stsadm operation

  • SharePoint-related Security Configration Wizard manifests
Existing Features:
  • User Profile Replication Engine

  • Batch Site Manager

  • UpdateAlert Stsadm operation
For more information about the SharePoint Administration Toolkit, see following documentation on TechNet:
Download Microsoft SharePoint Administration Toolkit v4.0 x64

Tuesday, September 1, 2009

ADO.NET Data Services v1.5 CTP2

This CTP is a preview of the set of features we are considering shipping with the next version of ADO.NET Data Services. This CTP targets the Microsoft .NET Framework 3.5 SP1 and extends the functionality we provided in v1.0 of ADO.NET Data Services by providing additional features. This CTP builds on and makes updates to the functionality provided in ADO.NET Data Services v1.5 CTP1.

As this is a CTP release, we recommend that you do not install this release on your primary development computer. Also, be aware that the features that ultimately ship with the final release of v1.5 may be different than the features included in this CTP.

The features included in this CTP are:
  • Row count
  • Feed customization (aka "web-friendly feeds")
  • Data binding for WPF and Silverlight 3
  • Enhanced blob support
  • Server-driven paging
  • Projection Support (via the $select query option)
  • A new "Data Service Provider" interface for custom providers
  • Various bug fixes to V1.0 features
Install Notes:

This release is separate from the Project Codename "Astoria Offline", Alpha Preview released on March 5, 2009. Installing this CTP on the same system as the Offline release will cause a conflict and is not supported. We strongly recommend that you do not install them together.

Installing this CTP on the same system as the ADO.NET Data Services CTP1 is not supported. You must uninstall CTP1 before installing CTP2.

It is possible to use this CTP with the Windows 7; however, design time support integrated with Microsoft Visual Studio 2008 SP1 or Microsoft Visual Web Developer 2008 Express Edition will not be available on Windows 7. Using DataSvcUtil.exe for client-side code generation will also not be available on Windows 7. If you use the installer named ‘ADONETDataServices_v15_CTP2.exe’ you will receive a warning when you use the setup on a system with Windows 7 installed indicating a file is locked but the setup will not fail and the design-time components will not be installed. A separate installer named ‘ADONETDataServices_v15_CTP2_RuntimeOnly.exe’ is provided that installs only the runtime components and does not present the error message during install.