C#编程： Compact Framework中的ADO.NET数据库操作

需积分: 1 198 浏览量更新于2024-07-30 收藏 283KB PDF 举报

本章（第12章）深入探讨ADO.NET编程在.NET Compact Framework中的应用。ADO.NET是一套针对管理代码设计的数据库编程类库，它在桌面版的ADO.NET基础上，提供了对内存数据库操作的便捷且灵活的方式。在.NET Compact Framework环境中，ADO.NET支持三种持久数据存储选项：XML文件、Windows CE设备上的Microsoft SQL Server CE数据库以及台式机或服务器版本的SQL Server 7.0/2000数据库。章节内容首先介绍了ADO.NET的整体概念，强调其作为一个层次化的方法论，通过不同的组件和接口来处理数据库操作。这包括命名空间引用和程序集引用的重要性，因为它们确保了正确使用ADO.NET的功能集合。功能部分，作者对比了ADO.NET与其他技术的优越性，指出其提供了超越传统方法的特性，如更高级的数据绑定能力。同时，也讨论了错误处理机制，强调了在编程时处理网络、数据库或应用程序级别的错误的必要性。实用技巧和工具是本章的另一个亮点，涵盖了如何创建和访问DataSet、DataTable和DataView，这些都是ADO.NET的核心数据结构。理解DataTable的关键在于其结构和动态特性，而DataRow则提供了操作表中单条记录的能力。DataView则是一种中间层对象，用于提供对原始数据的筛选和排序，提高了数据处理的灵活性。此外，本章深入讲解了数据绑定的过程，特别是在多控件环境下的绑定，这使得开发者能够将数据无缝地与用户界面元素关联，实现动态数据展示。通过这些内容，读者可以掌握如何在.NET Compact Framework中高效、安全地进行数据库操作，提升应用程序性能和用户体验。第12章ADO.NET Programming为.NET Compact Framework开发人员提供了一个全面的指南，帮助他们利用ADO.NET的强大功能进行高效、安全的数据库编程，无论是在嵌入式设备还是桌面应用环境中。

Programming the .NET Compact Framework in C# By Paul Yao & David Durant

Chapter 12 – ADO.NET Programming Page 6

Table 12-3 – Classes for accessing, maintaining and displaying data [Comment 12cs.26]

Category Class Purpose / Comments

Filesystem

Directory

Create, delete, move, and detect

directories.

File

Create, delete, move, copy, and detect

files.

Provider-Specific classes for

SQL Server CE

and SQL

Server

SqlCeEngine

Create a SQL Server CE database.

Compact a SQL Server CE database.

SqlCeConnection

SqlConnection

Open a connection to a database. Only

one open connection per SQL Server CE

database at a time.

SqlCeCommand

, SqlCommand

Submit a SQL statement to the database.

Contains the connection object.

SqlCeDataReader,

SqlDataReader

Retrieve the rows returned by a command.

Can only be created by the command’s

ExecuteReader method. Only one

open data reader per SQL Server

connection at a time.

SqlCeDataAdapter,

SqlDataAdapter

Moves data between a database and a

DataTable. Contains up to four

command objects.

SqlCeCommandBuilder,

SqlCommandBuilder

Reverse engineers a simple SELECT

statement to create the INSERT, UPDATE,

and DELETE statements used by an

adapter to move modified data from a

DataTable back to the database.

Provider-independent

ADO.NET Classes

DataSet

Memory resident database. Contains the

provider-independent classes listed below.

DataTable

Memory resident table.

DataRow

A row within a DataTable. Contains the

data. Has methods to access other rows in

other tables based on DataRelations,

such as GetChildRows.

DataView

Sorts and filters the rows of a

DataTable. Primarily for use with data

binding.

DataRelation

Specification of parent-child relationship

between two DataTables.

UniqueConstraint

Constraint on a DataTable.

ForeignKeyConstraint

Constraint relating two DataTables.

Data Binding Support

Multi-item controls – DataGrid,

ListBox, ComboBox

When data bound, display one or all

columns of a DataTable or DataView.

Are non-updateable.

Single-item controls – TextBox,

Label, RadioButton,

CheckBox, Button, etc.

When data bound, display one column of

one row of a DataTable or DataView.

Automatically propagate data changes

In the System.IO namespace.

In the System.Data.SqlServerCe namespace.

In the System.Data.SqlClient namespace.

In the System.Data namespace.

In the System.Windows.Forms namespace.

Programming the .NET Compact Framework in C# By Paul Yao & David Durant

Chapter 12 – ADO.NET Programming Page 7

back to the bound DataTable. A

CurrencyManager (see below)

manages row positioning and data

updating.

DataBindings Collection

A property of a single-item control. Used

to specify data binding between a

DataTable or DataView and the

single-item control.

BindingContext

A property of a form. Contains a

collection of

CurrencyManager

objects. Used by the form to manage all

data binding of all contained controls.

Created by the .NET runtime.

CurrencyManager

Manages the automatic updating of bound

DataTables. Can be used to override

the automatic updating of bound

DataTables by canceling the update or

forcing the immediate execution of the

update.

Contains a read-write indexer property

that identifies the “current” row of the

bound DataTable or DataView.

Created by the .NET runtime. Can be

obtained by calling the form’s

BindingContext(DataTable/DataView

name) indexer property.

Note from table 12-3 that SQL Server permits multiple open connections but only one open

data reader per connection; while SQL S erver CE is just the opposite, permitting only one open

connection but allowing multiple open readers on that connection.

[Comment 12cs.27]

Also note that Compact Framework multi-item controls do permit users to enter data. As

mentioned in chapter 8, Data Binding, the data grid control is display only, and the combo box

control does not permit direct entry of a value, allowing the user to select from the list only.

[Comment 12cs.28]

Namespace References and assembly references

The SQL Server CE specific ADO.NET classes are located in the

System.Data.SqlServerCe namespace. There is a similar set of classes in the

System.Data.SqlClient namespace for use when accessing SQL Server. Other

namespaces hold classes for accessing data via Oracle, OLEDB, and ODBC on the

desktop, but at the present these data providers are not supported in the Compact

Framework. No doubt, additional providers will become available in the future.

[Comment 12cs.29]

Because the classes are located in specific namespaces, you must set some

references in your project before writing any code. You need to set a reference to the

System.Data.SqlServerCe namespace because it holds the classes that you must use

to access a SQL Server CE database; and you need to set a reference to the

System.Data.SqlClient when accessing SQL Server. You also need to set a

reference to the

System.Data.Common namespace because it contains private classes

used by the data adapter class. And, finally, you need a reference to

System.Data

because it contains the provider-independent classes listed in table 12-3. Among the

namespace references and the assembly reference that you may need are the following:

[Comment 12cs.30]

剩余31页未读，继续阅读

chduguxue

粉丝: 27
资源: 30

C#编程： Compact Framework中的ADO.NET数据库操作

ADO .NET Programming

Chapter 12 ADO.NET Programming vb版

Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL 书配代码

.NET Programming with Visual C++: Tutorial, Reference, and Immediate Solutions

Programming Excel With Vba And .net.chm

Pro C# 7: With .NET and .NET Core

Professional C#4.0 and .NET 4.0 part2

Professional C# 4.0 and .NET 4.0 part1

MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition

[ASP.NET.3.5高级程序设计(第2版)].Pro.ASP.NET.3.5.in.C#.2008.2th.edtion.pdf

最新资源