or
public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { ClientsContext db = new ClientsContext(); var query = from b in db.Clients orderby b.LastName select new { Client = b.ClientId, First = b.FirstName, Last = b.LastName, County = b.CountyName, City = b.City }; GridView1.DataSource = query.ToList().Take(100); } } }
Your support will be greatly appreciated.
G


<telerik:RadGrid runat="server" ID="grid1" GridLines="None" ShowFooter="False" Culture="de-DE"> <MasterTableView AutoGenerateColumns="False" AllowMultiColumnSorting="True" CommandItemDisplay="Top"> <CommandItemTemplate> <telerik:RadToolBar ID="radToolBar" Skin="Windows7" runat="server" AutoPostBack="true" Width="100%"> <Items> <telerik:RadToolBarButton Value="section2"> <ItemTemplate> <telerik:RadTextBox ID="textbox1" runat="server" Skin="Windows7"><ClientEvents OnKeyPress="OnKeyPress" /></telerik:RadTextBox> <telerik:RadButton ID="btnSearch" runat="server" Skin="Windows7" Text="Search" CommandName="Search" OnClick="searchButton_Click"/> </ItemTemplate> </telerik:RadToolBarButton> </Items> </telerik:RadToolBar> </CommandItemTemplate> </MasterTableView> <GroupingSettings CaseSensitive="False" /></telerik:RadGrid>protected void searchButton_Click(object sender, EventArgs e){ RadTextBox searchFilter = GetSearchBox(); if (searchFilter == null) return; var filterExpression = new StringBuilder(); var searchText = searchFilter.Text; foreach (GridColumn col in grid1.MasterTableView.Columns) { filterExpression.AppendFormat("{0}(it[\"{1}\"].ToString().ToUpper().Contains(\"{2}\".ToUpper()))", filterExpression.Length != 0 ? " OR " : string.Empty, col.UniqueName, searchText); } activePassiveGrid.MasterTableView.FilterExpression = filterExpression.ToString(); activePassiveGrid.MasterTableView.Rebind();}
<telerik:RadGrid ID="AdministratorRadGrid" runat="server" AllowPaging="True" AllowSorting="true" OnItemCommand="AdministratorRadGrid_ItemCommand" OnSortCommand="AdministratorRadGrid_SortCommand" OnPageSizeChanged="AdministratorRadGrid_PageSizeChanged" OnPageIndexChanged="AdministratorRadGrid_PageIndexChanged" PagerStyle-Position="TopAndBottom"> <MasterTableView AutoGenerateColumns="False" DataKeyNames="BWUserRoleID"> <Columns> <telerik:GridBoundColumn DataField="BWUserRoleID" HeaderText="ID" ReadOnly="true" Visible="true"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DisplayName" HeaderText="Name" ReadOnly="true" FilterControlWidth="150px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Title" HeaderText="Title" ReadOnly="true" FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="UserID" HeaderText="ID" ReadOnly="true" FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="RoleID" HeaderText="Role ID" FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Description" HeaderText="Description" ReadOnly="true" FilterControlWidth="50px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"></telerik:GridBoundColumn> <telerik:GridButtonColumn ButtonType="PushButton" CommandName="AdminActivate" Text="Edit Admin Status" Resizable="false"></telerik:GridButtonColumn> </Columns> </MasterTableView></telerik:RadGrid>