You can use a DataView instead of the DataTable

System.Data.DataTable dt = Node.GetCurrent().ChildrenAsTable();
System.Data.DataView dv = new System.Data.DataView(dt);
dv.RowFilter = "YOUR FILTER EXPRESSION";
// Bind the DataView to the DropDown

hth, Thomas

If the EventDate is held as a date - can I filter like this:

    dv.RowFilter = "[EventDate] > " + DateTime.Today.ToString();

hmmm cant seem to get the date filtering working..

// [Date] = The name of the field , not the alias as required.

dv.RowFilter = "[Date] > " + DateTime.Today.ToString();

dv.RowFilter = "[Date] > '" + DateTime.Today.ToString() + "'";

None of these work.. any ideas? The datatype for the [Date] field is date datatype. Needs to work irrespective of date/international settings of server.

I think you could do something like this:

dv.RowFilter = String.Format(CultureInfo.InvariantCulture.DateTimeFormat,
                     "Date = #{0}#", DateTime.Today.ToString());

Thanks,
Nik

is working on a reply...