DataTable.Select DateTime problem

G

Guest

DataTable.Select DateTime problem


Hello,
i am using the select method on a datatable to obtain rows that correspond
to a range of dates.

The application works fine under some regional settings in windows xp:
English(USA) and French(Canada) but fails to work the i select French(France)
from the control panel.

i am using visual studio .net 2003 (vb.net, .net framework 1.1)

I isolated a bit of code that goes like this :
DataSetBills.myDataTable.Locale = CultureInfo.CurrentCulture
Dim FilterExpression As String
FilterExpression = "((CreationDate >= #" + DateMonday.ToString("d",
DataSetBills.myDataTable.Locale) + "# and CreationDate <= #" +
DateSunday.ToString("d", DataSetBills.myDataTable.Locale) + "#)"
'this line causes problems:

DataSetBills.myDataTable.DefaultView.RowFilter = FilterExpression

When i check the objects in the quickwatch windows they seem to have the
same shortdatepattern format but the thing still raises the same exception.

It works when i replace the first line with :
DataSetBills.myDataTable.Locale =
System.Globalization.CultureInfo.InvariantCulture

I don't understand what is going on.

My code was first like this (and it worked) :
DataSetBills.myDataTable.Locale = CultureInfo.CurrentCulture
Dim FilterExpression As String
FilterExpression = "((CreationDate >= #" + DateMonday.ToString + "# and
CreationDate <= #" + DateSunday.ToString + "#)"
'this line causes problems:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with DataTable.Select 3
DataBinder.Eval prob using DataTable.Select() as datasource 3
DataTable.Select problem in ASP.NET 2.0 1
Datatable.select 1
DataTable.Select method in .NET 2.0 3
Failed to convert parameter value from a String to a DateTime 9
DateTIme help 2
DateTime from Database 1

Top