Problems converting a string to SQLDateTime

[damon.f]

I've got a classic ASP application that I'm migrating
to .NET. In the client script we used to use the
following code to help build up the sql string. It
converted a text date to the SQL Server Date format.

sSQL = sSQL + SQLServerDate(R equest.Form
("PLANNEDEXITDA TE")) + ","

I'm now trying to do this server side in VB.NET but I
can't seem to find a way to do it using convert or
CType. They all complain they cannot convert strings to
sqldatetime format. Also there seems to be no conversion
to a plain SQLServerDate.

mydate = CType(Convert.T oDateTime(PLANN EDEXITDATE),
SqlTypes.SqlDat eTime)

I'm sure this is really simple but it's eluding me at
present. Does any one have an idea?

Thanks

Damon

[Munsifali Rashid]

You should just be able to do:

Dim myDate As SqlDateTime =
Convert.ToDateT ime(Request.For m("PLANNEDEXITD ATE"))

What's the error you get when using your original code?

Regards,

Mun

--
Munsifali Rashid
http://www.munsplace.com/

"damon.f" <da*****@nospam .com> wrote in message
news:03******** *************** *****@phx.gbl.. .

I've got a classic ASP application that I'm migrating
to .NET. In the client script we used to use the
following code to help build up the sql string. It
converted a text date to the SQL Server Date format.

sSQL = sSQL + SQLServerDate(R equest.Form
("PLANNEDEXITDA TE")) + ","

I'm now trying to do this server side in VB.NET but I
can't seem to find a way to do it using convert or
CType. They all complain they cannot convert strings to
sqldatetime format. Also there seems to be no conversion
to a plain SQLServerDate.

mydate = CType(Convert.T oDateTime(PLANN EDEXITDATE),
SqlTypes.SqlDat eTime)

I'm sure this is really simple but it's eluding me at
present. Does any one have an idea?

Thanks

Damon

[damon.f]

I've tried to use that converstion but it didn't work.

Interestingly I've just used DateTime.Parse( ) and that is
excepted!

My final line is:

sqlCmd.Paramete rs.Add(New SqlClient.SqlPa rameter
("@a_dtPlannedE xitDate",
System.Data.Sql DbType.DateTime )).Value = DateTime.Parse
(PLANNEDEXITDAT E)

Thanks for your effort

Damon

-----Original Message-----
You should just be able to do:

Dim myDate As SqlDateTime =
Convert.ToDate Time(Request.Fo rm("PLANNEDEXIT DATE"))

What's the error you get when using your original code?

Regards,

Mun

--
Munsifali Rashid
http://www.munsplace.com/

"damon.f" <da*****@nospam .com> wrote in message
news:03******* *************** ******@phx.gbl. ..

I've got a classic ASP application that I'm migrating
to .NET. In the client script we used to use the
following code to help build up the sql string. It
converted a text date to the SQL Server Date format.

sSQL = sSQL + SQLServerDate(R equest.Form
("PLANNEDEXITDA TE")) + ","

I'm now trying to do this server side in VB.NET but I
can't seem to find a way to do it using convert or
CType. They all complain they cannot convert strings to sqldatetime format. Also there seems to be no conversion to a plain SQLServerDate.

mydate = CType(Convert.T oDateTime(PLANN EDEXITDATE),
SqlTypes.SqlDat eTime)

I'm sure this is really simple but it's eluding me at
present. Does any one have an idea?

Thanks

Damon

.