Bizarre behavior of DataView

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Krishna Tripathi - 30 Jun 2004 08:12 GMT

I have a DataView where I am trying to use “rowfilter” property to get a subset of base table rows. When my View gets created any rows which have “modified” or “added” row state are not returned in DataView although they satisfy my filter condition. I have tried to use all possible combinations of “DataViewRowState” enumeration values but nothing seems to be able to force returned DataView to include modified or added status rows. Has any body seen such behavior before or can any body think of any thing why it could be happening?

Reply to this Message

Jon Skeet [C# MVP] - 30 Jun 2004 08:29 GMT

<"=?Utf-8?B?S3Jpc2huYSBUcmlwYXRoaQ==?=" <Krishna
Tripathi@discussions.microsoft.com>> wrote:

> I have a DataView where I am trying to use ?rowfilter? property to
> get a subset of base table rows. When my View gets created any rows
[quoted text clipped - 4 lines]
> include modified or added status rows. Has any body seen such
> behavior beforeor can any body think of any thing why it could be happening?

Could you post a short but complete program which demonstrates the
problem?

See http://www.pobox.com/~skeet/csharp/complete.html for details of
what I mean by that.

Signature

Jon Skeet - <skeet@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

Reply to this Message

William Ryan eMVP - 30 Jun 2004 14:44 GMT

You seem to be using RowFilter and RowStateFilter interchangeable and they
aren't. I have some examples in my Efficiently using ADO.NET xxx articles
http://www.knowdotnet.com/articles/dataviews1.html Anyway, I'm not sure how
you are declaring the view b/c this is very stable in my experience.
Without seeing the code, it's impossible to tell you what's wrong. I'm
guessing that you may be setting one filter so when the other is set, you
are getting something other than what you expect - but this is just a guess.
Post the code and that should shed some light on the situation.

Signature

W.G. Ryan, eMVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

> I have a DataView where I am trying to use "rowfilter" property to get a

subset of base table rows. When my View gets created any rows which have
"modified" or "added" row state are not returned in DataView although they
satisfy my filter condition. I have tried to use all possible combinations
of "DataViewRowState" enumeration values but nothing seems to be able to
force returned DataView to include modified or added status rows. Has any
body seen such behavior before or can any body think of any thing why it
could be happening?

Reply to this Message

Cor Ligthert - 30 Jun 2004 14:54 GMT

Hi Bill,

That is as Jon wrote, I am currious as well for this one.

:-)

Cor

Reply to this Message

Bizarre behavior of DataView

Free Magazines