Using RowFilter to filter dataview within DateTime values in a Dataset

Posted on 2009-02-16
Last Modified: 2013-11-07
Hello Experts,

Using VS 2008
Windows Forms (not ASP.NET)

I am trying to filter a dataview based on Datetime values within a Dataset. For some reason I am not coming up with any matches when I should be. I am using the values of 2 DateTimePickers for my date ranges. I have even tried removing the DateTimePickers and hard coding in values that I know exist within the dataset still with no luck. See code below. Any ideas on what I am doing wrong? It appears as though I am just using the method incorrectly?

Thanks in advance.

//Define my variables to be used in the search. these are my 2 DateTimePickers. I have tried leaving off the "ToString()" method and leaving the variables as DateTime, also with no luck

string begin = dateTimeLater.Value.ToString("M/dd/yyyy 00:00");

string end = dateTimeEarlier.Value.ToString("M/dd/yyyy 23:59"); 

// At this point I have used a Messagebox to display the values of begin and end. They are correct.

//Create my dataview - this also works fine.

DataView gridView = new DataView(reserveTrackerDataSet.Tables["Authorizations"]);

//Try and filter gridview - THIS RETURNS NO MATCHES. I have verified that there is data in the dataset that DOES match the filter criteria, yet nothing is returned.  FYI - Date is of type DateTime in the dataset.

gridView.RowFilter = "Date IN (#" + begin + "#, #" + end + "#)";

//I have also hardcoded the date values directly in my RowFilter statement to determine if my variables were the problem like below, but still NO MATCHES even thou data in the dataset should match.

gridView.RowFilter = "Date IN (#1/01/2009 00:00#, #2/16/2009 23:59#)";

Open in new window

Question by:kalittaair
    LVL 22

    Expert Comment


    Is it a Access db you're connecting to? If it's SQL server you should write
    gridView.RowFilter = "Date IN ('1/01/2009 00:00', '2/16/2009 23:59')";
    Also this construct only match those particular dates. begin and end sounds like an interval, in that case you could use "Date BETWEEN '1/01/2009 00:00' AND '2/16/2009 23:59'".


    Author Comment


    Thanks for your reply. Yes, it is a SQL 2005 DB I am accessing. However, when using:
    gridView.RowFilter = "Date BETWEEN ('1/01/2009 00:00' AND '2/16/2009 23:59')";
    I get:
    "The expression contains unsupported operator 'Between'."

    I tried removing the parathesis like in your example. Still no luck.


    Accepted Solution

    Thanks for trying but I figured it out.

    gridView.RowFilter = "Date >= #" + begin + "# AND Date <= #" + end + "#";


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In my previous article ( we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
    A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now