rebinding data grid

2 posts, 1 answers
  1. Webster Velasco
    Webster Velasco avatar
    114 posts
    Member since:
    Jun 2012

    Posted 01 Mar 2010 Link to this post

    hi

    i have a problem on rebinding my 2nd datagrid..

    here what i really want.. i want to rebind my "grdOrdini" on click at "grdListini -> btnAdd" but it doesnt work.. i tried anything looking to any demos available on your site

    here is the code:

    html:
    <%@ Page Language="vb" MasterPageFile="~/Main.Master" AutoEventWireup="false" CodeBehind="ElencoOrdini.aspx.vb" Inherits="GRC30.ElencoOrdini" %> 
     
    <asp:Content ID="congrcElencoOrdini" ContentPlaceHolderID="cphMain" Runat="Server"
        <div style="height:100%"
            <!-- inizio contenuto --> 
            <!-- content start --> 
            <telerik:RadAjaxManager ID="RadAjaxManager2" runat="server"
                <AjaxSettings> 
                    <telerik:AjaxSetting AjaxControlID="grdListini"
                        <UpdatedControls> 
                            <telerik:AjaxUpdatedControl ControlID="grdListini" /> 
                        </UpdatedControls> 
                    </telerik:AjaxSetting>   
                    <telerik:AjaxSetting AjaxControlID="grdOrdini"
                        <UpdatedControls> 
                            <telerik:AjaxUpdatedControl ControlID="grdOrdini" /> 
                        </UpdatedControls> 
                    </telerik:AjaxSetting>                               
                </AjaxSettings> 
            </telerik:RadAjaxManager> 
            <table width="100%" align="center" border="0"
                <tr> 
                    <th align="center" class="tbContorno"><asp:Label runat="server" ID="lblTitolo" Text="Elenco Servizi Offerti" />  
                    </th> 
                </tr> 
                <tr> 
                    <td>         
                        <telerik:RadGrid ID="grdListini" DataSourceID="objDS" runat="server" Width="99.7%" 
                            AutoGenerateColumns="False" PageSize="10" AllowSorting="True" AllowPaging="True" 
                            GridLines="None" ShowStatusBar="true"
                            <PagerStyle Mode="NumericPages"></PagerStyle> 
                            <MasterTableView DataSourceID="objDS" DataKeyNames="CODICE" AllowMultiColumnSorting="True" 
                                Width="100%"
                                <Columns> 
                                    <telerik:GridTemplateColumn> 
                                        <ItemTemplate> 
                                            <asp:ImageButton runat="server" ID="BtnAdd" OnClick="btnAddclick" ImageUrl="~/img/addCart.png" ToolTip="Aggiungi nell'elenco ordine" /> 
                                        </ItemTemplate> 
                                    </telerik:GridTemplateColumn> 
                                    <telerik:GridBoundColumn SortExpression="CODICE" HeaderText="Codice" DataField="CODICE" UniqueName="colCODICE" Visible="false"
                                    </telerik:GridBoundColumn>                 
                                    <telerik:GridBoundColumn SortExpression="DESCRIZIONE" HeaderText="Descrizione" DataField="DESCRIZIONE" UniqueName="colDESCRIZIONE"
                                    </telerik:GridBoundColumn> 
                                    <telerik:GridBoundColumn SortExpression="COSTO" HeaderText="Prezzo" DataField="COSTO" UniqueName="colCOSTO"
                                    </telerik:GridBoundColumn> 
                                    <telerik:GridDateTimeColumn SortExpression="DTDA" HeaderText="Valido dal" DataField="DTDA" UniqueName="colDTDA"
                                    </telerik:GridDateTimeColumn> 
                                    <telerik:GridDateTimeColumn SortExpression="DTA" HeaderText="Valido al" DataField="DTA" UniqueName="colDTA"
                                    </telerik:GridDateTimeColumn> 
                                    <telerik:GridBoundColumn SortExpression="DURATA" HeaderText="Durata" DataField="DURATA" UniqueName="colDURATA"
                                    </telerik:GridBoundColumn>                                         
                                </Columns> 
                            </MasterTableView> 
                        </telerik:RadGrid>    
                    </td> 
                </tr> 
                <tr> 
                    <td style="height:10px">&nbsp;</td> 
                </tr> 
                <tr> 
                    <th align="center" class="tbContorno"><asp:Label runat="server" ID="Label1" Text="Elenco Ordini" />  
                    </th> 
                </tr> 
                <tr> 
                    <td>         
                        <telerik:RadGrid ID="grdOrdini" DataSourceID="objDSOrd" runat="server" Width="99.7%" 
                            AutoGenerateColumns="False" PageSize="15" AllowSorting="True" AllowPaging="True" 
                            GridLines="None" ShowStatusBar="true" AllowAutomaticUpdates="true" EnableViewState="false"
                            <PagerStyle Mode="NumericPages"></PagerStyle> 
                            <MasterTableView DataSourceID="objDSOrd" DataKeyNames="CODICE" AllowMultiColumnSorting="True" 
                                Width="100%"
                                <Columns> 
                                    <telerik:GridButtonColumn ConfirmText="Rimouvere dal Elenco degli ordini?" ButtonType="ImageButton" ImageUrl="~/img/DelCart.png" CommandName="Delete" Text="Rimouvi dal elenco" UniqueName="colDelete"
                                        <HeaderStyle Width="35px" /> 
                                    </telerik:GridButtonColumn>                              
                                    <telerik:GridEditCommandColumn EditImageUrl="~/img/Edit.gif" UniqueName="btnEdit" CancelText="Cancel" UpdateText="Save" EditText="Modifica"></telerik:GridEditCommandColumn>                           
                                    <telerik:GridBoundColumn SortExpression="LISTINO" HeaderText="Listino" DataField="LISTINO" UniqueName="colLISTINO" ReadOnly="true"
                                    </telerik:GridBoundColumn>                 
                                    <telerik:GridBoundColumn SortExpression="DTORDINE" HeaderText="Data Ordine" DataField="DTORDINE" UniqueName="colDTORDINE" DataType="System.DateTime" DataFormatString="{0: dd/MM/yyyy}" ReadOnly="true"
                                    </telerik:GridBoundColumn> 
                                    <telerik:GridBoundColumn SortExpression="DTSCADENZA" HeaderText="Data Scadenza" DataField="DTSCADENZA" UniqueName="colDTSCADENZA" DataType="System.DateTime" DataFormatString="{0: dd/MM/yyyy}" ReadOnly="true"
                                    </telerik:GridBoundColumn> 
                                    <telerik:GridNumericColumn SortExpression="QUANTITA" HeaderText="Q.tà" DataField="QUANTITA" UniqueName="colQUANTITA"
                                    </telerik:GridNumericColumn> 
                                    <telerik:GridNumericColumn SortExpression="COSTOUNITARIO" HeaderText="Costo Unitario" DataField="COSTOUNITARIO" UniqueName="colCOSTOUNITARIO" DataType="System.Double" DataFormatString="{0:€ # ###.##}" ReadOnly="true"
                                    </telerik:GridNumericColumn> 
                                    <telerik:GridNumericColumn SortExpression="SCONTO" HeaderText="Sconto %" DataField="SCONTO" UniqueName="colSCONTO" ReadOnly="true" DataType="System.Double" DataFormatString="{0: ###.##%}"
                                    </telerik:GridNumericColumn> 
                                    <telerik:GridNumericColumn SortExpression="COSTONETTO" HeaderText="Costo Netto" DataField="COSTONETTO" UniqueName="colCOSTONETTO" NumericType="Currency" DataType="System.Double" DataFormatString="{0:€ # ###.##}" ReadOnly="true"
                                    </telerik:GridNumericColumn>                                         
                                </Columns> 
                            </MasterTableView> 
                        </telerik:RadGrid>    
                    </td> 
                </tr>             
                <tr> 
                    <asp:Label ID="lblErrorMsg" runat="server" /> 
                </tr> 
            </table>                       
            <!-- fine --> 
        <asp:ObjectDataSource  
            ID="objDS"  
            runat="server"  
            SelectMethod="SelectListino" 
            SortParameterName="orderBy"      
            TypeName="GestioneElenco" > 
            <SelectParameters>  
                <asp:ControlParameter ControlID="grdListini" Name="filterBy" PropertyName="MasterTableView.FilterExpression" Type="String" />  
                <asp:Parameter Name="NomeSP" DefaultValue="Web2k5_CommittenteListiniElenco" Type="String" /> 
                <asp:Parameter Name="committ" Type="int32" /> 
            </SelectParameters>  
        </asp:ObjectDataSource> 
         
        <asp:ObjectDataSource  
            ID="objDSOrd"  
            runat="server"  
            SelectMethod="SelectListino" 
            SortParameterName="orderBy"      
            TypeName="GestioneElenco" > 
            <SelectParameters>  
                <asp:ControlParameter ControlID="grdOrdini" Name="filterBy" PropertyName="MasterTableView.FilterExpression" Type="String" />  
                <asp:Parameter Name="NomeSP" DefaultValue="Web2k5_CommittenteOrdiniElenco" Type="String" /> 
                <asp:Parameter Name="committ" Type="int32" /> 
            </SelectParameters>  
        </asp:ObjectDataSource> 
     
        </div> 
    </asp:Content> 
     

    code behind:
    Imports Telerik.Web.UI 
    Partial Public Class ElencoOrdini 
        Inherits System.Web.UI.Page 
     
        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 
            If Not IsPostBack Then 
                'reset the states 
                'Me.Session(_gridState.SessionKey) = _gridState 
                If Session("grcCodice") <> Nothing Then 
                    objDS.SelectParameters("committ").DefaultValue = Session("grcCodice") 
                    objDSOrd.SelectParameters("committ").DefaultValue = Session("grcCodice") 
                Else 
                    Response.Redirect("Login.aspx?action=Scad") 
                End If 
            End If 
        End Sub 
     
        Protected Sub btnAddclick(ByVal sender As Object, ByVal e As ImageClickEventArgs) 
            Dim btn As ImageButton = sender 
     
            ReDim param(1) 
            ReDim paramVal(1) 
     
            param(0) = "COMMITTENTE" 
            If Session("grcCodice") <> Nothing Then 
                paramVal(0) = Session("grcCodice") 
            Else 
                Response.Redirect("Login.aspx?action=Scad") 
            End If 
     
            param(1) = "LISTINO" 
            paramVal(1) = btn.CommandArgument 
     
            ApriConnessioni() 
            EseguiStored("Web2k5_CommittentiOrdiniInsert", param, paramVal, kAggiornaDati, True) 
            If TestoMessaggio.Length > 0 Then 
                lblErrorMsg.Text = TestoMessaggio 
                ChiudiConnessioni() 
                Exit Sub 
            End If 
            ChiudiConnessioni() 
     
            RadAjaxManager2.RaisePostBackEvent("rebind") 
        End Sub 
     
        Protected Sub RadAjaxManager1_AjaxRequest(ByVal sender As Object, ByVal e As Telerik.Web.UI.AjaxRequestEventArgs) Handles RadAjaxManager2.AjaxRequest 
            grdOrdini.Rebind() 
            grdOrdini.MasterTableView.Rebind() 
        End Sub 
        Protected Sub grdListini_ItemCreated(ByVal sender As Object, ByVal e As GridItemEventArgs) Handles grdListini.ItemCreated 
            Try 
                If TypeOf e.Item Is GridDataItem Then 
                    Dim BtnAdd As ImageButton = DirectCast(e.Item.FindControl("BtnAdd"), ImageButton) 
                    Dim idCA As String = DirectCast(e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("CODICE"), String) 
                    BtnAdd.CommandArgument = idCA 
                End If 
            Catch ex As Exception 
                SentMessage("Error ItemCreated: " & ex.Message) 
            End Try 
        End Sub 
     
        Private Sub DisplayMessage(ByVal text As String, ByVal grd As RadGrid) 
            grd.Controls.Add(New LiteralControl(String.Format("<span style='color:red'>{0}</span>", "<br />" & text))) 
        End Sub 
     
        Private gridMessage As String = Nothing 
        Protected Sub grdPap_DataBound(ByVal sender As Object, ByVal e As EventArgs) Handles grdListini.DataBound 
            If Not String.IsNullOrEmpty(gridMessage) Then 
                DisplayMessage(gridMessage, grdListini) 
            End If 
        End Sub 
     
        Private Sub SentMessage(ByVal text As String) 
            gridMessage = text 
        End Sub 
     
    End Class 







  2. Answer
    Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 02 Mar 2010 Link to this post

    Hi,

    You need to modify your Ajax Settings. Inorder for the grid  grdListini to update grdOrdini you need to have the Ajax setting as  shown below:

    ASPX:
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"
                <ajaxsettings> 
                    <telerik:AjaxSetting AjaxControlID="grdListni"
                        <UpdatedControls> 
                            <telerik:AjaxUpdatedControl ControlID="grdListini" /> 
                            <telerik:AjaxUpdatedControl ControlID="grdOrdini" /> 
                          
                        </UpdatedControls> 
                    </telerik:AjaxSetting> 

    For more info refer to the demo link below:

    Hope this helps.

    Thanks,
    Princy
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top