Hi,

I am new with ASP.NET. I want to use DatePicker in a detailsview in Edit Template Field. This is my code:

<asp:TemplateField HeaderText="Payment Date">
<EditItemTemplate>
<eo:DatePicker ID="DatePicker2" runat="server"
DisabledDates="" SelectedDates="">
</eo:DatePicker>
</EditItemTemplate
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("pfpaymentdate") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("pfpaymentdate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

Please see the above Red marked code. I want to bind the field with "pfpaymentdate" which is a data field. But I cannot bind because there is no "Text" Attribute in DatePicker.

Please help me out.

Hi,

What will be the update command? My code are below. Its not working.

Update Parameters:
<UpdateParameters>
<asp:QueryStringParameter Name="cid" QueryStringField="cid" DefaultValue="" ConvertEmptyStringToNull="True" />
<asp:Parameter Name="DatePicker2" Type="DateTime" />
</UpdateParameters>

Update Command:

UpdateCommand = "update pf_master set pfpaymentdate = @DatePicker2 where employeeid = @cid"

Help me out.