DateTime Conversion error

Gymnast

I am trying to retrieve the time from TableB into TableA. All it does is post the current date in the format...9/30/2007 0:00:00 What I am looking for is the time value in TableB. Here is my code..

I have made sure the datatypes in the SQL Server database matches in both the Tables.

Let me know why this is failing.

Thanks,

Gym

Scott Dorman

What is the value of startDateTextBox? Does it contain a full date and time? You might be better off storing the entire thing as a single column that holds both the start date and time or storing just the start date and the time as an offset from midnight. What was the error you got when you tried the Convert.ToDateTime call?

Scott.

—In just two days, tomorrow will be yesterday. [Forum Guidelines] [Articles] [Blog]

Gymnast

I finally got the textbox to work but when I use the same value to populate a dropdown list, it does not work. Actually, it works the first time around and after that there is apparently a postback issue. Because the page does not refresh itself and I am not able to figure out how to get that to happen. Also, there is no error message as such. In a different context, an error message in the form of a warning appears indicating an "Object instance not used" in line 290. What I don't understand to begin with, is the place to find 290 lines of code!! I couldn't find it even among the designer-gen code.