Basic use of DataView

Question

What is the basic use of dataview in ado.net?

Kunal Vaishya · Answer

Dear main benefit of dataview to filter records and do operation on you can also convert in to table or else

R ACHUTHA · Answer

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 expressio n. 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  DataViewRowState.CurrentRows); refer the below link http://www.c-sharpcorner.com/UploadFile/rohatash/ado-net-dataview-in-Asp-Net/