.NET binding viewing & filtering

.NET binding viewing and filtering - Interview questions

<<Previous  Next>> What is the role of data provider?  The .NET data provider layer resides between the application and the database. Its task is to take care of all their interactions................    Explain how to filter and sort data with the DataView component.      One of the ways to sort and filter data is to use the ‘select’ method. However, our focus is on the DataView object.............. What is DataViewManager? DataViewManager can be used to manage view settings of the tables in a DataSet. A DataViewManager is best suited for views...............   <<Previous  Next>> Also read Overview of ADO.NET architecture. Data Provider provides objects through which functionalities like opening and closing connection, retrieving and updating data can be availed.............  What are basic methods of Dataadapter? This method executes the SelectCommand to fill the DataSet object with data from the data source........... How can we add/remove row’s in “DataTable” object of “DataSet”? ‘NewRow’ method is provided by the ‘Datatable’ to add new row to it.............. Differences between “DataSet” and “DataReader”. DataSet object can contain multiple rowsets from the same data source as well as from the relationships between them....... What is connection pooling and what is the maximum Pool Size in ADO.NET Connection String? A connection pool is created when a connection is opened the first time........