rowfilter

[IGotYourDotNet]

I know how to filter on 1 row from the dataset using a dataview.
How can i filter on 2 rows being returned?

example:
i need to only display
data1.value > 0 and <= 25
data2.value > 0 and <= 25.

is there anyway to do this

[Davide Vernole [MVP]]

IGotYourDotNet <IG************@discussions.microsoft.com> typed:

I know how to filter on 1 row from the dataset using a dataview.
How can i filter on 2 rows being returned?

example:
i need to only display
data1.value > 0 and <= 25
data2.value > 0 and <= 25.

is there anyway to do this

Try this:

myDataView.RowFilter = "(data1 > AND data1 <= 25) AND (data2 > AND data2 <=
25)";

where data1 and data2 are ColumnName

See this link for more info about Expression syntax in RowFilter property:
http://msdn.microsoft.com/library/de...ssiontopic.asp

--
Davide Vernole
MVP ASP/ASP.NET
Microsoft Certified Solution Developer

[Mark]

something like....

DataView.RowFilter = "[data1] > 0 AND [data2] > 0 AND [data1] <= 25 AND
[data2] <= 25";

mark
www.dovetaildatabases.com

"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:B0**********************************@microsof t.com...

I know how to filter on 1 row from the dataset using a dataview.
How can i filter on 2 rows being returned?

example:
i need to only display
data1.value > 0 and <= 25
data2.value > 0 and <= 25.

is there anyway to do this

[Karl]

your dataview's row filter supports the AND and OR keyword..

"how can I filter on 2 rows being returned" do you mean 2 tables? where one
is called Data1 and the other is called Data2? Assuming that's what you
mean, you can create a DataRelation..

something like:
ds.Relations.Add(new DataRelation("Data1ToData2",
ds.Tables("Data1").Columns("ParentColumn"),
ds.Tables("Data2").Columns("ChildColumn"))

Dim dv As DataView = ds.Tables("Data1").DefaultView
dv.RowFilter = "Value > 0 and Value < 25 AND Child.Value > 0AND
Child.Value < 25"

now that's just off the top of my head, but look into datarelations and the
MS-Help for Data expressions:
ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpref/html/frlrfsystemdatadat
acolumnclassexpressiontopic.htm

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"IGotYourDotNet" <IG************@discussions.microsoft.com> wrote in message
news:B0**********************************@microsof t.com...

I know how to filter on 1 row from the dataset using a dataview.
How can i filter on 2 rows being returned?

example:
i need to only display
data1.value > 0 and <= 25
data2.value > 0 and <= 25.

is there anyway to do this

[Davide Vernole [MVP]]

Davide Vernole [MVP] <da****@online.knodev.com> typed:

Try this:

myDataView.RowFilter = "(data1 > AND data1 <= 25) AND (data2 > AND
data2 <= 25)";

Ops ! A little mistake :-D. This sould be correct ;-)

myDataView.RowFilter = "(data1 > 0 AND data1 <= 25) AND (data2 > 0 AND data2
<= 25)";

--
Davide Vernole
MVP ASP/ASP.NET
Microsoft Certified Solution Developer