How to using diferrent dropdown for the time(c#)

[hwa]

I'm having a problem to inserting date/time in my database..

In my database have ONE column that consists of DATE and TIME

I want use separate dropdownlist for the HOUR, MINUTE, SECOND and I want to bind it & insert it to a 1 column in database..

I need to combine the DATE and this 3 dropdown and bind it and insert it into database

can anyone help me?? please...
\

Thanks in advance

[ericstenson]

build a string

dim MyDate as string = "1/1/2008"
Dim MyTime as string = dropdownlist1.selectedvalue & ":" & dropdownlist2.selectedvalue & ":" & dropdownlist3.selectedvalue & " " & dropdownlist4.selectedvalue (AM/PM)

MyDate = MyDate & " " & MyTime

Now insert MyDate into the db.

[hwa]

Hi ericstenson,

Can you how me the code in C# instead of vb??

and my db format for this field is DateTime so cannot convert STRING to DateTime format.

what should I do

Thanks