"Arithmetic overflow error converting expression to data type datetime" error

[Saso Zagoranski]

Hi!

I have created an SqlCommand object and I have set some parameters to it...
One of the parameters is of the DateTime type;

here is the code:
sqlCommand.Parameters[0].Value = DateTime.Parse(this.DateTextBox.Text);
sqlCommand.ExecuteNonReader();

I get the error:
Arithmetic overflow error converting expression to data type datetime

thanks,
saso

[Saso Zagoranski]

Hi!

What is in this.DataTextBox.Text
DateTextBox is just a TextBox where the user enters a date (dd/mm/yy)...
the same thing happens if I enter DateTime.Now insted... I still get the
same error...
"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in message
news:bp**********@planja.arnes.si... Hi!

I have created an SqlCommand object and I have set some parameters to it... One of the parameters is of the DateTime type;

here is the code:
sqlCommand.Parameters[0].Value = DateTime.Parse(this.DateTextBox.Text);
sqlCommand.ExecuteNonReader();

I get the error:
Arithmetic overflow error converting expression to data type datetime

thanks,
saso

[Peter Koen]

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in news:bp85pd$93l
$[e-mail]:

Hi!

What is in this.DataTextBox.Text

DateTextBox is just a TextBox where the user enters a date (dd/mm/yy)...
the same thing happens if I enter DateTime.Now insted... I still get the
same error...

And you are sure you aren't using us-time format? (mm/dd/yyyy)

this error usualy happens if you are entering dates with the wrong
formating.

greets
Peter

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

[Saso Zagoranski]

how can I check, which format I'm using?

saso

"Peter Koen" <koen-newsreply&snusnu.at> wrote in message
news:uH**************@TK2MSFTNGP11.phx.gbl...

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in news:bp85pd$93l $[e-mail]:

Hi!

What is in this.DataTextBox.Text

DateTextBox is just a TextBox where the user enters a date (dd/mm/yy)...
the same thing happens if I enter DateTime.Now insted... I still get the
same error...

And you are sure you aren't using us-time format? (mm/dd/yyyy)

this error usualy happens if you are entering dates with the wrong
formating.

greets
Peter

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

[Saso Zagoranski]

although I just tried entering this date: 1.1.2003
this should be parsed no matter the format, right?

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in message
news:bp**********@planja.arnes.si...

how can I check, which format I'm using?

saso

"Peter Koen" <koen-newsreply&snusnu.at> wrote in message
news:uH**************@TK2MSFTNGP11.phx.gbl...

"Saso Zagoranski" <sa*************@guest.arnes.si> wrote in

news:bp85pd$93l

$[e-mail]:

Hi!

> What is in this.DataTextBox.Text

DateTextBox is just a TextBox where the user enters a date (dd/mm/yy)... the same thing happens if I enter DateTime.Now insted... I still get the same error...

And you are sure you aren't using us-time format? (mm/dd/yyyy)

this error usualy happens if you are entering dates with the wrong
formating.

greets
Peter

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------