DataView.RowFilter

  • Thread starter Thread starter Magne Ryholt
  • Start date Start date
M

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 ?
 
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.
 
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)

Miha Markic said:
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

Magne Ryholt said:
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 ?
Click to expand...
Click to expand...
 
Back
Top