DataView objects RowStateFilter vs RowFilter for dummies

  • Thread starter Thread starter Roy Lawson
  • Start date Start date
R

Roy Lawson

Can anyone explain the difference between RowStateFilter
and RowFilter properties of the DataView objects in simple
terms?

I am going through a Transcender practice exam and just
when I think I understand the difference I miss the
question. Didn't pass the 306 exam two weeks ago and
don't want to repeat that again <<scored 680, needed 700 :-
( >>

BTW of if you are taking the exam study your butt off on
debug. And if you have a screaming baby at home who won't
let you study...I totally understand :-)

-Roy
 
Hi again Roy,

The RowFilter property allows you to filter on the <contents> of the Rows.
So you can obtain the Rows that have, for example, a given value in a given
column. The filter will depend entirely on what columns you have and on what
they hold.

The RowStateFilter property allows you to filter on the <state> of the
Rows. So you can obtain the Rows that have been added, deleted, mofified, etc
according only to the DataViewRowState Enumeration.
 
Hi again Roy,

The RowFilter property allows you to filter on the <contents> of the
Rows.So you can obtain the Rows that have, for example, a given value in a
given column. The filter is a string containing an expression, and will depend
on what columns you have and on what they hold.

The RowStateFilter property allows you to filter on the <state> of the
Rows. So you can obtain the Rows that have been added, deleted, modified, etc,
according only to the DataViewRowState Enumeration.

Regards,
Fergus
 
Thanks for the prompt reply. So to summarize:

RowFilter deals with data within rows (could be used to
filter rows that have an entry in AnyRow that begins with
the letter "r" or whatever)

RowStateFilter deals with modified rows (could be used to
view records that only have had changes made to them or
whatever)

I think what makes it difficult is how the questions are
posed. Appreciate the help...can't get any good help in
the MCAD/MCSD newsgroups because many seem concerned more
with which dump is the best and could care less about
understanding the concepts.

Thanks for the tips.

-Roy
-----Original Message-----
Hi again Roy,

The RowFilter property allows you to filter on the
Click to expand...
 
Hi Roy,

I think RowStateFilter will filter the rows according by
DataViewRowState.e.g. The rows with Added state.
DataViewRowState
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatadataviewrowstateclasstopic.asp
RowStateFilter
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatadataviewclassrowstatefiltertopic.asp

While the RowFilter will filter the rows according by the Row value.e.g.
"LastName = 'Smith'",where the LastName is the field name.
RowFilter
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfsystemdatadataviewclassrowfiltertopic.asp

It is pity that you will hardly pass the exam. I think you will be lucky
next time. :)

Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

--------------------
 
Morning Cor,

|| <Filter 1>

An email address which can be spammed. When it gets too much, I close it
and move on to filter-2.

|| Fergus the new beefeater (policeman)?

?? policeman ?

beefeater - much less since BSE!!

Regards,
Fergus
 
Ho Cor,

No actual spam so far, I guess they haven't found it in the newsgroup yet,
but I've had 400+ of the virus emails so far.

Have you been blessed with their attentions?

Regards,
Fergus
 
Back
Top