ADO. NET is designed for solving the Web and program problem about the distribution application by Microsoft. As a kind of visit frame of database, ADO. NET can handle the N layer's data architecture which doesn't join that Web application program requires, thus when visiting the database of SQL SERVER, superior performance has gotten extensive application. This paper discusses for this.
I.The major object of ADO.NET.
Many objects in ADO.Net is similar to the object function in ADO , but the function of the object in ADO.NET is more powerful. At the same time, except the objects of the Connection, Parameter and Command , ADO. NET also add a lot of new object and program melt interface, such as DataSet, DataView, DataAdapter, DataReader and DataSetCommand etc..It make more simple to operate the database.
I.a DataSet object: DataSet is the core of ADO.NET, is specially used to handle the data which is read out from the stock , and keep it in local memory as away from line. We can use identical way to operate the data which is got from the different data source, the behavior of DataSet is consistent whatever the base layer database is SQL Server or Oracle. In


ADO.NET 是Microsoft 為解決Web 和分布式應用程序問題而設計的。作為一種數(shù)據(jù)庫訪問框架, ADO.NET 能處理當今N 層的Web應用程序所要求的非連接數(shù)據(jù)體系結(jié)構(gòu), 因而在訪問SQL SERVER數(shù)據(jù)庫時, 性能優(yōu)越, 得到了廣泛應用。本文對此進行了討論。
一、ADO.NET 的主要對象
ADO.NET 中有很多對象與ADO 中的對象功能相似, 但ADO.NET 中對象的功能更強大。同時, 除Connection、Parameter、Command對象外ADO.NET 還添加了許多新的對象和程序化接口, 如DataSet 、DataView、DataAdapter、DataReader、DataSetCommand 等,
使得對數(shù)據(jù)庫的操作更簡單。
1、DataSet 對象: DataSet 是ADO.NET 的核心, 是專門用來處理從數(shù)據(jù)存儲中讀出的數(shù)據(jù), 并以離線方式存在于本地內(nèi)存中?？梢允褂孟嗤姆绞絹聿僮鲝牟煌瑪?shù)據(jù)來源取得的數(shù)據(jù), 不管底層的數(shù)據(jù)庫是SQL Server 還是Oracle, DataSet 的行為都是一致的。在DataSet 中可以包含任意數(shù)量的DataTable, 且每個DataTable 對應一個數(shù)據(jù)庫的Table 或View。一般來說, 一個對應