|
.NET binding viewing and filtering - August 25, 2008 at 18:00 PM
by Amit Satpute
What is the role of data provider?
Answer
The .NET data provider layer resides between the application and the
database. Its task is to take care of all their interactions.
The .NET Data provider can be demonstrated to be:
SQL Server data provider
OLEDB data provider
ODBC Data Provider
ADO.NET supports the following OLE DB Providers:
- SQLOLEDB - Microsoft OLE DB Provider for SQL Server.
- MSDAORA - Microsoft OLE DB Provider for Oracle.
- Microsoft.Jet.OLEDB.4.0 - OLE DB Provider for Microsoft
Jet.
Explain how to filter and sort data with the DataView
component.
Answer
One of the ways to sort and filter data is to use the ‘select’ method.
However, our focus is on the DataView object.
A data view can provide a filtered and sorted view of the data in the table.
The advantages of using the DataView Component are:
DataView can be configured at design time as well as run time.
DataView can even be bound to the controls.
The data can be viewed in the desired format using the DataView.
What is DataViewManager?
Answer
DataViewManager can be used to manage view settings of the tables in a DataSet.
A DataViewManager is best suited for views that consist of a combination of
multiple tables. The properties like ApplyDefaultSort, Sort, RowFilter , and
RowStateFilter are referenced using DataViewSetting.
|