Concatenating Date and Time from two differnt fields

Hi,
I have two different text boxes. One is for reading user input date and the
other is for reading user input time.
How can concatenate both of the two fields and save them as one data value
to a datetime field in the database? I'm using SQL 2005.

RE: Concatenating Date and Time from two differnt fields

eg.
Dim x As DateTime = Convert.ToDateTime("19-Feb-2008 " + "3:45pm")

Regards
JIGNESH

"Tamer Ibrahim" wrote:

> Hi,
> I have two different text boxes. One is for reading user input date and the
> other is for reading user input time.
> How can concatenate both of the two fields and save them as one data value
> to a datetime field in the database? I'm using SQL 2005.
>
>
>