blog

Home / DeveloperSection / Blogs / Dataview in ADO.Net

Dataview in ADO.Net

Amit Singh10334 05-May-2011

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);


Updated 18-Sep-2014

Leave Comment

Comments

Liked By