convert date to string ?

[harshad taylor]

hi all. i am a fairly new user of vb .net. i need to know how to convert
the date (possibly to a string maybe)that a user chooses from a
"datetime picker" and take that value into a variable and pass it to an
sql query. it might be something very simple but i dont have a clue.

thanks.

 

[Herfried K. Wagner [MVP]]

hi all. i am a fairly new user of vb .net. i need to know how to convert
the date (possibly to a string maybe)that a user chooses from a
"datetime picker" and take that value into a variable and pass it to an
sql query. it might be something very simple but i dont have a clue.

Have a look at its 'ToString' method.

 

[Armin Zingler]

hi all. i am a fairly new user of vb .net. i need to know how to
convert the date (possibly to a string maybe)that a user chooses from
a "datetime picker" and take that value into a variable and pass it
to an sql query. it might be something very simple but i dont have a
clue.

Have a look at the SQLCommand.Parameters property. If you use it, you won't
need to convert the value on your own.


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html