or
Protected Sub export_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles export.Click RadGrid1.ExportSettings.OpenInNewWindow = True RadGrid1.ExportSettings.ExportOnlyData = True RadGrid1.ExportSettings.IgnorePaging = True RadGrid1.MasterTableView.ExportToExcel() End Sub <telerik:GridTemplateColumn DataField="claim_date" DataType="System.DateTime" FooterText="Totals: " HeaderText="Date" SortExpression="claim_date" UniqueName="claim_date"> <ItemTemplate> <asp:Label ID="claim_dateLabel" runat="server" Text='<%# Eval("claim_date", "{0:MM/dd/yyyy}") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <telerik:RadDatePicker ID="claim_dateTextBox" runat="server" DBSelectedDate='<%# Bind("claim_date") %>' Width="100" /> <asp:RequiredFieldValidator ID="fvDateRequiredFieldValidator" runat="server" ErrorMessage="Claim date is required" ControlToValidate="claim_dateTextBox" ValidationGroup="DataEntryChk" Display="Dynamic" Font-Bold="true" /> <asp:RangeValidator ID="fvDateValidator" Type="Date" ControlToValidate="claim_dateTextBox" runat="server" ErrorMessage="Cannot save claim item. Please select/enter a date in the same month as the voucher month." SetFocusOnError="True" ValidationGroup="DataEntryChk" Display="Dynamic" Font-Bold="true" /> </EditItemTemplate> </telerik:GridTemplateColumn>Protected Sub ClaimsGV_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles ClaimsGV.ItemCommand If e.CommandName = RadGrid.UpdateCommandName Or e.CommandName = RadGrid.PerformInsertCommandName Or e.CommandName = RadGrid.EditCommandName Then Dim editform As GridEditFormItem = DirectCast(DirectCast(e.Item, Telerik.Web.UI.GridDataItem).EditFormItem, GridEditFormItem) 'Dim editform As GridEditableItem = CType(e.Item, GridEditableItem) Dim fvDateValidator As RangeValidator = CType(editform.FindControl("fvDateValidator"), RangeValidator) If fvDateValidator IsNot Nothing And iMaxEndDate <> "" And iMinStartDate <> "" Then fvDateValidator.Enabled = True fvDateValidator.Visible = True fvDateValidator.MinimumValue = iMinStartDate.ToShortDateString fvDateValidator.MaximumValue = iMaxEndDate.Date.ToShortDateString End If End IfEnd Sub<telerik:RadGrid ID="rgEditOrder" OnNeedDataSource="rgEditOrder_NeedDataSource" OnItemCommand="rgEditOrder_ItemCommand" ShowFooter="True" Skin="Sunset" runat="server"><GroupingSettings CaseSensitive="false" /><MasterTableView DataKeyNames="OrderSeq" AutoGenerateColumns="false" AllowSorting="true" AllowPaging="true" AllowFilteringByColumn="False" EditMode="InPlace" ><Columns> <telerik:GridBoundColumn UniqueName="StoreNumber" DataField="StoreNumber" HeaderText="Store #" DataFormatString="{0:#####}" DataType="System.Int32" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="36px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="BoothNumber" DataField="BoothNumber" HeaderText="Booth #" DataFormatString="{0:#####}" DataType="System.Int32" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="36px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="ItemID" DataField="ItemID" HeaderText="Item" DataType="System.Double" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="36px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="ItemDescription" DataField="ItemDescription" HeaderText="Description" ReadOnly="True"> <HeaderStyle Width="120px" /> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn UniqueName="ShipDate" DataField="ShipDate" PickerType="DatePicker" HeaderText="Ship Date" DataFormatString="{0:d}" DataType="System.DateTime" ReadOnly="True"> <HeaderStyle Width="44px" /> </telerik:GridDateTimeColumn> <telerik:GridTemplateColumn UniqueName="Qty" HeaderText="Cases" DataField="Qty" DataType="System.Int32" Aggregate="Sum" > <ItemTemplate> <asp:Label ID="lblQty" Text='<%# Bind("Qty") %>' Width="32px" runat="server" /> </ItemTemplate> <EditItemTemplate> <telerik:RadNumericTextBox ID="rntbQty" Value='<%# Eval("Qty") %>' OnTextChanged="rntbQty_TextChanged" AutoPostBack="True" Width="32px" runat="server"> <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </EditItemTemplate> <HeaderStyle Width="32px" /> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="NetCost" DataField="NetCost" HeaderText="Net Cost" DataFormatString="{0:C2}" DataType="System.Double" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="50px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="ItemTotal" DataField="ItemTotal" HeaderText="Item Total" DataFormatString="{0:C2}" DataType="System.Double" Aggregate="Sum" ReadOnly="True"> <HeaderStyle Width="50px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="PageNumber" DataField="PageNumber" HeaderText="Page" DataFormatString="{0:#####}" DataType="System.Int32" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="36px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="VendorNumber" DataField="VendorNumber" HeaderText="Vendor" DataFormatString="{0:#####}" DataType="System.Int32" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="36px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="DepartmentNumber" DataField="DepartmentNumber" HeaderText="Depart" DataFormatString="{0:##}" DataType="System.Int32" Aggregate="None" ReadOnly="True"> <HeaderStyle Width="26px" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="OrderSeq" DataField="OrderSeq" DataType="System.Int64" Visible="false"> </telerik:GridBoundColumn></Columns></MasterTableView><ClientSettings> <ClientEvents OnRowDblClick="RowDblClick" /> <ClientEvents OnRowClick="RowClick" /> <ClientEvents OnRowDataBound="RowDataBound" /></ClientSettings></telerik:RadGrid>protected void rgEditOrder_NeedDataSource(object source, GridNeedDataSourceEventArgs e){ DataSet dsOrder = new DataSet(); if (txtStoreHidden.Value == "") { return; } WsOrderSystem wsOrder = new WsOrderSystem(); dsOrder = wsOrder.GetOnlineOrder(Convert.ToDouble(txtStoreHidden.Value), txtChain.Value); rgEditOrder.DataSource = dsOrder; Session["EditOrderView"] = dsOrder;}ALTER PROCEDURE [dbo].[get_online_order] @StoreNumber BIGINT, @ChainID VARCHAR(20)AS BEGIN DECLARE @ShowOrders TABLE (StoreNumber BIGINT, BoothNumber INT, VendorNumber INT, ItemID INT, ShipDate DATETIME, Qty INT) IF @ChainID IS NULL SELECT @ChainID=ChainID FROM Stores WHERE StoreNumber=@StoreNumber IF @ChainID='' BEGIN INSERT INTO @ShowOrders (StoreNumber,BoothNumber,VendorNumber,ItemID,ShipDate,Qty) SELECT StoreNumber, BoothNumber, VendorNumber, ItemID, ShipDate, SUM(Qty) AS Qty FROM Orders WHERE StoreNumber=@StoreNumber AND Qty>0 GROUP BY StoreNumber,BoothNumber,VendorNumber,ItemID,ShipDate SELECT AO.StoreNumber, AO.BoothNumber, AO.ItemID, ItemDescription, AO.ShipDate, CAST(AO.Qty AS INT) AS Qty, MinQty=CASE WHEN t.Qty IS NULL THEN 0 ELSE t.Qty END, AO.NetCost, AO.Qty*AO.NetCost AS ItemTotal, AO.PageNumber, AO.VendorNumber, DepartmentNumber, DepartmentDescription, ROW_NUMBER() OVER (ORDER BY DateAddEdit DESC) AS OrderSeq, CONVERT(VARCHAR,ShipStart1,101) AS ShipStart1, CONVERT(VARCHAR,ShipEnd1,101) AS ShipEnd1, CONVERT(VARCHAR,ShipStart2,101) AS ShipStart2, CONVERT(VARCHAR,ShipEnd2,101) AS ShipEnd2, CONVERT(VARCHAR,ShipStart3,101) AS ShipStart3, CONVERT(VARCHAR,ShipEnd3,101) AS ShipEnd3, OrderSeq AS Seq FROM AfterOrders AO INNER JOIN Items I ON AO.ItemID=I.ItemID LEFT OUTER JOIN @ShowOrders t ON AO.StoreNumber=t.StoreNumber AND AO.BoothNumber=t.BoothNumber AND AO.VendorNumber=t.VendorNumber AND AO.ItemID=t.ItemID AND AO.ShipDate=t.ShipDate WHERE AO.StoreNumber=@StoreNumber AND AO.Qty>0 ORDER BY Seq END ELSE BEGIN INSERT INTO @ShowOrders (StoreNumber,BoothNumber,VendorNumber,ItemID,ShipDate,Qty) SELECT O.StoreNumber, BoothNumber, VendorNumber, ItemID, ShipDate, SUM(Qty) AS Qty FROM Orders O INNER JOIN Stores S ON O.StoreNumber=S.StoreNumber WHERE ChainID=@ChainID AND Qty>0 GROUP BY O.StoreNumber,BoothNumber,VendorNumber,ItemID,ShipDate SELECT AO.StoreNumber, AO.BoothNumber, AO.ItemID, ItemDescription, AO.ShipDate, CAST(AO.Qty AS INT) AS Qty, MinQty=CASE WHEN t.Qty IS NULL THEN 0 ELSE t.Qty END, AO.NetCost, AO.Qty*AO.NetCost AS ItemTotal, AO.PageNumber, AO.VendorNumber, DepartmentNumber, DepartmentDescription, ROW_NUMBER() OVER (ORDER BY AO.DateAddEdit DESC) AS OrderSeq, CONVERT(VARCHAR,ShipStart1,101) AS ShipStart1, CONVERT(VARCHAR,ShipEnd1,101) AS ShipEnd1, CONVERT(VARCHAR,ShipStart2,101) AS ShipStart2, CONVERT(VARCHAR,ShipEnd2,101) AS ShipEnd2, CONVERT(VARCHAR,ShipStart3,101) AS ShipStart3, CONVERT(VARCHAR,ShipEnd3,101) AS ShipEnd3, OrderSeq AS Seq FROM AfterOrders AO INNER JOIN Stores S ON AO.StoreNumber=S.StoreNumber INNER JOIN Items I ON AO.ItemID=I.ItemID LEFT OUTER JOIN @ShowOrders t ON AO.StoreNumber=t.StoreNumber AND AO.BoothNumber=t.BoothNumber AND AO.VendorNumber=t.VendorNumber AND AO.ItemID=t.ItemID AND AO.ShipDate=t.ShipDate WHERE ChainID=@ChainID AND AO.Qty>0 ORDER BY AO.ItemID,AO.ShipDate,AO.StoreNumber END END<telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> <asp:Button ID="Button1" runat="server" Text="abrir" /> <telerik:RadWindowManager ID="RadWindowManager1" runat="server"> <Windows> <telerik:RadWindow ID="RadWindow1" runat="server" OpenerElementID="Button1"> <ContentTemplate> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"> <asp:Button ID="Button2" runat="server" Text="Button" /> </telerik:RadAjaxPanel> </ContentTemplate> </telerik:RadWindow> </Windows></telerik:RadWindowManager>