Manipulating data with Dataview

Introduction:
Now i am come up with the DataView object in .NET frame work. The DataView is only helps to view the resultant records in the datasource. In DataView you can do any editing or updating work, if you want to edit or update the records, you have to do it in datatable and repopulate it in the dataview. One of the major advantages of DataView control is Sorting with in the records, you dont want to go to datasource for sorting. Let us get in to the DataView Object.

Manipulating data with Dataview:
DataView is used to show the data in different format and helps to bind datas in the controls. The data available in the DataView is in the form of table and are arranged in a fashion. Let’s see how to declare a DataView.
Vb Code:

Dim dv As New DataView
Or
Dim dv As New DataView(dsetMydata.Tables(0))

C# Code:

DataView dv = new DataView();
OR
DataView dv = new DataView(dsetMydata.Table[0]);

You cannot assign a data source directly to the DataView, but you can assign a DataTable to the DataView. The following code shows how a DataSet can be populated.

VB Code:

Dim dv As New DataView
dv = dsetMydata.Tables(0).DefaultView
DataGrid1.DataSource = dv

C# Code:

DataView dv = new DataView();
dv = edsetMydata.Tables[0].DefaultView;
DataGrid1.DataSource = dv;

The DataView is populated from the DataTable and binds in a DataGrid as shown in Figure1.

Figure 1

The record are arranged in au_id order and is a default view.


You can sort the records in ascending or descending order.
VB Code:
dv.Sort = "au_fname desc"

C# Code:
dv.Sort = "au_fname desc”;

Figure 2

The Records are sorted by au_fname in deceding order as shown in Figure 2

Conclusion:
Hope this article will help you to understand the DataView object in .NET. Now Buddies, give your comment about this article.