DataView.RowFilter an ISO8601

Posted by Ryan on Stack Overflow See other posts from Stack Overflow or by Ryan
Published on 2010-01-16T03:49:56Z Indexed on 2010/05/05 2:08 UTC
Read the original article Hit count: 321

Filed under:

datatable

|

rowfilter

|

c#

|

iso8601

I have a DataTable (instance named: TimeTable) whose DefaultView (instance named: TimeTableView) I am trying to use to filter based on a date. Column clock_in contains an ISO8601 formatted string. I would like to select all the rows in this DataTable/DefaultView between 2009-10-08T08:22:02Z and 2009-10-08T20:22:02Z.

What would I have to filter on this criteria? I tried:

TimeTableView = TimeTable.DefaultView;    
TimeTableView.RowFilter = "clock_in >= #2009-10-08T08:22:02Z# and #2009-10-08T20:22:02Z#";

This is not working for me. Am I operating on the wrong object or is my filter syntax wrong?

© Stack Overflow or respective owner

Related posts about datatable

DataView.RowFilter Vs DataTable.Select() vs DataTable.Rows.Find()

as seen on Stack Overflow - Search for 'Stack Overflow'
Considering the code below: Dataview someView = new DataView(sometable) someView.RowFilter = someFilter; if(someView.count > 0) { …. } Quite a number of articles which say Datatable.Select() is better than using DataViews, but these are prior to VS2008. Solved: The Mystery of DataView's Poor… >>> More
How to correctly filter a datatable (datatable.select)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothing(da) Then da.Fill(dt) dt.Select("GroupingID = 0") End If GridView1.DataSource = dt GridView1.DataBind() c.Close() When I call da.fill I am… >>> More
How to obtain a random sub-datatable from another data table

as seen on Developer IT - Search for 'Developer IT'
Introduction In this article, I’ll show how to get a random subset of data from a DataTable. This is useful when you already have queries that are filtered correctly but returns all the rows. Analysis I came across this situation when I wanted to display a random tag cloud. I already had the… >>> More
How can we copy the column data of one datatable to another,even if there is different column names

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two datatables. First is DataTable NameAdressPhones = new DataTable(); with Three columns Name,Adress and PhoneNo.But I want only two columns Name and Adress data so I am copy those columns (with data) to the new datatable DataTable NameAdress = new DataTable(); For that I do … >>> More
Difference between DataTable.Load() and DataTable = dataSet.Tables[];

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All , I have a doubt i use the following piece of code get data from a SQLlite data base and Load it into a data table "SQLiteConnection cnn = new SQLiteConnection("Data Source=" + path); cnn.Open(); SQLiteCommand mycommand = new SQLiteCommand(cnn); string… >>> More

Related posts about rowfilter

RowFilter including [ character in search string

as seen on Stack Overflow - Search for 'Stack Overflow'
I fill a DataSet and allow the user to enter a search string. Instead of hitting the database again, I set the RowFilter to display the selected data. When the user enters a square bracket ( "[" ) I get an error "Error in Like Operator". I know there is a list of characters that need prefixed with… >>> More
RowFilter.regexFilter multiple columns

as seen on Stack Overflow - Search for 'Stack Overflow'
I am currently using the following to filter my JTable RowFilter.regexFilter( Pattern.compile(textField.getText(), Pattern.CASE_INSENSITIVE).toString(), columns ); How do I format my textField or filter so if I want to filter multiple columns I can do that. Right now I can… >>> More
DataView.RowFilter an ISO8601

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a DataTable (instance named: TimeTable) whose DefaultView (instance named: TimeTableView) I am trying to use to filter based on a date. Column clock_in contains an ISO8601 formatted string. I would like to select all the rows in this DataTable/DefaultView between 2009-10-08T08:22:02Z and 2009-10-08T20:22:02Z… >>> More
Filtering by date with DataTable.RowFilter while ignoring time

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I filter for records on a DataTable which are on a certain date? I've tried plain [datecol] = #11 March 2010# and CONVERT([datecol],'System.DateTime') = #11 March 2010#. With no luck. MSDN: RowFilter Expression Syntax Solution [datecol] >= #11 March 2010 00:00# AND [datecol] <= #11… >>> More
How can I filter a JTable?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to filter a JTable, but I don't understand how I can do it. I have read How to Use Tables - Sorting and Filtering and I have tried with the code below, but with that filter, no rows at all is shown in my table. And I don't understand what column it is filtered on. private void myFilter()… >>> More