Working with Computed Columns : Scott Mitchell
When creating a database table, Microsoft SQL Server allows you to define a computed column whose value is calculated from an expression that usually references other values in the same database record. Such values are read-only at the database, which requires special considerations when working with...
Selecting CheckBoxes Inside TreeView Control : Azamsharp
In the last article I explained that how you can populate the TreeView control with the data coming from the database. You can read the new article at Populating TreeView Control With Database. In this article I will explain that how you can select checkboxes which are inside the TreeView control. The...
Building TreeView Resultset with SQL Server 2005 : Ameet Phadnis
This article is an upgrade of my previous article on Building Tree View Resultset. It explains how we can create the Tree View Resultset with SQL 2005 with just one SQL Statement. In a corporate environment we usually face coding tasks to display results in Treeview. The tasks may include displaying...
Querying Data with the SqlDataSource Control : Scott Mitchell
In the preceding tutorials we used the ObjectDataSource control to fully separate the presentation layer from the Data Access layer. Starting with this tutorial, we learn how the SqlDataSource control can be used for simple applications that do not require such a strict separation of presentation and...
Caching Techniques in ASP.NET 2.0 : Richard Bean
Performance is the key requirement of any application. One of important technique which helps in the performance of application is Caching. Caching is the process of storing frequently used data on the server to fulfill subsequent requests. Reusing pages from memory is much faster than re-creating pages...
Updating and Deleting Existing Binary Data : Scott Mitchell
In earlier tutorials we saw how the GridView control makes it simple to edit and delete text data. In this tutorial we see how the GridView control also makes it possible to edit and delete binary data, whether that binary data is saved in the database or stored in the file system. Over the past three...
New ASP.NET Dynamic Data Support : Scott Guthrie
In this article, Scott examines how to build powerful data driven websites using the new Dynamic Data Support model in ASP.NET 3.5. Scott introduces a screen-cast followed by a series of steps with associated screenshots with emphasis on LINQ. Finally, Scott provides a complete analysis of the output...
LINQ to SQL Instantiation : Brian Mains
This article discusses how and when the objects within LINQ to SQL are created and instantiated, and how it maintains a list of the changes that need submitted to the database. It also discusses how this can be managed and some of the intricacies in LINQ with the help of source code. LINQ to SQL is an...
Paging Database Results in ASP.NET : Scott Mitchell
This article examines how to create a databound listbox using ASP.NET. For more information on ASP.NET be sure to check out the articles in the ASP.NET Article Index. The code in this article is based on the Beta 2 version of ASP.NET. To learn more about the free ASP.NET Beta 2, be sure to check out...
Inserting, Updating, and Deleting Data with the SqlDataSource : Scott Mitchell
In previous tutorials we learned how the ObjectDataSource control allowed for inserting, updating, and deleting of data. The SqlDataSource control supports the same operations, but the approach is different, and this tutorial shows how to configure the SqlDataSource to insert, update, and delete data...
