Sending command with DateTime

[Steffen Loringer]

Hi,

I'm using SQLCmd = New SqlClient.SqlCommand and then
SQLCommand.CommandType = CommandType.Text

My problem is as follows: I like to update a table in SQL Server with a
column of the type DateTime.
so I used "UPDATE MyTable SET TheTime=" & ActualTime.ToString. But it's
not working. What is the way to send a DateTime datatype to SQL Server??

Thanks a lot

Steffen

[Anatoly]

1) Use parameter

sqlcmd.Parameters.Add([param name], sqldbtype.DateTime).Value = MyDate

2) Cast datetime to 'yyyyMMdd' format

"Update ... set TheTime = " & ActualTime.toString('yyyyMMdd')

HTH

"Steffen Loringer" <st**************@freenet.de> wrote in message
news:c0*************@ID-220178.news.uni-berlin.de...

Hi,

I'm using SQLCmd = New SqlClient.SqlCommand and then
SQLCommand.CommandType = CommandType.Text

My problem is as follows: I like to update a table in SQL Server with a
column of the type DateTime.
so I used "UPDATE MyTable SET TheTime=" & ActualTime.ToString. But it's
not working. What is the way to send a DateTime datatype to SQL Server??

Thanks a lot

Steffen

[Martin Dechev]

Hi, Steffen Loringer,

You should use parameters to avoid problems:

http://msdn.microsoft.com/library/en...etersTopic.asp

Hope this helps
Martin
"Steffen Loringer" <st**************@freenet.de> wrote in message
news:c0*************@ID-220178.news.uni-berlin.de...

Hi,

I'm using SQLCmd = New SqlClient.SqlCommand and then
SQLCommand.CommandType = CommandType.Text

My problem is as follows: I like to update a table in SQL Server with a
column of the type DateTime.
so I used "UPDATE MyTable SET TheTime=" & ActualTime.ToString. But it's
not working. What is the way to send a DateTime datatype to SQL Server??

Thanks a lot

Steffen