Working with Data in ASP.NET 2.0 - Efficiently Paging Through Large Amounts of Data
As we discussed in the preceding tutorial, paging can be implemented in one of two ways:
- Default Paging – can be implemented by simply checking the Enable Paging option in the data Web control’’s smart tag? however, whenever viewing a page of data, the ObjectDataSource retrieves all of the records, even though only a subset of them are displayed in the page
- Custom Paging – improves the performance of default paging by retrieving only those records from the database that need to be displayed for the particular page of data requested by the user? however, custom paging involves a bit more effort to implement than default paging
Read more
The WSIT Tutorial For Web Services Interoperability Technologies
THIS tutorial explains how to develop web applications using the Web Service Interoperability Technologies (WSIT). The tutorial describes how, when, and why to use the WSIT technologies and also describes the features and options that each technology supports.
Read more
ASP.NET Server-Side Data Acces
Introduction to Server-Side Data
Connections, Commands, and DataSets
Accessing SQL-based Data
Binding SQL Data to a DataGrid
Performing a Parameterized Select
Inserting Data in a SQL Database
Updating Data in a SQL Database
Deleting Data in a SQL Database
Sorting Data from a SQL Database
Working with Master-Detail Relationships
Writing and Using Stored Procedures
Accessing XML-based Data
Section Summary
Read more
Working with DataGridView
This lesson describes how to configure and work with data in a DataGridView control. The DataGridView is typically used to display the contents of a DataTable in a DataSet. This lesson shows how to:
- Use the DataGridView control to display and update the data.
- Bind a DataGridView control to a data source.
- Configure a DataGridView to use multiple data sources.
- Manage columns in a DataGridView control.
- Format a DataGridView control by using styles.
- Format a DataGridView control by using custom painting.
- Configure the column and cell types of a DataGridView.
- Add tables and columns to a DataGridView control.
- Delete columns in a DataGridView control.
- Respond to clicks in a DataGridView control.
- Validate input with a DataGridView control.
- Change data displayed in a DataGridView control at run time.
Read more
Working with Data in ASP.NET 2.0 - Handling BLL and DALLevel Exceptions
In the Overview of Editing and Deleting Data in the DataList tutorial, we created a DataList that offered simple editing and deleting capabilities. While fully functional, it was hardly userfriendly, as any error that occurred during the editing or deleting process resulted in an unhandled exception. For example, omitting the product’s name or, when editing a product, entering a price value of “Very affordable!”, throws an exception. Since this exception is not caught in code, it bubbles up to the ASP.NET runtime, which then displays the exception’s details in the web page. As we saw in the Handling BLLand DALLevel Exceptions in an ASP.NET Page tutorial, if an exception is raised from the depths of the Business Logic or Data Access Layers, the exception details are returned to the ObjectDataSource and then to the GridView. We saw how to gracefully handle these exceptions by creating Updated or RowUpdated event handlers for the ObjectDataSource or GridView, checking for an exception, and then indicating that the exception was handled.
Read more