how to add datetime picker in gridview.

I am having a problem with the correct dateTime.

Currently I have an application that pumps data into my Microsoft SQL 2005 database. But the dateTime that gets inserted is in the format of, 12 Oct 2010 21:30:24 GMT.

How can i change this on the Sql Database on the backend to the correct format?

        <asp:TemplateField HeaderText="Potovanje traja od - do">
<ItemTemplate> 
      <asp:Label ID="BirthDateLabel" Runat="Server" 
                 Text='<%# Bind("DnevnicaOdCas") %>' HtmlEncode="False" DataFormatString = "{0:D}"></asp:Label> - <asp:Label ID="Label9" runat="server" Text='<%# Eval("DnevnicaDoCas") %>'></asp:Label> 
    </ItemTemplate>
            <ItemStyle Width="330px" />
</asp:TemplateField>

Please help!

Hi thanx's for checking the problem.

Problem: How to implement datetimepicker(jquery) in dynamically created rows' in gridview.

I have created a Gridview,that add' rows dynamically.I have a Year column in gridview where i want to implement the datetimepicker.But failed to do so.

Help will be highly appriciated. I am attaching the code : below codes are working perfectly and rendering the datetimepicker for only ist row.but for dynamically row's its not working. If any one have done such kind please help me out.

.aspx page

<div>

<asp:GridView ID="GridViewDiploma" runat=

I went through this post http://stackoverflow.com/questions/2208480/jquery-date-picker-to-show-month-year-only which is very helpful to me in order to hack the datetime picker UI to suit my situation. But as I have several datetime picker on the same form, this happens. The css display:none is aim to 'hide' the days not to be shown. But if I have several datetime picker on the same form but only one I wish to make one of it monthpicker, how can I achieve that? With thw css, it makes all the days on the all datetime calender UI disappear since the css will change the attribute of .ui-datepicker-calendar. Any suggestions are welcome. Thanks. This is my first post.

I have an application that uses a time date picker control to display a date from a sql (sql 2000) table. Casting from the table to the control works fine, but writing a selected date from the control back to the database does not, I was under the impression that a datatype 'date' in VB would be compatible with SQL datetime datatime, and obviously it is from sql to vb as the date is correctly displayed in the control reading from the table. How do I need to convert the value from the date time picker control to write into sql ? 

I've got a row with a checkbox - - if it's checked, the DateTimePicker is enabled - if it's not checked, the DTP is disabled - - that part's working.

But, for the life of me, I haven't been able to figure out the following.

A user checks the checkbox, so the DTP is enabed
Then, he chooses a date, to populate the DTP.
Then, he changes his mind and unchecks the checkbox.
I need to remove the date that was chosen - I've tried using the 'Set a Field's value' - and left the value blank, tried adding 2 single quotes, tried adding 2 double quotes, but nothing works.

How do I remove the date from the 'textbox' portion of the DTP with a rule?