Programming> Asp. Net 3.5 development example analysis> discussion on obejctdatasource control> subject
Layer-3 architecture: the presentation layer, business layer, data layer, and obejctdatasource control are bridges between the business layer and the presentation layer. The business layer serves as a bridge between the presentation layer and the data layer. The preceding sqldatasource control is also a bridge between the presentation layer and the data layer.
The obejctdatasource control also involves SQL statement parameters, not only the Textbox Control on the webpage, radionbutton control, gridview control, session, cookie, but also the user setting file as a parameter and a class as a parameter.
The obejctdatasource control uses custom paging and custom sorting to improve data reading performance and flexibility.
---------------------------------------
Programming> Asp. Net 3.5 development example analysis> discussion on obejctdatasource control> Custom paging mechanism and custom sorting mechanism
There are two paging Methods: User Interface paging and Data Source paging.
The paging mechanism of the user interface refers to the mechanism of fully reading the table data, placing it in the memory dataset, and then paging in the memory.
The so-called data source paging mechanism is to construct an SQL statement, read some records, and then put them in dataset or datareader.
There are two sorting methods: User Interface sorting and Data Source sorting.
The so-called User Interface sorting mechanism is to read all the table data, put it in the memory dataset, and then sort it in the memory.
The so-called data source sorting mechanism refers to the Construction of SQL statements, sorting well in the database, and then you can put it in dataset or datareader.