Dataview in ADO.Net

A dataview enables you to create different views of the data stored in a DataTable, a capability that is often used in data-binding applications. Using a DataView, you can expose the data in a table with different sort orders, and you can filter the data by row state or based on a filter expression.

Dataview provides a dynamic view for a datatable. Using dataview we can perform following operation:

·         Sorting the table

·         Add, modify, delete the data

·         Filtering data from table

Example:

Creating Dataview object as

Dataview dv=new Dataview();

How to use Sort property of Dataview

DataView dv = DataTable1.DefaultView;   

dv.Sort = 'username, email DESC';

Filtering in Dataview
DataView dv = new DataView(datatable1,'joindate >= 01/01/2010',   DataView

RowState.CurrentRows);

Last updated:9/18/2014 1:23:55 PM

2 Comments

Leave Comment