By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,709 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

DataView objects RowStateFilter vs RowFilter for dummies

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
Hi Roy,

My commiserations. - So near yet... :-(

Regards,
Fergus
Nov 20 '05 #2

P: n/a
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.
Nov 20 '05 #3

P: n/a
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
Nov 20 '05 #4

P: n/a
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 <contents> of the Rows.So you can obtain the Rows that have, for example, a given value in a givencolumn. The filter will depend entirely on what columns you have and on whatthey hold.

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

Nov 20 '05 #5

P: n/a
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/de...us/cpref/html/
frlrfsystemdatadataviewrowstateclasstopic.asp
RowStateFilter
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatadataviewclassrowstatefiltertopic.as p

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/de...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.

--------------------
Content-Class: urn:content-classes:message
From: "Roy Lawson" <ro*@xeon.tv>
Sender: "Roy Lawson" <ro*@xeon.tv>
Subject: DataView objects RowStateFilter vs RowFilter for dummies
Date: Sun, 21 Sep 2003 22:38:48 -0700
Lines: 15
Message-ID: <06****************************@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcOAy8wRLJ/FsF5nSf+PHSJzMfIKvg==
Newsgroups: microsoft.public.dotnet.languages.vb
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:140136
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.dotnet.languages.vb

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


Nov 20 '05 #6

P: n/a
Cor
Hi Fergus,

Good EveningMorning

<Filter 1>

Fergus the new beefeater (policeman)?

:-))))

Cor
Nov 20 '05 #7

P: n/a
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

Nov 20 '05 #8

P: n/a
Cor
Fergus

I understand, how many spam mails did you get?

<Filter 1> = policeman :-))

Cor
Nov 20 '05 #9

P: n/a
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
Nov 20 '05 #10

P: n/a
Cor
Fergus,

This I did read in the newsgroup asp.net.

Yes, Tons of them. I check my email when I woke up this morning and had 32of them "Dean" <de*****************@getridofspamearthlink.net> wrote in message
news:ep*************@tk2msftngp13.phx.gbl...
All of a sudden I am getting massive amounts of spam with .exe files
attached that is allegedly from Microsoft. Starting today it's about one
every 3 or 4 minutes. These forums are the only place I use my email addrand, unfortunately, I did not disguise my address.
Dean


Nov 20 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.