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/

Basic use of DataView

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)