hello,

i am using the following commands.

dim dt as sqlparameter("@date",sqldbtype.datetime)
dt.value=txtdt.date
dt.direction=parameterdirection.input
cmd.parameters.add(dt)

i am getting a data from textbox and i am passing the values to sql database.in the sqldatabase parameter"@date" is declared as "datatime". when i am working with this code i am getting an error "http:500":unable to run scripts.

 so i thought i am taking a string value from textbox and i have to convert it into date value.am i correct?if yes please tell me how to convert string values to datetime values.

   if no please tell me what i have to do.

thanks in advance-Ashok Parchuri

Hi there,

Just because you're entering a date in the textbox, doesn't mean the textbox gets a Date property. You need to use its Text property instead:

dt.value = txtdt.Text
dt.direction = parameterdirection.input

You can also cast the text to a valid date using methods on the Convert class.

Alternatively, you could use a Calendar control....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi

I am using vb.net in windows xp home edition. when i wish to create a new asp.net web application from vb.net, the error shows "web access failed from root directory wwwroot"

Please help me how to create a asp.net web application.

Thanx.

M.Jaffar

What exactly does this have to do with passing date time values to sql ?

I think you're better off posting a new thread in a more appropriate forum like http://p2p.wrox.com/forum.asp?FORUM_ID=97 or http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/

Cheers,

Imar

ashokparchuri,

personally I use DateTime instead of a string for working on date column,it could be better!

for casting a text to a valid date use Parse method of DateTime and handle the exceptions.

_____________
Mehdi.
software student.