Working with DataView in C#
The DataView object
provides a window into a data table that can be sorted and filtered. A data
table can have many DataView objects
assigned to it, so the data can be viewed in many ways without requiring it to
be reread from the database. A major function of the DataView is to allow
data binding on both Windows Forms and Web Forms.
We can perform several operations with DataView:
- Sorting – The view of the data can be sorted based on one or more
columns in ascending or descending order
Ex :
DataView dView = new
DataView();
dView.Sort =
"CreatedDate DESC"
- Filtering – The data visible through the view can be filtered with
expressions based on one or more columns.
Ex:
dView.Table = DataSet1.Tables["Suppliers"];
dView.RowFilter = "City = 'New Delhi'";
- Row version filtering – The data visible through the view can be filtered based on
the version of the rows.
Ex:
dView.RowStateFilter = DataViewRowState.ModifiedCurrent;
We
can create a DataView using three ways:
- Retrieve the default view of a DataTable by using its DefaultView property.
- Create a new instance of a DataView
that can than be associated with a DataTable.
- Use a DataViewManager to create a DataView for a DataTable.