Error on passing Date parameter

[Meerakhanna]

I am getting error when debugging a project. The error is as below,


"FormatException was unhandled
String was not recognized as a valid DateTime."

Highlighting the following line

 
Me.DataTable1TableAdapter.Fill(Me.Sales.DataTable1, DateTime.ParseExact((TextBox1.Text), "MM/dd/yyyy", System.Globalization.CultureInfo.CurrentCulture), DateTime.ParseExact((TextBox2.Text), "MM/dd/yyyy", System.Globalization.CultureInfo.CurrentCulture))
 
 

Please let me know whats the wrong??

Thanks,
Meera.

[Aimee Bailey]

Problem is most likey that you have restrained the format in which date's are allowed to be parsed, using CurrentCulture can be tricky as the current culture is machine and location specifit. I'd reccomend using something more along the lines of:

Me.DataTable1TableAdapter.Fill(Me.Sales.DataTable1, DateTime.Parse((TextBox1.Text), System.Globalization.CultureInfo.InvariantCulture), DateTime.Parse((TextBox2.Text), System.Globalization.CultureInfo.InvariantCulture))
 

And use a universally formatted date like '2010-07-24 14:00'.

Best of luck!