Filtering a dataview

[IndyChris]

I have DataView of DataSet. I want to filter the DataView by the date.
dvEvents.RowFilter = "BegDate >= '" + dateTimePicker1.Value.Date + "'
BegDate <= '" + dateTimePicker2.Value.Date.AddDays(1) + "'";

My problem is that the filter is getting the wrong values.
dateTimePicker1.Value = 8/2/2006
dateTimePicker2.Value = 8/3/2006

You would only expect records with 8/2 or 8/3 to show up. I'm getting
all records that are 8/2 and 8/2X.

How can I prevent the records that shouldn't be showing up from showing
up?

Thanks!

[Nicholas Paldino [.NET/C# MVP]]

Indy,

You don't want to use a string representation. Rather, use '#' to
delimit your dates, like so:

dvEvents.RowFilter = "BegDate >= #" + dateTimePicker.Value.Date ...

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"IndyChris" <ch***********@yahoo.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

>I have DataView of DataSet. I want to filter the DataView by the date.
dvEvents.RowFilter = "BegDate >= '" + dateTimePicker1.Value.Date + "'
BegDate <= '" + dateTimePicker2.Value.Date.AddDays(1) + "'";

My problem is that the filter is getting the wrong values.
dateTimePicker1.Value = 8/2/2006
dateTimePicker2.Value = 8/3/2006

You would only expect records with 8/2 or 8/3 to show up. I'm getting
all records that are 8/2 and 8/2X.

How can I prevent the records that shouldn't be showing up from showing
up?

Thanks!

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

try:
dvEvents.RowFilter = "BegDate >= '" +
dateTimePicker1.Value.Date.ToShortDateString() + "'
BegDate <= '" + dateTimePicker2.Value.Date.AddDays(1)ToShortDateSt ring() +
"'";

Why you have two datetimepickers? if so the upper bound should be compared
to dateTimePicker2.Value
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"IndyChris" <ch***********@yahoo.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

>I have DataView of DataSet. I want to filter the DataView by the date.
dvEvents.RowFilter = "BegDate >= '" + dateTimePicker1.Value.Date + "'
BegDate <= '" + dateTimePicker2.Value.Date.AddDays(1) + "'";

My problem is that the filter is getting the wrong values.
dateTimePicker1.Value = 8/2/2006
dateTimePicker2.Value = 8/3/2006

You would only expect records with 8/2 or 8/3 to show up. I'm getting
all records that are 8/2 and 8/2X.

How can I prevent the records that shouldn't be showing up from showing
up?

Thanks!