ASP.NET Time Picker Control

JessyRobinson1234
JessyRobinson1234 used Ask the Experts™
on
I downloaded this free tool:

http://www.asp.net/community/control-gallery/Item.aspx?i=3221#Reviews

Does anyone know how to insert the time into a database through this time selection control?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Jessy,

What database are you inserting it into?

Use .NET's formatting functions to convert it to a format that your database will accept.

Format for MySQL: YYYY-MM-DD HH:MM:SS
Format for Oracle: DD-MMM-YY HH:MM:SS
...


/sylikc

Author

Commented:
I'm using MS SQL Server 2005.

I am struggling with getting the value of the timercontrol.

me.timercontrolid. ???

Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I was able to access the control's values:

Me.Driver.Date.ToLongDateString() + ", " + Me.Driver.Date.ToLongTimeString()

Now I have a second question. How do I display this value in edit mode:

<MKB:TimeSelector ID="Driver" runat="server" DisplaySeconds="true" CssClass="form" DisplayButtons="true" MinuteIncrement="1" AllowSecondEditing="true">                        </MKB:TimeSelector>

Author

Commented:
The value would need to come from the database

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial