【正文】
et, DataView, DataAdapter, DataReader and DataSetCommand etc..It make more simple to operate the database. DataSet object: DataSet is the core of , 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 DataSet, it can contain arbitrary quantity of DataTable, and every DataTable is in correspondence with Table or View in darabase. Generally speaking,a corresponding DataTable is a set of a group of DataRow and DataColumn for the data sheet of can take the responsibility for defending each data trip to retain it39。 英文一原文: ADO. Net Technology 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 layer39。s data architecture which doesn39。s initial state and current state, with the concurrent that solves database visit problem. reduce the pressure of being away from line to join pattern decreasing for data server. DataReader object: When looking over mass data with the way that glanced over , it will occupy plenty of memories and cause performance to drop. For instance,when a link (Connection ) reads the record of 1000 lines of database by using the traditional ADO Recordset ,it must give this link memory distribution for this 1000 lines of record untill the life period of this link finish. If there are many users carrying out the same operation for same puter at the same time,the memory will be used out. To solve these problems, DotNET frame has offered DataReader object, from database,it return a readonly string, which can roll downward only to flow ( Strem ), and exists a record every time only in courently. DataView object: DataView object representative one DataTable approach by looking over , it is to put data in order with the form of form that what data acquiesce in look over way, and the order of data that put data in order follow the order taking out the trip that put litre and the fence position of row order in order from database data sheet, usually it is concerned with the Sort Order or reduce power in inquiring string when design the database .ADO. NET offer the way that has elasticity very much to let user use row order and condition filter , seek etc. property way of looking over of defining difference , so, edit and glance over data or show the data in DataTable .For instance ,we can establish a DataView object, then designate with with default look over ( DefaultView ) different row order way, or also can use condition filter ( Filter ) look over the partial data in data sheet. This kind of way can tie two above control items to a same data sheet, but what show is thay the different data. DataAdapter object: ADO. NET establish and initialize data sheet through DataAdapter, so as to keep the data in the memory bining with DataSet object. DataAdapter object can hide the details that links up with Connection and Command. DataAdapter object allow to put the data to the data source ( DataSource )which gets from DataSet can also take out data from data source. By the same way,it can also operate the bottom data preserved by adding ,deleting or modifing. Database in joining The analysis of a example which visit the database of