Telerik is a leading vendor of ASP.NET AJAX, ASP.NET MVC, Silverlight, WinForms and WPF controls and components, as well as .NET Reporting, .NET ORM , .NET CMS, Code Analysis, Mocking, Team Productivity and Automated Testing Tools. Building on its expertise in interface development and Microsoft technologies, Telerik helps customers build applications with unparalleled richness, responsiveness and interactivity. Telerik products help thousands of companies to be more productive and deliver reliable applications under budget and on time.
Version Q1 2012 released 04/11/2012
select

Grid / Persisting Grid Settings

select

Drag a column header and drop it here to group by that column
CustomerIDCompanyNameContactNameContactTitleCity
     
12345678910
Page size:
select
 91 items in 10 pages
ALFKIAlfreds FutterkisteMaria AndersSales RepresentativeBerlin
ANATRAna Trujillo Emparedados y heladosAna TrujilloOwnerMéxico D.F.
ANTONAntonio Moreno TaqueríaAntonio MorenoOwnerMéxico D.F.
AROUTAround the HornThomas HardySales RepresentativeLondon
BERGSBerglunds snabbköpChristina BerglundOrder AdministratorLuleå
BLAUSBlauer See DelikatessenHanna MoosSales RepresentativeMannheim
BLONPBlondesddsl père et filsFrédérique CiteauxMarketing ManagerStrasbourg
BOLIDBólido Comidas preparadasMartín SommerOwnerMadrid
BONAPBon app'Laurence LebihanOwnerMarseille
BOTTMBottom-Dollar MarketsElizabeth LincolnAccounting ManagerTsawassen

  • Make changes to the grid by applying filter/group-by/sort expressions. Reorder and resize columns, or show/hide columns using the header context menu. Then, save the settings and choose a different user from the combo. Make additional changes and save these as well. Finally, you can choose a user from the combo box and restore the settings associated with this user.

Source Code

C# VB.NET
Show code in new window Demo isolation steps
  • <%@ Page Language="vb" AutoEventWireup="false" Inherits="Telerik.GridExamplesVBNET.Programming.SavingGridSettingsOnPerUserBasis.DefaultVB"
        CodeFile="DefaultVB.aspx.vb" %>

    <%@ Register TagPrefix="telerik" Namespace="Telerik.QuickStart" %>
    <%@ Register TagPrefix="telerik" TagName="Header" Src="~/Common/Header.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="HeadTag" Src="~/Common/HeadTag.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="Footer" Src="~/Common/Footer.ascx" %>
    <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <telerik:HeadTag runat="server" ID="Headtag2"></telerik:HeadTag>
        <style type="text/css">
            html.rfdButton a.rfdSkinnedButton
            {
                vertical-align: middle;
                margin: 0 0 0 5px;
            }
        </style>
    </head>
    <body class="BODY">
        <form runat="server" id="mainForm" method="post">
        <telerik:Header runat="server" ID="Header1" NavigationLanguage="VB"></telerik:Header>
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server" />
        <!-- content start -->
        <telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" ControlsToSkip="Scrollbars, Zone" />
        <telerik:RadAjaxPanel runat="server" ID="AjaxPanel1" LoadingPanelID="LoadingPanel1">
            <fieldset>
                <div style="width: 860px; height: 30px; padding: 10px 0;">
                    <div style="float: left;">
                        <telerik:RadComboBox runat="server" ID="UserSelection" AutoPostBack="true" Width="200px">
                            <Items>
                                <telerik:RadComboBoxItem Text="User1" Value="User1" Selected="true" />
                                <telerik:RadComboBoxItem Text="User2" Value="User2" />
                                <telerik:RadComboBoxItem Text="User3" Value="User3" />
                            </Items>
                        </telerik:RadComboBox>
    <asp:Button runat="server" ID="Button1" Text="Save Settings" OnClick="Button1_Click"
    Width="100px" />
    <asp:Button runat="server" ID="Button2" Text="Load Settings" OnClick="Button2_Click"
    Width="100px" /><br />
                    </div>
                    <div style="float: right;">
    <asp:Image runat="server" ID="InfoImage" Visible="false" EnableViewState="false"
    Style="float: left;" ImageUrl="~/Grid/Examples/Programming/SavingGridSettingsOnPerUserBasis/Img/info_icon.png" />
    <asp:Label runat="server" ID="StatusLabel" EnableViewState="false" Style="float: left;
    font-style: italic; padding: 5px 0 0 5px;">
                        </asp:Label>
                    </div>
                </div>
                <telerik:RadGrid runat="server" ID="RadGrid1" GridLines="None" ShowFooter="True"
                    DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowSorting="True"
                    ShowGroupPanel="True" AllowPaging="true" PageSize="10">
                    <MasterTableView AutoGenerateColumns="False" DataKeyNames="CustomerID" DataSourceID="SqlDataSource1"
                        EnableHeaderContextMenu="true">
                        <Columns>
                            <telerik:GridBoundColumn DataField="CustomerID" DefaultInsertValue="" HeaderText="CustomerID"
                                ReadOnly="True" SortExpression="CustomerID" UniqueName="CustomerID">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="CompanyName" DefaultInsertValue="" HeaderText="CompanyName"
                                SortExpression="CompanyName" UniqueName="CompanyName">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="ContactName" DefaultInsertValue="" HeaderText="ContactName"
                                SortExpression="ContactName" UniqueName="ContactName">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="ContactTitle" DefaultInsertValue="" HeaderText="ContactTitle"
                                SortExpression="ContactTitle" UniqueName="ContactTitle">
                            </telerik:GridBoundColumn>
                            <telerik:GridBoundColumn DataField="City" DefaultInsertValue="" HeaderText="City"
                                SortExpression="City" UniqueName="City">
                            </telerik:GridBoundColumn>
                        </Columns>
                    </MasterTableView>
                    <ClientSettings AllowDragToGroup="True" AllowColumnsReorder="True">
                        <Resizing AllowColumnResize="true" />
                    </ClientSettings>
                </telerik:RadGrid>
            </fieldset>
        </telerik:RadAjaxPanel>
        <telerik:RadAjaxLoadingPanel runat="server" ID="LoadingPanel1" />
        <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            ProviderName="System.Data.SqlClient" SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City] FROM [Customers]"
            runat="server"></asp:SqlDataSource>
        <!-- content end -->
        <telerik:Footer runat="server" ID="Footer1"></telerik:Footer>
        </form>
    </body>
    </html>

Get more than expected!

Take your time to truly experience the power of RadControls for ASP.NET AJAX with a free 60-day trial backed up by Telerik’s unlimited dedicated support.

Download your RadControls for ASP.NET AJAX trial and jumpstart your development with the available Getting Started resources.

If you have any questions, do not hesitate to contact us at sales@telerik.com.

Copyright 2002-2012 © Telerik. All right reserved
Telerik Inc, 201 Jones Rd, Waltham, MA 02451