Encrypting Web.config sections in ASP.NET 2.0

Now you can actually encrypt any section of your Web.config file on-the-fly and programatically. If you have full access to your Web server, you can encrypt your connection strings with this single command-line located in the in the %windows%\Microsoft.NET\Framework\versionNumber folder. Read more...

Introducing ASP.NET 2.0 with Visual Studio 2005 Plus Grid View

The following article introduces you to designing and working with an SQL Server 2005 database using the Visual Studio 2005 Integrated Development Environment. You will also learn how to work with the “Grid View” control. Read more...

Retrieving SQL Server 2005 Database Info Using SMO: Basics

The following article focuses on retrieving SQL Server 2005 information using SMO together with Visual Basic 2005 and Visual Studio 2005. SQL Distributed Management Objects (SQL-DMO) is a collection of objects encapsulating Microsoft® SQL Server™'s database and replication management. SQL-DMO is a dual interface COM, in-process server implemented as a dynamic-link library (DLL). SQL-DMO encapsulates SQL Server components, presenting the attributes of the component piece to you as the properties of an object instance. We can alter the properties of the instance, or use object methods to automate SQL Server administration, including replication. Read more...

Enterprise Library for .NET Framework 2.0 Now Available!

The long-awaited update to Enterprise Library for .NET Framework 2.0 is now available - the official release is branded January 2006. This release of Enterprise Library includes six application blocks (Caching, Cryptography, Data Access, Exception Handling, Logging and Security), and provides similar functionality to the previous releases for the .NET Framework 1.1; however, Enterprise Library has been redesigned to use the new capabilities of the .NET Framework 2.0. Download the library by following this link...

SQL Server 2005 T-SQL New Features: OUTPUT

SQL Server 2005 offers a much more convenient way of determining the system-generated values by attacking the problem at the source, within the INSERT statement itself. By adding an OUTPUT clause to an INSERT statement, it is easy to determine all values created during an INSERT; not just IDENTITY values, but also, values created by function calls such as GETDATE() or computed columns. Read on...

An In-Depth Coverage of ASP.NET 2.0's Master Pages: Part 1

Version 2.0 of the .NET Framework has a truckload of new features, and a significant part of these are in ASP.NET 2.0. Among the new features in ASP.NET 2.0, the one that excites me the most and that I feel will be the most useful, is Master Pages. Read on...