Working with Database ASP.Net & C#.Net 2.0

For running large queries with ASP.Net and C#.Net in SQL Server 2005,

http://www.asp.net/learn/data-access/tutorial-25-cs.aspx
http://static.asp.net/asp.net/files/DataTutorials/datatutorial25cs.pdf

• Data Tutorials Start Page

Introduction

• Creating a Data Access Layer
• Creating a Business Logic Layer
• Master Pages and Site Navigation

Basic Reporting

• Displaying Data With the ObjectDataSource
• Declarative Parameters
• Programmatically Setting the ObjectDataSource's Parameter Values

Master/Detail

• Master/Detail Filtering With a DropDownList
• Master/Detail Filtering With Two DropDownLists
• Master/Detail Filtering Across Two Pages
• Master/Detail Using a Selectable Master GridView with a Details DetailView

Custom Formatting

• Custom Formatting Based Upon Data
• Using TemplateFields in the GridView Control
• Using TemplateFields in the DetailsView Control
• Using the FormView's Templates
• Displaying Summary Information in the GridView's Footer

Editing, Inserting, and Deleting Data

• An Overview of Inserting, Updating, and Deleting Data
• Examining the Events Associated with Inserting, Updating, and Deleting
• Handling BLL- and DAL-Level Exceptions in an ASP.NET Page
• Adding Validation Controls to the Editing and Inserting Interfaces
• Customizing the Data Modification Interface
• Implementing Optimistic Concurrency
• Adding Client-Side Confirmation When Deleting
• Limiting Data Modification Functionality Based on the User

Paging and Sorting

• Paging and Sorting Report Data
• Efficiently Paging Through Large Amounts of Data
• Sorting Custom Paged Data
• Creating a Customized Sorting User Interface

Custom Button Actions

• Adding and Responding to Buttons to a GridView

Displaying Data with the DataList and Repeater

• Displaying Data with the DataList and Repeater Controls
• Formatting the DataList and Repeater Based Upon Data
• Showing Multiple Records per Row with the DataList Control
• Nested Data Web Controls

Filtering Scenarios with the DataList and Repeater

• Master/Detail Filtering With a DropDownList
• Master/Detail Filtering Across Two Pages
• Master/Detail Using a Bulleted List of Master Records with a Details DataList

Editing and Deleting Data Through the DataList

• An Overview of Editing and Deleting Data in the DataList
• Performing Batch Updates
• Handling BLL- and DAL-Level Exceptions
• Adding Validation Controls to the DataList’s Editing Interface
• Customizing the DataList’s Editing Interface
• Implementing Optimistic Concurrency
• Adding Client-Side Confirmation When Deleting
• Limiting Data Modification Functionality Based on the User

Paging and Sorting with the DataList and Repeater

• Paging Report Data in a DataList or Repeater Control
• Sorting Data in a DataList or Repeater Control

Custom Button Actions with the DataList and Repeater

• Custom Buttons in the DataList and Repeater

Accessing the Database Directly from an ASP.NET Page

• Querying Data with the SqlDataSource Control
• Using Parameterized Queries with the SqlDataSource
• Inserting, Updating, and Deleting Data with the SqlDataSource
• Implementing Optimistic Concurrency with the SqlDataSource

Enhancing the GridView

• Adding a GridView Column of Radio Buttons
• Adding a GridView Column of Checkboxes
• Inserting a New Record from the GridView’s Footer

Working with Binary Files

• Uploading Files
• Displaying Binary Data in the Data Web Controls
• Including a File Upload Option When Adding a New Record
• Updating and Deleting Existing Binary Data

Caching Data

• Caching Data with the ObjectDataSource
• Caching Data in the Architecture
• Caching Data at Application Startup
• Using SQL Cache Dependencies

Database-Driven Site Maps

• Building a Custom Database-Driven Site Map Provider

Working with Batched Data

• Wrapping Database Modifications within a Transaction
• Batch Updating
• Batch Deleting
• Batch Inserting

Advanced Data Access Scenarios

• Creating New Stored Procedures for the Typed DataSet’s TableAdapters
• Using Existing Stored Procedures for the Typed DataSet’s TableAdapters
• Updating the TableAdapter to Use JOINs
• Adding Additional DataTable Columns
• Working with Computed Columns
• Configuring the Data Access Layer’s Connection- and Command-Level Settings
• Protecting Connection Strings and Other Configuration Information
• Debugging Stored Procedures
• Creating Stored Procedures and User-Defined Functions with Managed Code

SELECT DEPTNO, ROW# FROM DEDBADM.DEPT TB1, TABLE (SELECT COUNT(*) + 1 AS ROW# FROM DEDBADM.DEPT TB2 WHERE TB2.DEPTNO < TB1.DEPTNO) AS TDEPT_TAB
WHERE ROW# BETWEEN 2 AND 4;