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

[Solved] Problem with firecommand on detail grid

1 Answer 125 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Yano
Top achievements
Rank 1
Yano asked on 23 Sep 2009, 11:03 AM
Hello, I have problem with sending some values from Radwindow to Detailgrid (Radgrid2) with this command:
                    
                    var MasterTable = $find("<%= RadGrid2.ClientID %>").get_masterTableView();  
                    alert( MasterTable.get_id() );
                    MasterTable.fireCommand("InsertEditValue",zobraz + "|" + guid); 
It seems that firecommand working only with one Grid on the page..  
Is there anything what im doing wrong? I have no clue..

<script type ="text/jscript" language="JavaScript" src="../Scripts.js"></script>  
      
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">  
        <script type="text/javascript">  
            //<![CDATA[
            function openWin()
            {
                var oWnd = radopen(null, "RadWindow1");
            }        
            function OnClientClose(oWnd,args)
            {
                var arg = args.get_argument();
                if(arg)
                { 
                   var guid   = arg.mestoGuid;
                   var zobraz = arg.mestoText;
  
                    var MasterTable = $find("<%= RadGrid2.ClientID %>").get_masterTableView();  
                    alert( MasterTable.get_id() );
                    MasterTable.fireCommand("InsertEditValue",zobraz + "|" + guid); 
                }
            }
            //]]>  
        </script>  
          
    </telerik:RadCodeBlock>     
  
    <telerik:RadWindowManager ID="RadWindowManager1" ShowContentDuringLoad="False" VisibleStatusbar="False"  
        ReloadOnShow="True" runat="server" Skin="Sunset" Left="" meta:resourcekey="RadWindowManager1Resource1"   
        style="display: none;" Top="">  
        <Windows>  
            <telerik:RadWindow ID="RadWindow1" runat="server" Behaviors="Close" OnClientClose="OnClientClose"   
             Height = "220px" Width = "360px" NavigateUrl="~/Template/Adresy.aspx?UlicaReadOnly=true&CisloDomuReadOnly=true"   
                meta:resourcekey="RadWindow1Resource1" />  
        </Windows>  
    </telerik:RadWindowManager>         
  
<!-- Ajax -->    
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">  
        <AjaxSettings>  
            <telerik:AjaxSetting AjaxControlID="RadGrid1">  
                <UpdatedControls>                      
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />  
                    <telerik:AjaxUpdatedControl ControlID="RadGrid2" LoadingPanelID="RadAjaxLoadingPanel1"/>  
                </UpdatedControls>                  
            </telerik:AjaxSetting>  
        </AjaxSettings>  
        <ClientEvents OnRequestStart="RequestStart" />  
    </telerik:RadAjaxManager>   
 
<!-- MASTER grid -->     
    <cn:CustomGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" OnInit="Set1" CommandItemDisplay="Top" meta:resourcekey="GridView1Resource1" >  
        <ClientSettings allowkeyboardnavigation="true" enablepostbackonrowclick="true">  
            <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" />              
            <Selecting AllowRowSelect="true" />  
        </ClientSettings>             
        <mastertableview datakeynames="JJTE_TYPEN, UZSUS" datasourceid="SqlDataSource1" >  
            <Columns>                                
               ...mastertableviem column...  
            </Columns>  
        </mastertableview>  
    </cn:CustomGrid>  
<br />  
  
<!-- DETAIL grid -->    
    <cn:CustomGrid ID="RadGrid2" runat="server" DataSourceID="SqlDataSource4" OnInit="Set2" CommandItemDisplay="Top" meta:resourcekey="GridView2Resource1" >  
        <ClientSettings allowkeyboardnavigation="true" enablepostbackonrowclick="true">  
            <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" />              
            <Selecting AllowRowSelect="true" />  
        </ClientSettings>    
        <mastertableview datakeynames="JUZS_JJTE_TYPEN, JUZS_UZSUS, GIID_CELOK" datasourceid="SqlDataSource4">  
            <Columns>                      
                <telerik:GridTemplateColumn meta:resourcekey="GridTemplateColumnResource20" ItemStyle-Width ="150px" SortExpression="ADRESA" UniqueName="ADRESA" >  
                    <ItemTemplate>  
                        <%# DataBinder.Eval(Container.DataItem, "MESTO")%>   
                    </ItemTemplate>    
                    <EditItemTemplate>                          
                       <telerik:RadTextBox ID="ADRESA"  runat="server" Width="200px" onclick="openWin(); return false;" AutoPostBack="true" Text='<%# Bind("MESTO") %>' />                      
                    </EditItemTemplate>                        
                </telerik:GridTemplateColumn>  
                  
                <telerik:GridBoundColumn DataField="KRAJ" meta:resourcekey="GridBoundColumnResource21"  
                    SortExpression="KRAJ" UniqueName="KRAJ" ItemStyle-Width ="100px">  
                </telerik:GridBoundColumn>   
                  
            </Columns>  
        </mastertableview>  
    </cn:CustomGrid>           
      
<!-- Data source -->      
    <cn:CustomSqlDataSource ID="SqlDataSource1" runat="server"   
        ConnectionString="<%$ ConnectionStrings:Jishm %>"   
        ProviderName="<%$ ConnectionStrings:Jishm.ProviderName %>"   
        OldValuesParameterFormatString="old_{0}"   
        SelectCommand="SELECT jjus.UZSUS, jjus.SKRATKA, jjus.JJTE_TYPEN ,jjte.SKRATKA jjte_skratka, jjus.POPIS, jjus.POZNAMKA  
                                , jjus.JUZS_JJTE_TYPEN, jjus.JUZS_UZSUS  
                                , jjte2.SKRATKA juzs_jjte_skratka2, jjus2.SKRATKA juzs_skratka2  
                                , jjus.AKTUAL, jj$#pck_funkcie.fn_domena_hodnota('TRUE_FALSE',jjus.AKTUAL,[P_JAZYK]) AKT_P, nvl(JJPO.MENOPRIEZVISKO, 'nepr. ('|| jjus.UZIVATEL ||')') UZIVATEL, jjus.DATUM_DML  
                                , jjus.JUZS_JJTE_TYPEN ||'|'|| jjus.JUZS_UZSUS JJUZ_PK2  
                                , jjte2.SKRATKA  ||' ' ||jjus2.SKRATKA JJTE_JJUZ2  
                        FROM JJUZLSUY jjus  
                           , JJUZLSUY jjus2  
                           , JJTYPENY jjte  
                           , JJTYPENY jjte2  
                           , JJPOUZIVATEL_VIEW JJPO  
                        WHERE jjus.JJTE_TYPEN = jjte.TYPEN  
                        AND jjus.UZIVATEL = JJPO.LOGIN(+)  
                        and jjus.JUZS_JJTE_TYPEN = jjte2.TYPEN(+)  
                        and jjus.JUZS_UZSUS = jjus2.UZSUS(+)  
                        ORDER BY jjus.JJTE_TYPEN, jjus.UZSUS"  
        InsertCommand="INSERT INTO JJUZLSUY( JJTE_TYPEN, UZSUS, SKRATKA, POPIS, JUZS_JJTE_TYPEN, JUZS_UZSUS, POZNAMKA, AKTUAL, UZIVATEL, DATUM_DML )   
                        VALUES ( [JJTE_TYPEN], [UZSUS],[SKRATKA], [POPIS], [JUZS_JJTE_TYPEN], [JUZS_UZSUS], [POZNAMKA], [AKTUAL], [P_USER], SYSDATE )"   
        UpdateCommand="UPDATE JJUZLSUY SET  
                            SKRATKA         = [SKRATKA]  
                          , POPIS           = [POPIS]    
                          , JUZS_JJTE_TYPEN = [JUZS_JJTE_TYPEN]  
                          , JUZS_UZSUS  = [JUZS_UZSUS]  
                          , POZNAMKA    = [POZNAMKA]   
                          , AKTUAL      = [AKTUAL]  
                          , UZIVATEL  = [P_USER]  
                          , DATUM_DML = sysdate  
                        WHERE JJTE_TYPEN = [old_JJTE_TYPEN]  
                        AND UZSUS = [old_UZSUS]"  
        DeleteCommand="DELETE FROM JJUZLSUY WHERE UZSUS = [old_UZSUS] AND JJTE_TYPEN = [old_JJTE_TYPEN]">     
    
        <SelectParameters>   
            <asp:ControlParameter Name="P_JAZYK" ControlID="__Page" PropertyName="Jazyk" Type="String" Size="250" Direction="Input" />   
        </SelectParameters>  
          
        <InsertParameters>  
            <asp:ControlParameter  Name="P_USER" ControlID="__Page" PropertyName="UserName" Type="String" Size="250" />  
            <asp:Parameter Name="JJTE_TYPEN" Type="Int32" Size="2" />  
            <asp:Parameter Name="UZSUS" Type="Int32" Size="2" />    
            <asp:Parameter Name="SKRATKA" Type="String" Size="10" />   
            <asp:Parameter Name="POPIS" Type="String" Size="50" />  
            <asp:Parameter Name="JUZS_JJTE_TYPEN" Type="Int32" Size="2" />  
            <asp:Parameter Name="JUZS_UZSUS" Type="Int32" Size="2" />     
            <asp:Parameter Name="POZNAMKA" Type="String" Size="500" />   
            <asp:Parameter Name="AKTUAL" Type="String" Size="5" />                
        </InsertParameters>          
        <UpdateParameters>  
            <asp:ControlParameter  Name="P_USER" ControlID="__Page" PropertyName="UserName" Type="String" Size="250" />   
            <asp:Parameter Name="old_JJTE_TYPEN" Type="Int32" Size="2" />   
            <asp:Parameter Name="old_UZSUS" Type="Int32" Size="2" />                    
            <asp:Parameter Name="SKRATKA" Type="String" Size="10"  />    
            <asp:Parameter Name="POPIS" Type="String" Size="50"  />   
            <asp:Parameter Name="JUZS_JJTE_TYPEN" Type="Int32" Size="2" />   
            <asp:Parameter Name="JUZS_UZSUS" Type="Int32" Size="2" />   
            <asp:Parameter Name="POZNAMKA" Type="String" Size="500" />    
            <asp:Parameter Name="AKTUAL" Type="String" Size="5" />   
        </UpdateParameters>  
        <DeleteParameters>  
            <asp:ControlParameter Name="old_UZSUS" ControlID="RadGrid1" PropertyName="SelectedValue" Type="Int32" Size="2"  />   
            <asp:ControlParameter Name="old_JJTE_TYPEN" ControlID="RadGrid1" PropertyName="SelectedValue" Type="Int32" Size="2"  />   
        </DeleteParameters>       
                  
    </cn:CustomSqlDataSource>   
      
    <cn:CustomSqlDataSource ID="SqlDataSource2" runat="server"   
        ConnectionString="<%$ ConnectionStrings:Jishm %>"   
        ProviderName="<%$ ConnectionStrings:Jishm.ProviderName %>"   
        SelectCommand="SELECT TYPEN, SKRATKA, POPIS   
                        FROM JJTYPENY   
                        WHERE AKTUAL = 'TRUE' ORDER BY TYPEN">  
    </cn:CustomSqlDataSource>  
          
    <cn:CustomSqlDataSource ID="SqlDataSource4" runat="server"   
        ConnectionString="<%$ ConnectionStrings:Jishm %>"   
        ProviderName="<%$ ConnectionStrings:Jishm.ProviderName %>"  
        OldValuesParameterFormatString="old_{0}"   
        SelectCommand="SELECT  jjuza.JUZS_JJTE_TYPEN  
                        ,jjuza.JUZS_UZSUS  
                        ,rawtoguid(jjuza.GIID_CELOK) GIID_CELOK  
                        , jjuc.KRAJ  
                        , jjuc.MESTO   
                        ,jjuza.AKTUAL  
                        , jj$#pck_funkcie.fn_domena_hodnota('TRUE_FALSE',jjuza.AKTUAL,[P_JAZYK]) AKT_P  
                        , nvl(JJPO.MENOPRIEZVISKO, 'nepr. ('|| jjuza.UZIVATEL ||')') UZIVATEL  
                        ,jjuza.DATUM_DML  
                        FROM JJUZSADR jjuza, JJ_UZEMNY_CELOK_POPIS_VIEW jjuc, JJPOUZIVATEL_VIEW JJPO  
                        WHERE rawtoguid(jjuza.GIID_CELOK) = rawtoguid(jjuc.GUID_CELOK)    
                        AND jjuza.UZIVATEL = JJPO.LOGIN(+)  
                        AND jjuza.JUZS_JJTE_TYPEN = [JJTE_TYPEN]  
                        AND jjuza.JUZS_UZSUS      = [UZSUS]  
                        order by jjuc.CELOK_SKRATKA asc"  
                          
        InsertCommand="INSERT INTO JJUZSADR (JUZS_JJTE_TYPEN, JUZS_UZSUS, GIID_CELOK, AKTUAL, UZIVATEL, DATUM_DML)   
                                    VALUES([JUZS_JJTE_TYPEN], [JUZS_UZSUS], [GIID_CELOK], [AKTUAL], [P_USER], sysdate)"                                       
        OnInserting = "SqlDataSource4_Inserting"                                        
                                      
        UpdateCommand="UPDATE JJUZSADR SET   AKTUAL      = [AKTUAL]  
                                            ,UZIVATEL    = [P_USER]  
                                            ,DATUM_DML   = sysdate  
                                            WHERE JUZS_JJTE_TYPEN = [old_JUZS_JJTE_TYPEN]  
                                            AND JUZS_UZSUS        = [old_JUZS_UZSUS]"                                                                     
  
        DeleteCommand="DELETE FROM JJUZSADR WHERE JUZS_JJTE_TYPEN = [old_JUZS_JJTE_TYPEN]  
                                            AND JUZS_UZSUS        = [old_JUZS_UZSUS]">  
                          
        <SelectParameters>      
            <asp:ControlParameter Name="P_JAZYK" ControlID="__Page" PropertyName="Jazyk" Type="String" Size="250" Direction="Input" />       
            <asp:ControlParameter ControlID="RadGrid1" Name="JJTE_TYPEN" DefaultValue="0" PropertyName="SelectedValues['JJTE_TYPEN']" Type="Int32" />  
            <asp:ControlParameter ControlID="RadGrid1" Name="UZSUS" DefaultValue="0" PropertyName="SelectedValues['UZSUS']" Type="Int32" />  
        </SelectParameters>      
          
        <InsertParameters>  
            <asp:ControlParameter  Name="P_USER" ControlID="__Page" PropertyName="UserName" Type="String" Size="250" />  
            <asp:ControlParameter ControlID="RadGrid1" Name="JUZS_JJTE_TYPEN" DefaultValue="0" PropertyName="SelectedValues['JJTE_TYPEN']" Type="Int32" />  
            <asp:ControlParameter ControlID="RadGrid1" Name="JUZS_UZSUS" DefaultValue="0" PropertyName="SelectedValues['UZSUS']" Type="Int32" />   
            <asp:Parameter Name="GIID_CELOK" Type="String" Size="32" />               
            <asp:Parameter Name="AKTUAL" Type="String" Size="50" />                           
        </InsertParameters>      
          
        <UpdateParameters>  
            <asp:ControlParameter  Name="P_USER" ControlID="__Page" PropertyName="UserName" Type="String" Size="250" />  
            <asp:Parameter Name="AKTUAL" Type="String" Size="50" />    
            <asp:Parameter Name="old_JUZS_JJTE_TYPEN" Type="Int32" />    
            <asp:Parameter Name="old_JUZS_UZSUS" Type="Int32" />                 
        </UpdateParameters>                  
          
        <DeleteParameters>  
            <asp:Parameter Name="old_ODBMIE" Type="String" Size="20" />                
        </DeleteParameters>        
    </cn:CustomSqlDataSource>  
 
 

1 Answer, 1 is accepted

Sort by
0
Tsvetoslav
Telerik team
answered on 26 Sep 2009, 08:37 AM
Hello Yano,

This behavior is not expected as evidenced by the attached sample. If the problem persists, I'd ask you to isolate the problem in a small runnable test project, open up a formal support ticket and send it to us for closer inspection and debugging.

I hope this helps.

Regards,
Tsvetoslav
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.
Tags
Grid
Asked by
Yano
Top achievements
Rank 1
Answers by
Tsvetoslav
Telerik team
Share this question
or