<div> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"> </telerik:RadAjaxLoadingPanel> <telerik:RadGrid ID="RadGrid1" runat="server" EnableViewState="true" ShowStatusBar="true" ShowFooter="True" onitemcommand="RadGrid1_ItemCommand" ondeletecommand="RadGrid1_DeleteCommand" oninsertcommand="RadGrid1_InsertCommand" onupdatecommand="RadGrid1_UpdateCommand" onneeddatasource="RadGrid1_NeedDataSource" > <MasterTableView DataKeyNames="Title" AutoGenerateColumns="false" EditMode="InPlace" CommandItemDisplay="TopAndBottom" CommandItemSettings-AddNewRecordText="Add New Item" > <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton"> </telerik:GridEditCommandColumn> <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow" ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" ConfirmDialogHeight="100px" ConfirmDialogWidth="220px"> </telerik:GridButtonColumn> <telerik:GridTemplateColumn DataField="Title" HeaderText="Product Number" UniqueName="ProductNumber" Visible="true"> <InsertItemTemplate> <telerik:RadTextBox ID="RadtxtPrdNumber" runat="server" Text='<%# Bind("Title") %>' > </telerik:RadTextBox> </InsertItemTemplate> <EditItemTemplate> <telerik:RadTextBox ID="RadtxtPrdNumber" runat="server" Text='<%# Eval("Title") %>' > </telerik:RadTextBox> </EditItemTemplate> <ItemTemplate> <telerik:RadTextBox ID="RadtxtPrdNumber" ReadOnly="true" runat="server" Text='<%# Eval("Title") %>' /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ClientSettings EnableRowHoverStyle="true"> </ClientSettings> </telerik:RadGrid> <asp:Button ID="btnSubmit" runat="server" Text="Submit" onclick="btnSubmit_Click" /> </div>protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e) { GridEditableItem item = e.Item as GridEditableItem; Hashtable values = new Hashtable(); item.ExtractValues(values); string ti = values["Title"].ToString(); }
<telerik:RadDockLayout runat="server" ID="RadDockLayout1">
<telerik:RadDockZone ID="RadDockZone1" runat="server" Orientation="Vertical" Width="200px" MinHeight="400px">
<telerik:RadDock ID="RadDock1" runat="server" Title="Blogs" EnableAnimation="true" Resizable="true" AutoPostBack="true">
<ContentTemplate>
<telerik:RadMenu ID="RadMenuVertical" runat="server" Width="100%" flow="Vertical" EnableShadows="true">
<Items>
<telerik:RadMenuItem Text="Books" />
<telerik:RadMenuItem Text="Cameras" />
<telerik:RadMenuItem Text="Music" />
<telerik:RadMenuItem Text="Software" />
</Items>
</telerik:RadMenu>
</ContentTemplate>
</telerik:RadDock>
</telerik:RadDockZone>
</telerik:RadDockLayout>
GridEditableItem editedItem = e.Item as GridEditableItem; DataTable ordersTable = this.GridData; //Locate the changed row in the DataSource DataRow[] changedRows = ordersTable.Select("Title = " + Convert.ToString(editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Title"]));var mymultiplier = MasterTable.getCellByColumnUniqueName(dataItem, 'Multiplier');<telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <script type="text/javascript"> Sys.WebForms.PageRequestManager.getInstance().add_initializeRequest(initRequest); function initRequest(sender, args) { if (args.get_postBackElement().id.indexOf("btn_ExcelExport") != -1) { args.set_cancel(true); //stop async request sender._form["__EVENTTARGET"].value = args.get_postBackElement().id.replace(/\_/g, "$"); sender._form["__EVENTARGUMENT"].value = ""; sender._form.submit(); return; } } </script><telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="rg_Clients"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="rg_Clients" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid ID="rg_Clients" runat="server" AllowFilteringByColumn="True" AllowPaging="True" ActiveItemStyle-BackColor="#004070" ActiveItemStyle-ForeColor="White" AllowSorting="True" CellSpacing="0" GridLines="Both" OnNeedDataSource="rg_Clients_NeedDataSource" Skin="WebBlue" OnItemCommand="rg_Clients_ItemCommand" AutoGenerateColumns="false" EnableLinqExpressions="false" HeaderStyle-Font-Bold="true" OnColumnCreating="rg_Clients_ColumnCreating" GroupingSettings-CaseSensitive="false" OnPreRender="rg_Clients_PreRender"> <MasterTableView AutoGenerateColumns="false" AllowFilteringByColumn="True"> <Columns> <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="ClientID" HeaderStyle-Width="40px" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left"> <HeaderTemplate> <asp:ImageButton ID="btn_ExcelExport" runat="server" ImageUrl="~/Images/Excel-icon.png" Width="30" Height="30" OnClick="btn_ExcelExport_Click" CausesValidation="false" /> </HeaderTemplate> <ItemTemplate> <asp:Button ID="btn_View" CommandName="Select" CommandArgument='<%# DataBinder.Eval(Container.DataItem,"ClientID") %>' runat="server" Text="View" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> <ExportSettings Excel-Format="ExcelML" FileName="ClientExport" IgnorePaging="true" OpenInNewWindow="true" ExportOnlyData="true" /> </telerik:RadGrid>protected void btn_ExcelExport_Click(object sender, ImageClickEventArgs e) { string[] UserRoles = Roles.GetRolesForUser(); rg_Clients.MasterTableView.GetColumn("ClientID").Visible = false; //Dont need to see the filter boxes in the excel sheet foreach (GridFilteringItem Filter in rg_Clients.MasterTableView.GetItems(GridItemType.FilteringItem)) Filter.Visible = false; //Data Admin and Site Admin can export all Clients, Sales Admin can export their own and who they are supervising, // and Sales Person can only export their own if (UserRoles.Contains("Sales Admin")) { string Source = PageController.GetUserFullName((Guid)Membership.GetUser().ProviderUserKey); List<string> Sources = ClientController.GetSupervisorSources((Guid)Membership.GetUser().ProviderUserKey); if (rg_Clients.MasterTableView.FilterExpression != String.Empty) rg_Clients.MasterTableView.FilterExpression += "AND "; string QueryFilter = "([Sources] LIKE \'%" + Source + "%\') "; foreach (string S in Sources) QueryFilter += "OR ([Sources] LIKE \'%" + S + "%\') "; rg_Clients.MasterTableView.FilterExpression += QueryFilter; } else if (UserRoles.Contains("Sales Person")) { string Source = PageController.GetUserFullName((Guid)Membership.GetUser().ProviderUserKey); if (rg_Clients.MasterTableView.FilterExpression != String.Empty) rg_Clients.MasterTableView.FilterExpression += "AND "; rg_Clients.MasterTableView.FilterExpression += "([Sources] LIKE \'%" + Source + "%\') "; } rg_Clients.MasterTableView.ExportToExcel();