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();}