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

Filter in Radgrid with subGrid not working

1 Answer 63 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Felice
Top achievements
Rank 1
Felice asked on 31 Oct 2013, 03:30 PM
I have this Radgrid:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="projects.aspx.cs" Inherits="projects" %>
 
<%@ 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">
 
<head runat="server">
    <title>Projects</title>
</head>
<body>
    <table width="100%">
    <tr>
    <td><img src="images/logo.PNG"  /></td>
    </tr>
    </table>
 
 
    <form id="form1" runat="server">
    <div>
     
    </div>
     <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
            </telerik:RadScriptManager>
       <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            // <![CDATA[
            //On insert and update buttons click temporarily disables ajax to perform upload actions
            function conditionalPostback(sender, eventArgs) {
                var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig");
                if (eventArgs.get_eventTarget().match(theRegexp)) {
                    var upload = $find(window['UploadId']);
                    //alert(upload);
                    if (upload == null) {
                        eventArgs.set_enableAjax(false);
                        return;
                    }
                    //AJAX is disabled only if file is selected for upload
                    if (upload.getFileInputs()[0].value != "") {
                        eventArgs.set_enableAjax(false);
                    }
                }
            }
 
            function validateRadUpload(source, e) {
                e.IsValid = false;
 
                var upload = $find(source.parentNode.getElementsByTagName('div')[0].id);
                if (upload == null) {
                    return;
                }
                var inputs = upload.getFileInputs();
                for (var i = 0; i < inputs.length; i++) {
                    //check for empty string or invalid extension
                    if (inputs[i].value != "" && upload.isExtensionValid(inputs[i].value)) {
                        e.IsValid = true;
                        break;
                    }
                }
            }
            // ]]>
        </script>
    </telerik:RadCodeBlock>
     
    <table width="100%">
    <tr>
    <td>
    <telerik:RadMenu ID="RadMenu1" runat="server" Skin="Default" Width="100%" Font-Size="Large">
   <Items>
   
   <telerik:RadMenuItem Text="Login" runat="server"></telerik:RadMenuItem>
    <telerik:RadMenuItem Text="Home" runat="server" NavigateUrl="home.aspx" ></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Data Administration" runat="server"  NavigateUrl="~/dataAdmin.aspx">
       <Items>
           <telerik:RadMenuItem runat="server" NavigateUrl="customers.aspx" Text="Customers">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="manufacturers.aspx" Text="Manufactures">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="product.aspx" Text="Products">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="events.aspx" Text="Events">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" Selected="True" Text="Projects">
           </telerik:RadMenuItem>
       </Items>
       </telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Search" runat="server" NavigateUrl="search.aspx"></telerik:RadMenuItem>
    <telerik:RadMenuItem Text="Indust. Reports" runat="server"  NavigateUrl="industry_report.aspx"></telerik:RadMenuItem>
       <telerik:RadMenuItem runat="server" NavigateUrl="~/reports_Start_page.aspx" Text="Reports Section">
       </telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Administration" runat="server" NavigateUrl="users.aspx"></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Help" runat="server" NavigateUrl="help.aspx" ></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Log Out" runat="server" NavigateUrl="logout.aspx"></telerik:RadMenuItem>
   </Items>
     
        
  </telerik:RadMenu>
  </td>
  </tr>
  </table>
 
            <table>
            <tr>
            <td><asp:Button ID="Button2" runat="server" Text="Export XL" OnClick="Button2_Click" /></td>
            </tr>
            </table>
              <table width="100%">
              <tr>
              <td>
     
            <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"  clientevents-onrequeststart="conditionalPostback" 
            RestoreOriginalRenderDelegate="false"  LoadingPanelID="RadAjaxLoadingPanel1">
             <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" >
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid1">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" ></telerik:AjaxUpdatedControl>
                            <telerik:AjaxUpdatedControl ControlID="RequiredFieldValidator1"></telerik:AjaxUpdatedControl>
                             
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    </AjaxSettings>
            </telerik:RadAjaxManager>
             <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"  Skin="Telerik">
         </telerik:RadAjaxLoadingPanel>         
        
 
       <telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True"
            AllowFilteringByColumn="True"
            AllowSorting="True"
            AllowMultiRowSelection="true"
            AutoGenerateColumns="False"
            AllowAutomaticInserts="True"
            AllowAutomaticUpdates="True"
            AllowAutomaticDeletes="True" ShowStatusBar="True"
             OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
            GridLines="None"
            DataSourceID="SqlDataSource1"
            PageSize="10" CellSpacing="0"
            OnDeleteCommand="RadGrid1_DeleteCommand"
            OnItemCreated="RadGrid1_ItemCreated"
            OnItemCommand="RadGrid1_ItemCommand"
               OnItemInserted="RadGrid1_ItemInserted"
                OnItemUpdated="RadGrid1_ItemUpdated"
               OnItemDataBound="RadGrid1_ItemDataBound"
              OnUpdateCommand="RadGrid1_UpdateCommand"
             oninsertcommand="RadGrid1_InsertCommand" >
            <PagerStyle Mode="NextPrevAndNumeric"   AlwaysVisible="true"></PagerStyle>
            <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="proj_id"  Name="Master" >
             
               
              <Columns>
                 
                <telerik:GridClientSelectColumn UniqueName="ChkSel" >
                </telerik:GridClientSelectColumn>
                 
                 
                    <telerik:GridEditCommandColumn ButtonType="ImageButton">
                        <HeaderStyle Width="36px"></HeaderStyle>
                    </telerik:GridEditCommandColumn>
                     
                     
                     
                     
                    <telerik:GridTemplateColumn HeaderText="ProjectID"  UniqueName="proj_id" DataField="proj_id" >
                        <ItemTemplate>
                            <asp:Label ID="lblid" runat="server" Text='<%# Bind("proj_id") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate >
                            <asp:TextBox ID="txtid" Width="300px" runat="server" Text='<%# Bind("proj_id") %>'  ReadOnly="true">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Project Name"  UniqueName="proj_name" DataField="proj_name"  SortExpression="proj_name">
                        <ItemTemplate>
                            <asp:Label ID="lblpn" runat="server" Text='<%# Bind("proj_name") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtpn" Width="300px" runat="server" Text='<%# Bind("proj_name") %>' >
                            </asp:TextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txtpn"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                                      
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource2" ListTextField="custname"
                        ListValueField="custid" UniqueName="ddl" SortExpression="proj_cust_id"
                        EmptyListItemText="Select Customer" EnableEmptyListItem="true"
                        HeaderText="Customer" DropDownControlType="RadComboBox" DataField="proj_cust_id">
                         
                    </telerik:GridDropDownColumn>
                     
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname"
                        ListValueField="manid" UniqueName="ddl2" SortExpression="proj_man_id"
                        EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true"
                        HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="proj_man_id">
                    </telerik:GridDropDownColumn>
                     
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource4" ListTextField="prodname"
                        ListValueField="prodid" UniqueName="ddl3" SortExpression="proj_prod_id"
                        EmptyListItemText="Select Product" EnableEmptyListItem="true"
                        HeaderText="Product" DropDownControlType="RadComboBox" DataField="proj_prod_id">
                    </telerik:GridDropDownColumn>
 
 
                     
                    <telerik:GridDateTimeColumn UniqueName="proj_date" PickerType="DatePicker" HeaderText="Proj Date"
                    DataField="proj_date"  DataFormatString="{0:MM/dd/yyyy}">
                    <ItemStyle Width="120px"></ItemStyle>
                    </telerik:GridDateTimeColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Num Of Vehicle"  UniqueName="proj_num_of_vehicles" DataField="proj_num_of_vehicles" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblnov" runat="server" Text='<%# Eval("proj_num_of_vehicles")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtnov" Width="50px" runat="server" Text='<%# Bind("proj_num_of_vehicles") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator2" ControlToValidate="txtnov"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Coach per Vehicle"  UniqueName="proj_coach_vehicle" DataField="proj_coach_vehicle" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblcv" runat="server" Text='<%# Eval("proj_coach_vehicle")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtcv" Width="50px" runat="server" Text='<%# Bind("proj_coach_vehicle") %>' >
                           <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ControlToValidate="txtcv"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     <telerik:GridTemplateColumn HeaderText="Contract Value(€)"  UniqueName="proj_contract_value"
                     DataField="proj_contract_value" display="false"  >
                        <ItemTemplate>
                            <asp:Label ID="lblcval" runat="server" Text='<%# Eval("proj_contract_value")  %>' width="150px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox  ID="txtcval" Width="150px" runat="server" Text='<%# Bind("proj_contract_value") %>' >
                           <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator4" ControlToValidate="txtcval"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                    <telerik:GridTemplateColumn HeaderText="Avg Price per Coach(€)"  UniqueName="proj_avg_price_per_coach" DataField="proj_avg_price_per_coach" display="false">
                        <ItemTemplate></ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtppc" Width="150px" runat="server"  ReadOnly="true" >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Length(m)"  UniqueName="proj_length" DataField="proj_length" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpl" runat="server" Text='<%# Eval("proj_length")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpl" Width="50px" runat="server" Text='<%# Bind("proj_length") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Width(mm)"  UniqueName="proj_width" DataField="proj_width" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpw" runat="server" Text='<%# Eval("proj_width")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpw" Width="50px" runat="server" Text='<%# Bind("proj_width") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Height(mm)"  UniqueName="proj_height" DataField="proj_height" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblph" runat="server" Text='<%# Eval("proj_height")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtph" Width="50px" runat="server" Text='<%# Bind("proj_height") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Passenger Seats"  UniqueName="proj_passenger_seats" DataField="proj_passenger_seats" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblps" runat="server" Text='<%# Eval("proj_passenger_seats")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtps" Width="50px" runat="server" Text='<%# Bind("proj_passenger_seats") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Passengers Total"  UniqueName="proj_passenger_total" DataField="proj_passenger_seats" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpat" runat="server" Text='<%# Eval("proj_passenger_total")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpat" Width="50px" runat="server" Text='<%# Bind("proj_passenger_total") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                    <telerik:GridTemplateColumn HeaderText="Brand"  UniqueName="proj_brand" DataField="proj_brand" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblbr" runat="server" Text='<%# Eval("proj_brand")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtbr" Width="100px" runat="server" Text='<%# Bind("proj_brand") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="System Voltage"  UniqueName="proj_systemvoltage" DataField="proj_systemvoltage" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblsv" runat="server" Text='<%# Eval("proj_systemvoltage")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtsv" Width="100px" runat="server" Text='<%# Bind("proj_systemvoltage") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="Gauge"  UniqueName="proj_gauge" DataField="proj_gauge" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblga" runat="server" Text='<%# Eval("proj_gauge")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtga" Width="100px" runat="server" Text='<%# Bind("proj_gauge") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="Service Speed"  UniqueName="proj_service_speed" DataField="proj_service_speed" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblss" runat="server"  Text="Service Speed (Km/h)" width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtss" Width="100px" runat="server" Text='<%# Bind("proj_service_speed") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                     
                    <telerik:GridTemplateColumn HeaderText="Available Attachments"  UniqueName="proj_attach" DataField="proj_attach" display="false">
                           <ItemTemplate></ItemTemplate>
                           <EditItemTemplate>
                            <asp:TextBox ID="txtprojattach" Width="300px" runat="server" Text='<%# Bind("proj_attach") %>'  ReadOnly="true">
                            </asp:TextBox>
                            <asp:Button id="btn" OnClick="btn_Click" runat="server"  Text="View Attachments"/>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:gridtemplatecolumn uniquename="Upload" HeaderText="Select attachments (jpg, jpeg, pdf, txt)" Display="false">
                        <ItemTemplate></ItemTemplate>
                        <edititemtemplate>
                          <telerik:radupload id="RadUpload1" runat="server"   MaxFileInputsCount="1"  AllowedFileExtensions=".jpg,.jpeg,.pdf,.txt"
                         TargetFolder="~/Proj_AttachFiles"  ControlObjectsVisibility="None"  />
                            
                        </edititemtemplate>
                    </telerik:gridtemplatecolumn>
                                         
                      
                     <telerik:GridTemplateColumn HeaderText="Notes"  UniqueName="proj_notes" DataField="proj_notes" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblnotes" runat="server" Text='<%# Eval("proj_notes")  %>' width="300px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadTextBox ID="txtnotes" Width="500px" runat="server" Text='<%# Bind("proj_notes") %>' Height="100px" TextMode="MultiLine" >
                            </telerik:RadTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                    <telerik:GridTemplateColumn   UniqueName="uname" DataField="uname"  HeaderText="Modified By">
                          <ItemTemplate>
                            <asp:Label ID="lbluname" runat="server" Text='<%# Bind("uname") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="uname"  runat="server" Text='<%# Bind("uname") %>'  ReadOnly="true">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                
                     <telerik:GridButtonColumn UniqueName="Delete_col" Text="Delete" CommandName="Delete"
                    ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton">
                        <HeaderStyle Width="36px"></HeaderStyle>
                    </telerik:GridButtonColumn>
                </Columns>
 
 
 
 
 
               
               <DetailTables  >
               <telerik:GridTableView DataKeyNames="proj_id" ClientDataKeyNames="proj_id" HierarchyLoadMode="ServerBind"
                            Width="100%" runat="server" CommandItemDisplay="Top" Name="Details" >
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="proj_id" MasterKeyField="proj_id"></telerik:GridRelationFields>
                            </ParentTableRelation>
                            <Columns>
                             
                             <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1">
                                <HeaderStyle Width="36px"></HeaderStyle>
                            </telerik:GridEditCommandColumn>
                             
                              
 
                             <telerik:GridTemplateColumn HeaderText="ID"  UniqueName="id" DataField="id" display="false">
                                <ItemTemplate>
                                    <asp:Label ID="lblid" runat="server" Text='<%# Bind("id") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtid" Width="70px" runat="server" Text='<%# Bind("id") %>'  ReadOnly="true">
                                    </asp:TextBox>
                                </EditItemTemplate>
                            </telerik:GridTemplateColumn>
 
                              
                              <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname"
                                ListValueField="manname" UniqueName="ddl7" SortExpression="b_man_id"
                                EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true"
                                HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="b_man_id" >
                                
                            </telerik:GridDropDownColumn>
 
 
                             
 
                             <telerik:GridNumericColumn  DataField="b_contract_price" HeaderText="Contract Value(€)" 
                                UniqueName="b_contract_price"  >
                            </telerik:GridNumericColumn >
 
                              
 
                            <telerik:GridTemplateColumn   UniqueName="b_avg_price" DataField="b_avg_price"  HeaderText="Avg Price per Coach(€)">
                                  <ItemTemplate>
                                    <asp:Label ID="lblavgp" runat="server" Text='<%# Bind("b_avg_price") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <telerik:RadNumericTextBox ID="txtavgp"  runat="server" Text='<%# Bind("b_avg_price") %>' 
                                    ReadOnly="true" Width="100px" >
                                    <NumberFormat DecimalDigits="0" />
                                    </telerik:RadNumericTextBox>
                                    
                                </EditItemTemplate>
                            </telerik:GridTemplateColumn>
 
                                
 
                                 <telerik:GridButtonColumn UniqueName="Delete_col2" Text="Delete" CommandName="Delete"
                                    ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton">
                                        <HeaderStyle Width="36px"></HeaderStyle>
                                    </telerik:GridButtonColumn>
 
                            </Columns>
                            </telerik:GridTableView>
               </DetailTables>
 
 
 
                 
                <EditFormSettings>
                    <EditColumn ButtonType="ImageButton">
                    </EditColumn>
                </EditFormSettings>
                 
            </MasterTableView>
            <ClientSettings>
            <Selecting  AllowRowSelect="true"/>
            </ClientSettings>
        </telerik:RadGrid>
 
 
 
 
 
 
 
        </telerik:RadAjaxPanel>
 
</td>
</tr>
</table>
 
         
         
 
        <asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  cust_id as custid,cust_name as custname FROM customers order by cust_name">
        </asp:SqlDataSource>
 
         <asp:SqlDataSource runat="server" ID="SqlDataSource22" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
                SelectCommand="SELECT cust_name,cust_id FROM customers order by cust_name">
                </asp:SqlDataSource>
         
        <asp:SqlDataSource runat="server" ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  man_id as manid,man_name as manname FROM manufacturers order by man_name">
        </asp:SqlDataSource>
         
        <asp:SqlDataSource runat="server" ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  prod_id as prodid,prod_type as prodname FROM products order by prod_type">
        </asp:SqlDataSource>
         
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:stad_conn %>"
        DeleteCommand="DELETE FROM [projects] WHERE [ID] = @ID"
         
        InsertCommand="INSERT INTO [projects] ([proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],
                      [proj_coach_vehicle],[proj_contract_value],[proj_length],[proj_width],
                      [proj_height],[proj_passenger_seats],[proj_passenger_total],[proj_notes],
                      [uname],[proj_name],[proj_prod_id],[proj_brand],[proj_systemvoltage],[proj_gauge],[proj_service_speed])
                      VALUES (@proj_id,@proj_cust_id,@proj_man_id, @proj_date,@proj_num_of_vehicles,@proj_coach_vehicle,
                      @proj_contract_value,@proj_length, @proj_width,@proj_height,@proj_passenger_seats,
                      @proj_passenger_total,@proj_notes,@uname,@proj_name,@proj_prod_id,@proj_brand,@proj_systemvoltage,@proj_gauge,@proj_service_speed)"
                       
        SelectCommand="SELECT  [id],[proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],[proj_coach_vehicle],
                       [proj_contract_value],[proj_length],[proj_width],[proj_height] ,[proj_attach],[proj_prod_id],[proj_service_speed],
                       [proj_passenger_seats],[proj_passenger_total],[proj_notes],[uname],[proj_name],[proj_brand],[proj_systemvoltage],[proj_gauge] 
                       from projects"
         
        UpdateCommand="UPDATE [projects] SET [proj_id] = @proj_id,[proj_cust_id] = @proj_cust_id,
                        [proj_man_id] = @proj_man_id, [proj_date] = @proj_date,[proj_prod_id] = @proj_prod_id,
                      [proj_num_of_vehicles] = @proj_num_of_vehicles, [proj_coach_vehicle] = @proj_coach_vehicle,
                      [proj_contract_value] = @proj_contract_value,  [proj_service_speed] = @proj_service_speed,
                      [proj_length] = @proj_length, [proj_width] = @proj_width,
                      [proj_height] = @proj_height, [proj_passenger_seats] = @proj_passenger_seats,
                      [proj_passenger_total] = @proj_passenger_total, [proj_notes] = @proj_notes,[proj_name]=@proj_name,
                      [proj_brand]=@proj_brand,[proj_systemvoltage]=@proj_systemvoltage,[proj_gauge]=@proj_gauge
                      WHERE [ID] = @ID">
        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_name" Type="String"></asp:Parameter>
            <asp:Parameter Name="uname" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_id" Type="String"></asp:Parameter>
        </InsertParameters>
        <UpdateParameters>
           <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter>
           <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter>
             <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter>
             <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_name" Type="String"></asp:Parameter>
            <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
        </UpdateParameters>
    </asp:SqlDataSource>
     
 </form>
</body>
</html>
since a subgrid was added I am unable to make the filter working. Any help will be appreciated.
What should I do /change to make the filter working again?

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 05 Nov 2013, 08:43 AM
Hello Felice,

Thank you for contacting us.

I noticed that you are nested RadAjaxManager inside RadAjaxPanel. Note that ajaxifing a single control by RadAjaxManager and RadAjaxPanel simultaneously is not supported scenario and you have to use one of the them. I would recommend you to remove the RadAjaxPanel and leave only the RadAjaxManager. Check out the following code snippet.
<table width="100%">
            <tr>
                <td>
                        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" ClientEvents-OnRequestStart="conditionalPostback" 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" Skin="Telerik">
                        </telerik:RadAjaxLoadingPanel>
.......

Additionally I would recommend you to review the following help articles which elaborates more on this matter.
RadAjaxPanel
RadAjaxManager

I hope this information proves helpful.

Regards,
Kostadin
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Grid
Asked by
Felice
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or