Expression in a DataForm

[Steve Teeples]

I've never done database code in C#. :(

I've connected a dataform to a database and can reference all the items in
the table. I want to filter the elements though based upon the value of a
field. The field is call CategoryType of type unsignedByte. The value I
wish to filter on it '19'. Where, within the properties of CategoryType, do
I set the filter?

I tried several things in "Expression" but filtering still doesn't occur.
How do I filter the table query and get back only those rows whose
CategoryType is 19?

--
Steve

[Cor Ligthert [MVP]]

Steve,

For real filtering (as your word says) the rowfilter of the dataview is
probably the best.

For filtering, selecting, finding, there are at least 4 methods in AdoNet

Datatable.select (know that the sort in that is almost one big bug)
Dataview.find
Dataview.rowfilter
DataRowCollection.find

(they return different objects)

I hope this helps,

Cor
"Steve Teeples" <St**********@discussions.microsoft.com> schreef in bericht
news:05**********************************@microsof t.com...

I've never done database code in C#. :(

I've connected a dataform to a database and can reference all the items in
the table. I want to filter the elements though based upon the value of a
field. The field is call CategoryType of type unsignedByte. The value I
wish to filter on it '19'. Where, within the properties of CategoryType,
do
I set the filter?

I tried several things in "Expression" but filtering still doesn't occur.
How do I filter the table query and get back only those rows whose
CategoryType is 19?

--
Steve