PC Review


Reply
Thread Tools Rate Thread

dataview.rowfilter using relations

 
 
pmcguire
Guest
Posts: n/a
 
      16th Oct 2008
I have a dataset with 3 tables -- 2 Parent tables and 1 table that is a child
table of both the parents. I create a dataview on the child table and set
the rowfilter to a value which filters the child based on values in both
parent tables. When I edit the parent tables the edit is not reflected in
the dataview.count property. How can I force the dataview to refresh
following parent table edits?

For example:

Parent1
Parent1ID Included Selected
1 0 0
2 0 0

Parent2
Parent2ID Included Selected
1 0 0
2 0 0

Child
ParentID1 ParentID2 Value
1 1 foo1
1 2 foo2
2 1 foo3
2 2 foo4

dv = new dataview(child)
dv.rowfilter="Parent(Parent1Child).Included = True AND
Parent(Parent1Child).Selected = True AND Parent(Parent2Child).Included = True
AND Parent(Parent2Child).Selected = True)"
dv.count = 0

I edit Parent1 so that Parent1ID 1 is both in included and selected and
Parent2 so that Parent2ID 2 is both included and selected.
dv.count is still 0. Why?
--
Pat
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
dataview.rowfilter using relations pmcguire Microsoft VB .NET 3 20th Oct 2008 06:29 PM
Dataview.Rowfilter help s26f84@gmail.com Microsoft Dot NET Framework Forms 3 18th Oct 2006 02:25 AM
Dataview RowFilter =?Utf-8?B?Um9iZXJ0IFBmZWZmZXI=?= Microsoft ADO .NET 6 8th Oct 2004 08:30 AM
DataView RowFilter Ryan Moore Microsoft ASP .NET 2 30th Jul 2004 11:11 PM
RowFilter in a dataview Martin Microsoft VB .NET 0 23rd Feb 2004 10:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:24 PM.