Filtering With Data View In .NET:

Retrieving data from SQL SERVER is a common Task. But retrieving, every time for a single filtering makes a complicate Task. To avoid this we can make use of Data view in asp.net.
Once we retrieve the data into dataset, we can simply make use of that dataset for further filtering process.
Here in this sample example, I have a dsClientAssignment as a dataset which contains whole data with different designations .But iam filtering only manager designation.And I am again binding to dsClientAssignmentFilter dataset for further use.

Test.vb

Dim viewClientAssignment As New DataView
Dim dsClientAssignmentFilter As New DataSet
Dim strFil, sDiv, msPrevDiv As String
viewClientAssignment = dsClientAssignment.Tables(0).DefaultView
strFil = "Designation='manager'"
viewClientAssignment.RowFilter = strFil
viewClientAssignment.RowStateFilter = DataViewRowState.CurrentRows
dsClientAssignmentFilter.Tables(0).Merge(viewClientAssignment.ToTable.DefaultView.Table)