RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

SQL Azure

Developer

General DBA

ASP.NET / ADO.NET

SQL Azure

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...

SQL Server Destination remote server error

Setting Up Data And Log Files For SQL Server

Will Check Constraints Improve Database Performance?

SQL Server ASP.NET / ADO.NET Articles

ASP.NET 4.0 - New Features
ASP.NET 4.0 is just around corner - discover the new features and enhancements.

50 Tips to Boost Performance of an ASP.NET Application - Part 2
50 Best Practices to ensure you maximize the performance and scalability of your application. Part 2 - Best Practices 26-50

50 Tips to Boost Performance of an ASP.NET Application - Part 1
50 Best Practices to ensure you maximize the performance and scalability of your application. Part 1 - Best Practices 1-25

Implementing a Generic Data Access Layer in ADO.NET Part 1
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 3
The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.

Implementing a Generic Data Access Layer in ADO.NET Part 2
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.

ASP.NET Security [Part I]
An introduction to the ASP.NET methods for Authenticating and Authorizing users

Understanding the Page Life Cycle in ASP.NET
The Page Life Cycle is the series of events fired when a web page is requested. Undertstanding of the Life Cycle is key to developing ASP.NET applications.

Working with Transactions in ADO.NET
Transaction processing is an indispensible part of ADO.NET, a transaction guarantees that a block of statements will either be executed in its entirety or rolled back.

Caching in ASP.NET (Part II)
The second article in the caching series looks at using the Cache API.

Caching in ASP.NET (Part I)
Caching is probably the single quickest and most efficient method of boosting performance of ASP.NET applications. The first article in this series looks at Page Output Caching and Partial Page Caching.

Working with Exceptions in ADO.NET
The new version of ADO.NET includes powerful support for working with exceptions efficiently. This article throws light on how to handle exceptions efficiently when working with ADO.NET and highlights the best practices that can be followed in this context.

DataTable Enhancements in ADO.NET 2.0
ADO.NET 2.0 has added many new powerful features to the DataTable class including the ability to load a DataReader instance into a DataTable instance by using the Load method of the DataTable class, the DataTableReader, built-in serialization support.

DataSets and XML – A Perfect Combination
The disconnected data access model of ADO.NET is centered on DataSets. DataSets are the core of ADO.NET architecture and represent an in memory representation of the database. Using XML, we can use the DataSet class in ADO.NET to perform the CRUD (Create, Read, Update and Delete) operations without an underlying database to store the data.

New Features in ADO.NET 2.0
The introduction of ADO.NET has come as a boon to the development community with excellent features such as, seamless support for XML and support for connection pooling, to name a few. This article introduces the reader to newly added features to ADO.NET 2.0 and discusses how they can improve the performance, scalability and maintainability of applications.

Setting Up ASP.NET 2.0 Application Services
ASP.NET 2.0 lets developers add data to a Web site in a manner that is almost identical to how they would normally add another server control with the help of the control-based approach to data access.