Install and Run Your ASP.NET Applications on Systems Without IIS   01 Mar 2006 04:06 GMT
Learn how to install and run your ASP.NET applications on systems without IIS in three easy steps.
Source: DevX

Build a Sudoku Puzzle Game Generator and Solver for PocketPC   01 Mar 2006 02:15 GMT
Not only can you generate your own Sudoku puzzles with this mobile application, but you can solve them, too—even puzzles you enter from newspapers or books.
Source: DevX

Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with Parameters   01 Mar 2006 00:00 GMT

Data Source Control Basics - explores the concepts and advantages of data source controls, and compares their usage in ASP.NET 2.0 to data access techniques in ASP.NET 1.x.

Accessing Database Data - shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.

Filtering Database Data with Parameters - learn how to retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page, session variables, and so on.

(Subscribe to this Article Series! )

A Multipart Series on ASP.NET 2.0's Data Source Controls
ASP.NET 2.0 introduced a number of new Web controls designed for accessing and modifying data. These controls allow page developers to declaratively access and modify data without writing any code to perform the data access. This article is one in a series of articles on ASP.NET 2.0's new data source controls.

In Part 2 of this article series we looked at how to access relational database data using the AccessDataSource and SqlDataSource controls. However, in Part 2 we only looked at how to retrieve all of the records from a table, view, stored procedure, or ad-hoc SQL query. Often, we only want to retrieve a subset of data based on various criteria. When searching for a book on Amazon.com, for example, the search page retrieves only the data from the database that matches the search terms you entered; when viewing the details for a particular book, only the particular book's information is queried from the database.

Results are filtered in a SQL statement using the WHERE clause, which contains a boolean expression. For each record in the table being queried, the WHERE expression is evaluated to determine whether or not to include that record in the resultset.¹ For example, a SQL query like: SELECT ProductID, ProductName FROM Products WHERE UnitPrice < 15.00 will return the ProductID and ProductName column values for all records in the Products table for which the statement UnitPrice < 15.00 evaluates to True. In English, it returns all products that cost strictly less than fifteen bucks.

The SqlDataSource and AccessDataSource controls can define the value by which the query is filtered by using parameters, and these parameters can retrieve their values from a variety of sources, including: the querystring, session variables, other Web controls on the page, and so on. Like the connection string and SELECT query, the filter parameters values for a data source control can be set declaratively, meaning you do not need to write a line of code. These parameter values can also be set programmatically, though, for cases where you might need to base the filter value on programmatic logic (such as the currently logged-in user's username).

In this article we will examine how to declaratively filter the results of a SQL query using parameters in a SqlDataSource. We'll see examples of how to use hard-coded filter values, and well as examples with filter values taken from the querystring and other Web controls on the page. Read on to learn more!

¹ - this is a gross oversimplification of how the database engine determines what rows, exactly, to return, but is an accurate description from a high-level perspective...
Read More >

Source: 4GuysFromRolla

Managed Spy: Deliver The Power Of Spy++ To Windows Forms With Our New Tool   28 Feb 2006 18:12 GMT
This article describes how to implement and use a new utility ManagedSpy and its associated library ManagedSpyLib. Similar in concept to Spy++, ManagedSpy and ManagedSpyLib allow you to programmatically access Windows Forms controls in another process.
Source: MSDN

Get Control and Performance with the Real Time Stylus API   25 Feb 2006 00:49 GMT
The Real Time Stylus API provides an alternate way to receive pen input pen. This high performance API provides a great level of control to developers for a small penalty in added effort.
Source: DevX

The Life and Times of Anders Hejlsberg   24 Feb 2006 20:38 GMT
In this episode of Behind the Code on Channel 9, Anders Heijlsberg talks about his background and experiences that lead to his becoming the Chief Architect of the C# programming language.
Source: MSDN

Download the Free C# Code Snippet Libraries for Visual Studio 2005   23 Feb 2006 23:37 GMT
Get the full set of C# Code Snippets for using within Visual Studio 2005 to have reusable, task-oriented blocks of code that you can easily paste into your development projects.
Source: MSDN

Working with DataGrid Using AJAX   23 Feb 2006 00:00 GMT
This article will explain how to populate the DataGrid control using AJAX. This will take a DropDownList as a source for explanation. For every index change of the DropDownList, the DataGrid contents will be refreshed accordingly using AJAX.
Source: AspAlliance

Data Binding in Windows Forms 2.0   22 Feb 2006 04:24 GMT
Windows Forms 2.0 increases support for data binding via the new BindingNavigator and BindingSource objects, which will save you a lot of effort. Find out how you can perform sorting and searching tasks using data binding and simplify the display of master-detail relationships in tables.
Source: DevX

Building Report-enabled Applications with the New ReportViewer Controls (Part 2 of 2)   22 Feb 2006 00:20 GMT
Organizations can use Reporting Services to make data easily accessible to internal users, customers, and partners. The second part of this article shows you how you can leverage the Web version of the ReportViewer control to integrate Reporting Services 2005 with your intranet and Internet applications—without compromising security.
Source: DevX