服务方数据访问

服务方数据访问

　　服务方数据访问

　　* 服务方数据的介绍

　　* 连接，命令和数据设置

　　* 对基于SQL数据的访问

　　* 绑定SQL数据到DATAGRID控件

　　* 参数的选择

　　* 向数据库插入数据

　　* 更新SQL数据库中的数据

　　* 删除SQL数据库中的数据

　　* 将SQL数据库中的数据进行排序

　　* MASTER-DETAIL关系

　　* 写和使用存储程序

　　* 访问基于XML的数据

　　* 段落摘要

　　基于服务方数据的介绍

　　在任何应用程序中，对数据访问都是核心。ASP.NET提供了一系列丰富的与数据管理访问API相结合的由通用运行语言提供的控件。这段讲述了几个使用asp.NET中的DATAGRID控件去绑定SQL查询和XML数据文件的例子。这段建立在我们熟悉数据库基本技术和SQL查询语言的基础上的。

　　服务器端数据访问是独立的，不附属于任何其他控件。当试图对数据库对数据库插入、删除或更新时，会遇到很多困难。你将在这段中明白DATAGRID控件能帮助管理这些难题，允许你花费更多精力在程序逻辑上，而较少关注状态管理的细节和事件处理。

　　连接、命令和数据集合



外文原文（复印件）

Server-Side Data Access

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



Introduction to Server-Side Data

Data access is the heart of any real-world application, and ASP.NET provides a rich set of controls that are well-integrated with the managed data access APIs provided in the common language runtime. This section walks through several iterations of a sample that uses the asp.NET DataGrid control to bind to the results of SQL queries and XML data files. This section assumes some familiarity with database fundamentals and the SQL query language.

Server-side data access is unique in that Web pages are basically stateless, which presents some difficult challenges when trying to perform transactions such as inserting or updating records from a set of data retrieved from a database. As you'll see in this section, the DataGrid control can help manage these challenges, allowing you to concentrate more on your application logic and less on the details of state management and event handling.