or
Hi,
I am using a RadDatePicker Control on my page. I have to calculate the difference in weeks between the date selected in this RadDatePicker Control and Current Date (i.e Today's Date). I have to display this difference (in weeks) inside a textbox on selecting a date from the RadDatePicker Control. How can I do this ?
I have used the following html code for RadDatePicker Control in my application :-
| <telerik:RadDatePicker ID="dtDate" runat="server" DateInput-DateFormat="dd/MM/yyyy" Width="120px" Skin="WebBlue"> |
| <DateInput DateFormat="dd/MM/yyyy" LabelCssClass="radLabelCss_WebBlue" Skin="WebBlue" runat="server" ID="DateInput6" > |
| </DateInput> |
| <Calendar Skin="WebBlue" Width="50px" Height="50px"> |
| </Calendar> |
| <DatePopupButton CssClass="radPopupImage_WebBlue" /> |
| </telerik:RadDatePicker> |
Thanks
| <telerik:RadGrid ID="rgHydrantsMaintenance" runat="server" | |
| DataSourceID="dsHydrantsMaintenance" Height="100%" BorderWidth="0px" AllowSorting="True" | |
| Style="outline: none" ShowGroupPanel="True" GridLines="None"> | |
| <ClientSettings Scrolling-AllowScroll="True" Scrolling-UseStaticHeaders="true" Selecting-AllowRowSelect="true" | |
| EnablePostBackOnRowClick="true" AllowDragToGroup="true" EnableRowHoverStyle="true"> | |
| <Selecting AllowRowSelect="True" /> | |
| <Scrolling AllowScroll="True" UseStaticHeaders="True" /> | |
| </ClientSettings> | |
| <MasterTableView AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AutoGenerateColumns="False" | |
| TableLayout="Fixed" GroupLoadMode="Client" CommandItemDisplay="Top" DataKeyNames="ID" | |
| DataSourceID="dsHydrantsMaintenance"> | |
| <RowIndicatorColumn> | |
| <HeaderStyle Width="20px" /> | |
| </RowIndicatorColumn> | |
| <ExpandCollapseColumn> | |
| <HeaderStyle Width="20px" /> | |
| </ExpandCollapseColumn> | |
| <EditFormSettings> | |
| <EditColumn UniqueName="EditCommandColumn" ButtonType="ImageButton" CancelImageUrl="~/images/decline.png" | |
| UpdateImageUrl="~/images/add.png" InsertImageUrl="~/images/add.png"> | |
| </EditColumn> | |
| </EditFormSettings> | |
| <Columns> | |
| <telerik:GridBoundColumn DataField="ID" DataType="System.Int32" HeaderText="ID" ReadOnly="True" | |
| SortExpression="ID" UniqueName="ID" Visible="False"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="hID" DataType="System.Int32" HeaderText="Hydrant ID" | |
| SortExpression="hID" UniqueName="hID"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Date" DataType="System.DateTime" HeaderText="Date" | |
| SortExpression="Date" UniqueName="Date"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridBoundColumn DataField="Work_Performed" HeaderText="Work_Performed" SortExpression="Work_Performed" | |
| UniqueName="Work_Performed"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridDropDownColumn DataSourceID="dsOperators" DataField="ID" ListTextField="Operator" ListValueField="ID" UniqueName="Operator" DataType="System.Int32" HeaderText="Operator" | |
| SortExpression="Operator" ForceExtractValue="Always"> | |
| </telerik:GridDropDownColumn> | |
| <%-- <telerik:GridBoundColumn DataField="Operator" DataType="System.Int32" HeaderText="Operator" | |
| SortExpression="Operator" UniqueName="Operator"> | |
| </telerik:GridBoundColumn>--%> | |
| <telerik:GridBoundColumn DataField="Notes" HeaderText="Notes" SortExpression="Notes" | |
| UniqueName="Notes"> | |
| </telerik:GridBoundColumn> | |
| <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderText="Edit" UniqueName="Edit" HeaderStyle-Width="20px" ItemStyle-Width="20px"> | |
| </telerik:GridEditCommandColumn> | |
| </Columns> | |
| </MasterTableView></telerik:RadGrid><asp:SqlDataSource ID="dsHydrantsMaintenance" | |
| runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:csWIRMS %>" | |
| DeleteCommand="DELETE FROM [maint_Hydrants] WHERE [ID] = @original_ID AND [hID] = @original_hID AND (([Date] = @original_Date) OR ([Date] IS NULL AND @original_Date IS NULL)) AND (([Work_Performed] = @original_Work_Performed) OR ([Work_Performed] IS NULL AND @original_Work_Performed IS NULL)) AND (([Operator] = @original_Operator) OR ([Operator] IS NULL AND @original_Operator IS NULL)) AND (([Notes] = @original_Notes) OR ([Notes] IS NULL AND @original_Notes IS NULL))" | |
| InsertCommand="INSERT INTO [maint_Hydrants] ([hID], [Date], [Work_Performed], [Operator], [Notes]) VALUES (@hID, @Date, @Work_Performed, @Operator, @Notes)" | |
| OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [maint_Hydrants] WHERE ([hID] = @hID) ORDER BY [Date]" | |
| UpdateCommand="UPDATE [maint_Hydrants] SET [hID] = @hID, [Date] = @Date, [Work_Performed] = @Work_Performed, [Operator] = @Operator, [Notes] = @Notes WHERE [ID] = @original_ID"> | |
| <SelectParameters> | |
| <asp:ControlParameter ControlID="rgHydrants" Name="hID" PropertyName="SelectedValue" | |
| Type="Int32" /> | |
| </SelectParameters> | |
| <DeleteParameters> | |
| <asp:Parameter Name="original_ID" Type="Int32" /> | |
| <asp:Parameter Name="original_hID" Type="Int32" /> | |
| <asp:Parameter DbType="DateTime" Name="original_Date" /> | |
| <asp:Parameter Name="original_Work_Performed" Type="String" /> | |
| <asp:Parameter Name="original_Operator" Type="Int32" /> | |
| <asp:Parameter Name="original_Notes" Type="String" /> | |
| </DeleteParameters> | |
| <UpdateParameters> | |
| <asp:Parameter Name="hID" Type="Int32" /> | |
| <asp:Parameter DbType="DateTime" Name="Date" /> | |
| <asp:Parameter Name="Work_Performed" Type="String" /> | |
| <asp:Parameter Name="Operator" Type="Int32" /> | |
| <asp:Parameter Name="Notes" Type="String" /> | |
| <asp:Parameter Name="original_ID" Type="Int32" /> | |
| <asp:Parameter Name="original_hID" Type="Int32" /> | |
| <asp:Parameter DbType="DateTime" Name="original_Date" /> | |
| <asp:Parameter Name="original_Work_Performed" Type="String" /> | |
| <asp:Parameter Name="original_Operator" Type="Int32" /> | |
| <asp:Parameter Name="original_Notes" Type="String" /> | |
| </UpdateParameters> | |
| <InsertParameters> | |
| <asp:Parameter Name="hID" Type="Int32" /> | |
| <asp:Parameter DbType="DateTime" Name="Date" /> | |
| <asp:Parameter Name="Work_Performed" Type="String" /> | |
| <asp:Parameter Name="Operator" Type="Int32" /> | |
| <asp:Parameter Name="Notes" Type="String" /> | |
| </InsertParameters> | |
| </asp:SqlDataSource> | |
| </telerik:RadPane> | |
| </telerik:RadSplitter> <asp:SqlDataSource ID="dsOperators" runat="server" | |
| ConnectionString="<%$ ConnectionStrings:csWIRMS %>" | |
| SelectCommand="SELECT [Operator], [ID] FROM [app_Operators] WHERE ([Enabled] = @Enabled)"> | |
| <SelectParameters> | |
| <asp:Parameter DefaultValue="True" Name="Enabled" Type="Boolean" /> | |
| </SelectParameters> | |
| </asp:SqlDataSource> |
| <telerik:RadGrid ID="RadGrid1" EnableViewState="true" runat="server" AllowSorting="True" |
| AutoGenerateColumns="false" Skin="WebBlue" |
| ClientSettings-EnableRowHoverStyle="true" OnItemDataBound="RadGrid_ItemDataBound" |
| Width="718px" Height="480px" OnNeedDataSource="RadGrid1_NeedDataSource" |
| AllowPaging="false" PageSize="100" OnDataBound="rgResults_DataBound"> |
| <ClientSettings AllowColumnsReorder="False" EnablePostBackOnRowClick="True"> |
| <Resizing AllowColumnResize="true" EnableRealTimeResize="true" /> |
| <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="True" /> |
| <Selecting AllowRowSelect="True" /> |
| </ClientSettings> |
| <MasterTableView DataKeyNames="Id" ShowHeadersWhenNoRecords="false" |
| VirtualItemCount="100" ItemStyle-Font-Size="11px" |
| HeaderStyle-CssClass="gvHeader"> |
| <Columns> |
| <telerik:GridClientSelectColumn ButtonType="PushButton" Visible="False" CommandName="Select" Text="Select" UniqueName="column"> |
| </telerik:GridClientSelectColumn> |
| <telerik:GridTemplateColumn HeaderText="PIC" UniqueName="colPic"> |
| <HeaderStyle Width="27px" Font-Size="10px"/> |
| <ItemStyle Width="27px" HorizontalAlign="center" /> |
| <ItemTemplate> |
| <img alt="face" id="face" src="imageProcessor.ashx?x=<%# Eval("ID") %>" width="30" height="38" style="border:0px;"> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="FLAGS" UniqueName="colFlags"> |
| <ItemStyle Width="40px" Wrap="false" Font-Size="10px"/> |
| <HeaderStyle Width="40px" Font-Size="10px" /> |
| <ItemTemplate> |
| <asp:Label ID="lblAlerts" CssClass="flags" runat="server"></asp:Label> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="NAME" SortExpression="LastName" |
| UniqueName="colName"> |
| <ItemTemplate> |
| <asp:ImageButton runat="server" ImageUrl="~/images/icons/zoom.png" |
| ImageAlign="AbsMiddle" AlternateText="Quick Summary" ID="targetControl" /> |
| <%# Eval("LastName") + ", " + Eval("FirstName") + " " + Eval("MiddleName") %> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="ADDRESS" |
| SortExpression="StreetAddress" UniqueName="colAddress"> |
| <HeaderStyle Width="160px" /> |
| <ItemStyle Width="160px" Wrap="True" /> |
| <ItemTemplate> |
| <%# Eval("StreetAddress") %> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn HeaderText="S" DataField="Sex" HeaderStyle-Wrap="false" |
| UniqueName="colSex"> |
| <HeaderStyle Width="10px" /> |
| <ItemStyle Width="10px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="R" DataField="Race" HeaderStyle-Wrap="false" |
| UniqueName="colRace"> |
| <HeaderStyle Width="10px" /> |
| <ItemStyle Width="10px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="HGT" DataField="Height" HeaderStyle-Wrap="false" |
| HeaderStyle-Width="18px" ItemStyle-HorizontalAlign="center" UniqueName="colHeight"> |
| <HeaderStyle Width="18px" /> |
| <ItemStyle Width="18px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="WGT" DataField="Weight" UniqueName="colWeight"> |
| <HeaderStyle Width="20px" Wrap="false" /> |
| <ItemStyle Width="20px" HorizontalAlign="center"/> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="AGE" DataField="Age" UniqueName="colAge"> |
| <HeaderStyle Width="18px" Wrap="false" /> |
| <ItemStyle Width="18px" HorizontalAlign="center"/> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="DOB" DataField="Dob" AllowSorting="false" |
| ItemStyle-HorizontalAlign="center" DataFormatString="{0:d}" UniqueName="colDob"> |
| <HeaderStyle Width="52px" /> |
| <ItemStyle Width="52px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn HeaderText="ID" DataField="Id" UniqueName="colId"> |
| <HeaderStyle Width="44px" /> |
| <ItemStyle Width="44px" /> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| protected void rgResults_DataBound(object sender, EventArgs e) |
| { |
| if(bVersion < 8) |
| { |
| //PICS |
| RadGrid1.Columns[1].HeaderStyle.Width = 40; |
| RadGrid1.Columns[1].ItemStyle.Width = 40; |
| //FLAGS |
| RadGrid1.Columns[2].HeaderStyle.Width = 50; |
| RadGrid1.Columns[2].ItemStyle.Width = 50; |
| //SEX |
| RadGrid1.Columns[5].HeaderStyle.Width = 20; |
| RadGrid1.Columns[5].ItemStyle.Width = 20; |
| //RACE |
| RadGrid1.Columns[6].HeaderStyle.Width = 20; |
| RadGrid1.Columns[6].ItemStyle.Width = 20; |
| //HEIGHT |
| RadGrid1.Columns[7].HeaderStyle.Width = 30; |
| RadGrid1.Columns[7].ItemStyle.Width = 30; |
| //WEIGHT |
| RadGrid1.Columns[8].HeaderStyle.Width = 32; |
| RadGrid1.Columns[8].ItemStyle.Width = 32; |
| //AGE |
| RadGrid1.Columns[9].HeaderStyle.Width = 30; |
| RadGrid1.Columns[9].ItemStyle.Width = 30; |
| //DOB |
| RadGrid1.Columns[10].HeaderStyle.Width = 68; |
| RadGrid1.Columns[10].ItemStyle.Width = 68; |
| //ID |
| RadGrid1.Columns[11].HeaderStyle.Width = 52; |
| RadGrid1.Columns[11].ItemStyle.Width = 52; |
| } |
| } |

