or
| using System; |
| using System.Web.UI; |
| using System.Web.UI.WebControls; |
| using Telerik.Web.UI; |
| namespace CustomControls |
| { |
| public sealed class PagerTemplatePanel : Panel, ITemplate |
| { |
| private readonly string _radGridID; |
| private Control _container; |
| public PagerTemplatePanel(string radGridID) |
| { |
| _radGridID = radGridID; |
| } |
| public void InstantiateIn(Control container) |
| { |
| _container = container; |
| } |
| public override ControlCollection Controls |
| { |
| get |
| { |
| //<asp:Panel Style="padding: 6px; line-height: 24px" runat="server"> |
| var panelMain = new Panel(); |
| panelMain.Style.Add(HtmlTextWriterStyle.Padding, "6px"); |
| panelMain.Style.Add("line-height", "24px"); |
| // <asp:Panel Style="margin: 0px; padding: 0px; float: left; margin-right: 10px; white-space: nowrap;" runat="server"> |
| var panel1 = new Panel(); |
| panel1.Style.Add(HtmlTextWriterStyle.MarginBottom, "0px"); |
| panel1.Style.Add(HtmlTextWriterStyle.MarginLeft, "0px"); |
| panel1.Style.Add(HtmlTextWriterStyle.MarginTop, "0px"); |
| panel1.Style.Add(HtmlTextWriterStyle.MarginRight, "10px"); |
| panel1.Style.Add(HtmlTextWriterStyle.Padding, "0px"); |
| panel1.Style.Add("float", "left"); |
| panel1.Style.Add(HtmlTextWriterStyle.WhiteSpace, "nowrap"); |
| // <asp:Button ID="BtnFirstPage" runat="server" OnClientClick="radGrid1ChangePage('first'); return false;" |
| // CommandName="Page" CommandArgument="First" Text=" " CssClass="PagerButton FirstPage" /> |
| var btnFirstPage = new Button |
| { |
| OnClientClick = "radGrid1ChangePage('first'); return false;", |
| CommandName = "Page", |
| CommandArgument = "First", |
| Text = " ", |
| CssClass = "PagerButton FirstPage" |
| }; |
| // <asp:Button ID="BtnPrevPage" runat="server" OnClientClick="radGrid1ChangePage('prev'); return false;" |
| // CommandName="Page" CommandArgument="Prev" Text=" " CssClass="PagerButton PrevPage" /> |
| var btnPrevPage = new Button |
| { |
| OnClientClick = "radGrid1ChangePage('prev'); return false;", |
| CommandName = "Page", |
| CommandArgument = "Prev", |
| Text = " ", |
| CssClass = "PagerButton PrevPage" |
| }; |
| // </asp:Panel> |
| panel1.Controls.Add(btnFirstPage); |
| panel1.Controls.Add(btnPrevPage); |
| // <asp:Panel runat="server" ID="NumericPagerPlaceHolder" Style="margin: 0px; padding: 0px; float: left; margin-right: 10px; white-space: nowrap;"/> |
| var panel2 = new Panel(); |
| panel2.Style.Add(HtmlTextWriterStyle.MarginBottom, "0px"); |
| panel2.Style.Add(HtmlTextWriterStyle.MarginLeft, "0px"); |
| panel2.Style.Add(HtmlTextWriterStyle.MarginTop, "0px"); |
| panel2.Style.Add(HtmlTextWriterStyle.MarginRight, "10px"); |
| panel2.Style.Add(HtmlTextWriterStyle.Padding, "0px"); |
| panel2.Style.Add("float", "left"); |
| panel2.Style.Add(HtmlTextWriterStyle.WhiteSpace, "nowrap"); |
| // <asp:Button ID="BtnNextPage" runat="server" OnClientClick="radGrid1ChangePage('next'); return false;" |
| // CommandName="Page" CommandArgument="Next" Text=" " CssClass="PagerButton NextPage" /> |
| var btnNextPage = new Button |
| { |
| OnClientClick = "radGrid1ChangePage('next'); return false;", |
| CommandName = "Page", |
| CommandArgument = "Next", |
| Text = " ", |
| CssClass = "PagerButton NextPage" |
| }; |
| // <asp:Button ID="BtnLastPage" runat="server" OnClientClick="radGrid1ChangePage('last'); return false;" |
| // CommandName="Page" CommandArgument="Last" Text=" " CssClass="PagerButton LastPage" /> |
| var btnLastPage = new Button |
| { |
| OnClientClick = "radGrid1ChangePage('last'); return false;", |
| CommandName = "Page", |
| CommandArgument = "Last", |
| Text = " ", |
| CssClass = "PagerButton LastPage" |
| }; |
| // </asp:Panel> |
| panel2.Controls.Add(btnNextPage); |
| panel2.Controls.Add(btnLastPage); |
| // <asp:Panel runat="server" Style="float: right"> |
| var panel3 = new Panel(); |
| panel3.Style.Add("float", "right"); |
| // <asp:Label Text="<%$ Resources:LanguageWeb, ItemsPerPage %>" runat="server"></asp:Label>: |
| var label1 = new Label { Text = Resources.LanguageWeb.ItemsPerPage + ":" }; |
| // <telerik:RadComboBox ID="RcbCatalogItemPageSize" DataSource="<%# new object[]{10, 20, 30, 40, 50} %>" |
| // Style="margin-right: 0px; margin-bottom: 5px;" Width="40px" SelectedValue='<%# DataBinder.Eval(Container, "Paging.PageSize") %>' |
| // runat="server" OnClientSelectedIndexChanged="RcbCatalogItemPageSize_SelectedIndexChanged"> |
| // </telerik:RadComboBox> |
| var comboBox = new RadComboBox |
| { |
| ID = "RcbCatalogItemPageSize", |
| DataSource = new object[] { 10, 20, 30, 40, 50 }, |
| Width = Unit.Pixel(40), |
| SelectedValue = DataBinder.Eval(_container, "Paging.PageSize").ToString(), |
| OnClientSelectedIndexChanged = "RcbCatalogItemPageSize_SelectedIndexChanged" |
| }; |
| comboBox.Style.Add(HtmlTextWriterStyle.MarginRight, "0px"); |
| comboBox.Style.Add(HtmlTextWriterStyle.MarginBottom, "40px"); |
| // </asp:Panel> |
| panel3.Controls.Add(label1); |
| panel3.Controls.Add(comboBox); |
| // <asp:Panel Style="margin: 0px; float: right;" runat="server"> |
| var panel4 = new Panel(); |
| panel4.Style.Add(HtmlTextWriterStyle.Margin, "0px"); |
| panel4.Style.Add("float", "right"); |
| // <asp:Label Text="<%$ Resources:LanguageWeb, ShowingResult %>" runat="server"></asp:Label> |
| // <%# (int)DataBinder.Eval(Container, "Paging.FirstIndexInPage") + 1 %> |
| // - |
| // <%# (int)DataBinder.Eval(Container, "Paging.LastIndexInPage") + 1 %> |
| // <asp:Label Text="<%$ Resources:LanguageWeb, OutOf %>" runat="server"></asp:Label> |
| // <%# DataBinder.Eval(Container, "Paging.DataSourceCount")%> |
| var label2 = new Label |
| { |
| Text = Resources.LanguageWeb.ShowingResult + " " + |
| (Convert.ToInt32(DataBinder.Eval(_container, "Paging.FirstIndexInPage")) + 1) + |
| " - " + |
| (Convert.ToInt32(DataBinder.Eval(_container, "Paging.LastIndexInPage")) + 1) + |
| " " + Resources.LanguageWeb.OutOf + " " + |
| DataBinder.Eval(_container, "Paging.DataSourceCount") |
| }; |
| // <asp:Image runat="server" |
| // ID="RadGrid1IncompleteWarning" ImageUrl="../App_Themes/Default/Graphics/Icons/warning.png" |
| // ToolTip="<%$ Resources:LanguageWeb, SpecifySearchForCompleteResult %>" |
| // CssClass="gridWarningIcon" />. |
| var imageIncompleteWarning = new Image |
| { |
| ID = _radGridID + "IncompleteWarning", |
| ImageUrl = "../App_Themes/Default/Graphics/Icons/warning.png", |
| ToolTip = Resources.LanguageWeb.SpecifySearchForCompleteResult, |
| CssClass = "gridWarningIcon" |
| }; |
| // </asp:Panel> |
| panel4.Controls.Add(label2); |
| panel4.Controls.Add(imageIncompleteWarning); |
| //</asp:Panel> |
| panelMain.Controls.Add(panel1); |
| panelMain.Controls.Add(panel2); |
| panelMain.Controls.Add(panel3); |
| panelMain.Controls.Add(panel4); |
| base.Controls.Add(panelMain); |
| return base.Controls; |
| } |
| } |
| } |
| } |
| protected void Grid_Init(object sender, EventArgs e) |
| { |
| if(!(sender is RadGrid)) return; |
| var grid = (RadGrid) sender; |
| grid.MasterTableView.PagerTemplate = new PagerTemplatePanel(grid.ID); |
| } |
| <DetailTables> |
| <telerik:GridTableView runat="server" DataSourceID="SqlDataSource4" DataKeyNames="JobPersonID" |
| ShowHeader ="true" Width="100%" CommandItemDisplay= "TopAndBottom" Name = "Detail" |
| AllowAutomaticDeletes="true" AllowAutomaticInserts="true" onupdatecommand="RadGrid1_UpdateCommand" |
| AllowAutomaticUpdates="true" BorderColor="#BC9A10" GridLines="None"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="PersonId" MasterKeyField="PersonTableID" /> |
| </ParentTableRelation> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn > |
| <HeaderStyle Width="20px" ForeColor="Aqua" /> |
| </ExpandCollapseColumn> |
| <Columns> |
| '''' |
| <telerik:GridBoundColumn DataField="PositionControlNum" HeaderText="Position Control#" HeaderStyle-Width="50%" |
| SortExpression="PositionControlNum" UniqueName="PositionControlNum" > |
| <HeaderStyle Width="50%"></HeaderStyle> |
| </telerik:GridBoundColumn> |
| '''' |
| </Columns> |
| <EditFormSettings EditFormType="Template"> |
| <EditColumn UniqueName="EditCommandColumn1"></EditColumn> |
| <FormTemplate> |
| <table id="Table1a" cellspacing="2" cellpadding="1" width="100%" border="0" rules="none" |
| style="border-collapse: collapse; background: white;"> |
| <tr class="EditFormHeader"> |
| <td colspan="2"> |
| <asp:Label ID="UserJobLabel" |
| CssClass="form-local_Headers" runat="server" Text="User Job Details" |
| Font-Underline="True" |
| ></asp:Label> |
| </td> |
| </tr> |
| <tr> |
| <td> |
| </td> |
| <tr> |
| <td> |
| Position Control#</td> |
| <td> |
| <telerik:RadComboBox ID="RadComboBoxPositionControl" runat="server" |
| DataSourceID="SqlDataSource5" DataTextField="PositionControlNum" DataValueField="PositionControlNum" |
| DropDownWidth="599px" Height="110px" HighlightTemplatedItems="true" |
| MarkFirstMatch="true" |
| SelectedValue='<%#Bind("PositionControlNum") %>' Width="600px" |
| > |
| <HeaderTemplate> |
| <table cellpadding="0" cellspacing="0" style="width: 565px"> |
| <tr> |
| <td style="width: 105px;"> |
| Position Control#</td> |
| <td style="width: 75px;"> |
| Budget</td> |
| '' |
| '' |
| </tr> |
| </table> |
| </HeaderTemplate> |
| <ItemTemplate> |
| <table cellpadding="0" cellspacing="0" style="width: 565px"> |
| <tr> |
| <td style="width: 105px;"> |
| <%# DataBinder.Eval(Container.DataItem, "PositionControlNum") %> |
| </td> |
| <td style="width: 75px;"> |
| <%# DataBinder.Eval(Container.DataItem, "Budget", "{0:N2}")%> |
| </td> |
| '' |
| '' |
| </tr> |
| </table> |
| </ItemTemplate> |
| </telerik:RadComboBox> |
| </td> |
| <tr> |
| <td> |
| </td> |
| <td> |
| <asp:Label ID = "FormTemplate_Label" runat = "server"></asp:Label> |
| </td> |
| <td> |
| </td> |
| <td align="right" colspan="2"> |
| <asp:Button ID="btnUpdate" runat="server" CssClass="form-button" |
| CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' |
| Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' |
| /> |
| |
| <asp:Button ID="btnCancel" runat="server" CausesValidation="False" CssClass="form-button" |
| CommandName="Cancel" Text="Cancel" /> |
| </td> |
| </tr> |
| </tr> |
| </table> |
| </FormTemplate> |
| </EditFormSettings> |
| </telerik:GridTableView> |
| <DetailTables> |
| '''' |
| <asp:SqlDataSource ID="SqlDataSource4" runat="server" |
| ConnectionString="<%$ ConnectionStrings:My_AuthorizationConnectionString %>" |
| SelectCommand=" ...." |
| DeleteCommand="..." |
| InsertCommand="..." |
| UpdateCommand="..." |
| <UpdateParameters> |
| <asp:Parameter Name="PositionControlNum" Type="String" /> |
| <asp:Parameter Name="Budget" Type="Decimal" /> |
| '''' |
| </UpdateParameters> |
| <InsertParameters> |
| '''' |
| </InsertParameters> |
| </asp:SqlDataSource> |
nonqueryCommand.Parameters.Add(
"@jobStart", SqlDbType.SmallDateTime)
nonqueryCommand.Parameters.Add(
"@jobEnd", SqlDbType.DateTime)
nonqueryCommand.Parameters(
"@jobStart").Value = RadDateJobStart.SelectedDate.Value
nonqueryCommand.Parameters(
"@jobEnd").Value = RadDateJobEnd.SelectedDate.Value
the entries in the db are empty ?? what am I missing
datetimeColumn.DataFormatString =
"{0:yyyy-MM-dd}";
but looks like only data value format has changed and filter textbox data format is still MM-dd-yyyy after selecting date from calendar control.
Any idea to fix this.
Thanks,
Sam