DataView.RowFilter

[Magne Ryholt]

I need to filter a view on values from parent table, this works fine e.g.
"Parent.Name='MyFathersName'"

However, I also need to filter on grandparent and grand-grand parents
(a.s.o.) columns as well, syntax "Parent.Parent.Name='MyGrandFathersName'"
does not work (exception is thrown), any one knows how to do this ?

 

[Miha Markic [MVP C#]]

Hi Magne,

One way would be to create an expression column in each child with parent
value.
That will give you grandparent or whatever value you want.

 

[Magne Ryholt]

That will work, but is there really no way of accessing directly in the
filter ? (seems a bit starnge if not possible since Parent.Name works fine)

Hi Magne,

One way would be to create an expression column in each child with parent
value.
That will give you grandparent or whatever value you want.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

I need to filter a view on values from parent table, this works fine e.g.
"Parent.Name='MyFathersName'"

However, I also need to filter on grandparent and grand-grand parents
(a.s.o.) columns as well, syntax "Parent.Parent.Name='MyGrandFathersName'"
does not work (exception is thrown), any one knows how to do this ?