Filtering a Dataview -- Help Please

[Jason]

I've gathered a bunch of data from Active Directory and placed it into a
datatable ("ADTable"). I now need to sort and filter this table based on
the selection of a drop down list("ddlCatego ry"). How can I filter the
dataview of this datatable to display those records that match (partially or
fully) the value selected in the drop down list?

I have the following code that doesn't work, and returns zero rows (note
that 'department' is a valid column name as I've tested dvCustom.RowFil ter
="department Like Information Management" and it works):

Private Sub btnSearch_Click (ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles btnSearch.Click

'Make a copy of the default dataview of the ADTable so it's refreshed to
original every time button is clicked.

Dim dvCustom As DataView = ADTable.Default View

dvCustom.RowFil ter = "department LIKE " & "'*" &
ddlCategory.Sel ectedItem.Text & "*'"
'cn is another column name, is valid and works.
dvCustom.Sort = "cn"

'DGADResults is simply a datagrid that displays the dataview

DGADResults.Dat aSource = dvCustom
DGADResults.Dat aBind()
End Sub

Any help would be greatly appreciated!

Thanks in advance,

Jason

[Jason]

Thanks alot, that worked alot better than trying to create a custom filter
with wildcards, etc (which I did end up getting to work as well, but
disgarded for this simpler way).

Thanks again.
"vzaffiro" <vz******@discu ssions.microsof t.com> wrote in message
news:BA******** *************** ***********@mic rosoft.com...

Hey jason,

I have done this thru a datatable using the following logic
//Create the datatable from the dataset
DataTable dt = Common.GetLooku pTable(table,we bpage);

//Foundrows is an array that will be returned from the select
DataRow[] foundRows;

//Create the where clause
string whereclause = string.Format(" cdstatus = {0} and cdstatus_apr_or d =
{1}",cdStatus,c urrentOrder)

//Fill the array by filtering the data table
foundRows = dt.Select(where clause);

Foundrows now has an array of datarows that you can traverse.

Here are some references:
http://www.akadia.com/services/dotnet_filter_sort.html
http://www.eggheadcafe.com/articles/20030903.asp

Good Luck!

"Jason" wrote:

I've gathered a bunch of data from Active Directory and placed it into a
datatable ("ADTable"). I now need to sort and filter this table based on the selection of a drop down list("ddlCatego ry"). How can I filter the
dataview of this datatable to display those records that match (partially or fully) the value selected in the drop down list?

I have the following code that doesn't work, and returns zero rows (note
that 'department' is a valid column name as I've tested dvCustom.RowFil ter ="department Like Information Management" and it works):

Private Sub btnSearch_Click (ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles btnSearch.Click

'Make a copy of the default dataview of the ADTable so it's refreshed to original every time button is clicked.

Dim dvCustom As DataView = ADTable.Default View

dvCustom.RowFil ter = "department LIKE " & "'*" &
ddlCategory.Sel ectedItem.Text & "*'"
'cn is another column name, is valid and works.
dvCustom.Sort = "cn"

'DGADResults is simply a datagrid that displays the dataview

DGADResults.Dat aSource = dvCustom
DGADResults.Dat aBind()
End Sub

Any help would be greatly appreciated!

Thanks in advance,

Jason