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

u can insert in table like this

'1/1/2001 12:00:00 AM'

month/day/year hour:minutes:seconds AM/PM

I do not know other format.

On Jan 17, 3:58*pm, "Tamer Ibrahim" <t.ge...@gmail.com> wrote:
> Hi,
> I have two different text boxes. One is for reading user input date and the
> other is for reading user input time.I'm using SQL 2005.
> How can concatenate both of the two fields and send them as one data value
> to be saved in a datetime field in the database?

"Tamer Ibrahim" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

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

If e.g. the first TextBox contained "17 Jul 2008" and the second contained
"08:15"

Convert.ToDateTime(TextBox1.Text + " " + TextBox2.Text);


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

<(E-Mail Removed)> wrote in message
news:0fe9b3eb-6f6d-4349-a0e6-(E-Mail Removed)...

> You can insert in table like this
>
> '1/1/2001 12:00:00 AM'

That it an ambiguous date format and should not be used...

E.g. '3/9/2001 12:00:00 AM" will be interpreted as either 3rd September or
9th March depending on the SQL Server settings and/or locale of the server
machine...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

I don't think it should be sent as string and parsed by SQL server, it's
safer to convert it to DateTime and passing as SqlDbType.DateTime (4 byte
number) as you showed in your second reply.

Regards
--
Milosz


"Mark Rae [MVP]" wrote:

> <(E-Mail Removed)> wrote in message
> news:0fe9b3eb-6f6d-4349-a0e6-(E-Mail Removed)...
>
> > You can insert in table like this
> >
> > '1/1/2001 12:00:00 AM'
>
> That it an ambiguous date format and should not be used...
>
> E.g. '3/9/2001 12:00:00 AM" will be interpreted as either 3rd September or
> 9th March depending on the SQL Server settings and/or locale of the server
> machine...
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net
>
>