This is a migrated thread and some comments may be shown as answers.

[Solved] Change search condition between column filters?

3 Answers 93 Views

Grid

This is a migrated thread and some comments may be shown as answers.

3 Answers, 1 is accepted

answered on 15 Dec 2008, 03:25 PM

Hi Jason,

How the grid is bound in your case? Here is an example with LinqDataSource:

    
            <%@ Page Language="C#" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <script runat="server"> 
        
                protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e) 
        
                { 
        
                    LinqDataSource1.Where =  
        
                        RadGrid1.MasterTableView.FilterExpression.Replace("AND", "OR"); 
        
                } 
        
            </script> 
        
            <html xmlns="http://www.w3.org/1999/xhtml"> 
        
            <head runat="server"> 
        
                <title></title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server"> 
        
                <div> 
        
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server" /> 
        
                    <telerik:RadGrid ID="RadGrid1" DataSourceID="LinqDataSource1" AllowPaging="true" 
        
                        AllowSorting="true" AllowFilteringByColumn="true" runat="server"> 
        
                    </telerik:RadGrid> 
        
                    <asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="DataClassesDataContext" 
        
                        TableName="Customers" onselecting="LinqDataSource1_Selecting"> 
        
                    </asp:LinqDataSource> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html>

Greetings,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 15 Sep 2009, 07:11 AM

Hello Dennis,

You may use client-side databinding event to get current query which will be send to the ADO.NET DataService. Similar to the following:

    
            <telerik:RadGrid> 
        
            <!--...---> 
        
            <ClientSettings> 
        
                            <ClientEvents OnDataBinding="dataBinding"/>                  
        
                            <DataBinding Location="GridAdoNetDataService.svc" SelectCountMethod="GetCount">  
        
                                <DataService TableName="Products" />                      
        
                            </DataBinding> 
        
                        </ClientSettings> 
        
                    </telerik:RadGrid>    
        
                    <script type="text/javascript">  
        
                        function dataBinding(sender, args){                                                              
        
                            args.set_query(args.get_query().replace(/ and /ig," or "));  
        
                        }  
        
                    </script>

Kind regards,
Rosen
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.