[CLOSED] GridPanel: getting selectedrows (CheckboxSelectionModel) and loop through them from code behind (C#)

  1. #1

    [CLOSED] GridPanel: getting selectedrows (CheckboxSelectionModel) and loop through them from code behind (C#)

    Please, consider the following example
    I use CheckBoxSelectionModel to select rows

    I use a DirectEvent in a button to pass via extraparams the selected rows, in the following way:

    
                        <ext:Button ID="btnAction" runat="server" Text="Accept" Icon="Accept">
                            <DirectEvents>
                                <Click OnEvent="SubmitGrids">
                                    <ExtraParams>
                                        <ext:Parameter Name="Testata" Value="Ext.encode(#{GridPanel1}.getRowsValues({selectedOnly : true}))"
                                            Mode="Raw" />
                                    </ExtraParams>
                                </Click>
                            </DirectEvents>
                        </ext:Button>

    If I use selectedOnly : true I get no rows in code behind. On the contrary I get the rows when I use selectedOnly : false

    Can You give please a tip ?

    
    <%@ Page Language="C#" CodeFile="Default.aspx.cs" Inherits="Default" %>
    
    <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
    <!DOCTYPE html>
    <html>
    <head id="Head1" runat="server">
        <title>RowExpander with FormPanel Detail - Ext.NET Examples</title>
        <link href="/resources/css/examples.css" rel="stylesheet" />
        <ext:ResourcePlaceHolder ID="ResourcePlaceHolder1" runat="server" Mode="Script" />
        <style>
            .white-footer .x-toolbar-footer
            {
                background-color: white !important;
            }
        </style>
        <script>
            var template = '<span style="color:{0};">{1}</span>';
    
            var change = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value);
            };
    
            var pctChange = function (value) {
                return Ext.String.format(template, (value > 0) ? "green" : "red", value + "%");
            };
        </script>
    </head>
    <body>
        <form id="Form1" runat="server">
        <ext:ResourceManager ID="ResourceManager1" runat="server" />
        <h1>
            RowExpander Plugin with FormPanel Detail</h1>
        <ext:GridPanel ID="GridPanel1" runat="server" Title="Expander Rows with control"
            Collapsible="true" AnimCollapse="true" Icon="Table" Width="600" Height="350">
            <Store>
                <ext:Store ID="Store1" runat="server" IgnoreExtraFields="false" PageSize="10">
                    <Model>
                        <ext:Model ID="Model1" runat="server">
                            <Fields>
                                <ext:ModelField Name="company" />
                                <ext:ModelField Name="price" Type="Float" />
                                <ext:ModelField Name="change" Type="Float" />
                                <ext:ModelField Name="pctChange" Type="Float" />
                                <ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
                                <ext:ModelField Name="industry" />
                            </Fields>
                        </ext:Model>
                    </Model>
                </ext:Store>
            </Store>
            <SelectionModel>
                <ext:CheckboxSelectionModel ID="CheckboxSelectionModel1" AllowDeselect="true" runat="server"
                    Mode="Multi" />
            </SelectionModel>
            <ColumnModel ID="ColumnModel1" runat="server">
                <Columns>
                    <ext:Column ID="Column1" runat="server" Text="Company" DataIndex="company" Flex="1" />
                    <ext:Column ID="Column2" runat="server" Text="Price" DataIndex="price">
                        <Renderer Format="UsMoney" />
                    </ext:Column>
                    <ext:Column ID="Column3" runat="server" Text="Change" DataIndex="change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column ID="Column4" runat="server" Text="Change" DataIndex="pctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:DateColumn ID="DateColumn1" runat="server" Text="Last Updated" DataIndex="lastChange"
                        Format="yyyy/MM/dd" />
                </Columns>
            </ColumnModel>
            <Plugins>
                <ext:RowExpander ID="RowExpander1" runat="server" SingleExpand="false">
                    <Component>
                        <ext:FormPanel ID="FormPanel1" runat="server" BodyPadding="6" Height="180" Border="false"
                            DefaultAnchor="-5" Cls="white-footer">
                            <Items>
                                <ext:TextField ID="TextField1" runat="server" Name="company" FieldLabel="Company" />
                                <ext:NumberField ID="NumberField1" runat="server" Name="price" FieldLabel="Price" />
                                <ext:NumberField ID="NumberField2" runat="server" Name="change" FieldLabel="Change" />
                                <ext:NumberField ID="NumberField3" runat="server" Name="pctChange" FieldLabel="% Change" />
                                <ext:DateField ID="DateField1" runat="server" Name="lastChange" FieldLabel="Last Updated"
                                    Format="yyyy/MM/dd" />
                            </Items>
                            <Listeners>
                                <AfterRender Handler="this.getForm().loadRecord(this.record);" />
                            </Listeners>
                            <Buttons>
                                <ext:Button ID="Button1" runat="server" Text="Save" Icon="Disk">
                                    <Listeners>
                                        <Click Handler="var grid = this.up('grid'), form = this.up('form');
                                                            grid.getRowExpander().collapseRow(grid.store.indexOf(form.record));
                                                            form.getForm().updateRecord(form.record);" />
                                    </Listeners>
                                </ext:Button>
                                <ext:Button ID="Button2" runat="server" Text="Cancel" Icon="Decline">
                                    <Listeners>
                                        <Click Handler="var grid = this.up('grid'), form = this.up('form');
                                                            grid.getRowExpander().collapseRow(grid.store.indexOf(form.record));" />
                                    </Listeners>
                                </ext:Button>
                            </Buttons>
                        </ext:FormPanel>
                    </Component>
                </ext:RowExpander>
            </Plugins>
            <TopBar>
                <ext:Toolbar ID="Toolbar3" runat="server">
                    <Items>
                        <ext:Button ID="btnAction" runat="server" Text="Accept" Icon="Accept">
                            <DirectEvents>
                                <Click OnEvent="SubmitGrids">
                                    <ExtraParams>
                                        <ext:Parameter Name="Testata" Value="Ext.encode(#{GridPanel1}.getRowsValues({selectedOnly : true}))"
                                            Mode="Raw" />
                                    </ExtraParams>
                                </Click>
                            </DirectEvents>
                        </ext:Button>
                    </Items>
                </ext:Toolbar>
            </TopBar>
            <BottomBar>
                <ext:PagingToolbar ID="PagingToolbar1" runat="server" />
            </BottomBar>
        </ext:GridPanel>
        </form>
    </body>
    </html>

    with following behind code

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using Ext.Net;
    using System.Xml;
    
    public partial class Default : MainInherit
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (X.IsAjaxRequest)
            {
                //We do not need to DataBind on an DirectEvent
                return;
            }
    
            this.Store1.DataSource = new object[]
                {
                    new object[] { "3m Co", 71.72, 0.02, 0.03, "9/1 12:00am", "Manufacturing"},
                    new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, "9/1 12:00am", "Manufacturing"},
                    new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, "9/1 12:00am", "Manufacturing"},
                    new object[] { "American Express Company", 52.55, 0.01, 0.02, "9/1 12:00am", "Finance"},
                    new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, "9/1 12:00am", "Services"},
                    new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, "9/1 12:00am", "Services"},
                    new object[] { "Boeing Co.", 75.43, 0.53, 0.71, "9/1 12:00am", "Manufacturing"},
                    new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, "9/1 12:00am", "Services"},
                    new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, "9/1 12:00am", "Finance"},
                    new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, "9/1 12:00am", "Manufacturing"},
                    new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, "9/1 12:00am", "Manufacturing"},
                    new object[] { "General Electric Company", 34.14, -0.08, -0.23, "9/1 12:00am", "Manufacturing"},
                    new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, "9/1 12:00am", "Automotive"},
                    new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, "9/1 12:00am", "Computer"},
                    new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, "9/1 12:00am", "Manufacturing"},
                    new object[] { "Intel Corporation", 19.88, 0.31, 1.58, "9/1 12:00am", "Computer"},
                    new object[] { "International Business Machines", 81.41, 0.44, 0.54, "9/1 12:00am", "Computer"},
                    new object[] { "Johnson & Johnson", 64.72, 0.06, 0.09, "9/1 12:00am", "Medical"},
                    new object[] { "JP Morgan & Chase & Co", 45.73, 0.07, 0.15, "9/1 12:00am", "Finance"},
                    new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, "9/1 12:00am", "Food"},
                    new object[] { "Merck & Co., Inc.", 40.96, 0.41, 1.01, "9/1 12:00am", "Medical"},
                    new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, "9/1 12:00am", "Computer"},
                    new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, "9/1 12:00am", "Medical"},
                    new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, "9/1 12:00am", "Food"},
                    new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, "9/1 12:00am", "Retail"},
                    new object[] { "The Procter & Gamble Company", 61.91, 0.01, 0.02, "9/1 12:00am", "Manufacturing"},
                    new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, "9/1 12:00am", "Computer"},
                    new object[] { "Verizon Communications", 35.57, 0.39, 1.11, "9/1 12:00am", "Services"},
                    new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, "9/1 12:00am", "Retail"}
                };
    
            this.Store1.DataBind();
        }
    
        protected void SubmitGrids(object sender, DirectEventArgs e)
        {
            string grid1Json = e.ExtraParams["Testata"];
    
    // no data when selectedOnly : true is used
    
            XmlNode grid1Xml = JSON.DeserializeXmlNode("{records:{record:" + grid1Json + "}}");
    
            Dictionary<string, string>[] grid1Data = JSON.Deserialize<Dictionary<string, string>[]>(grid1Json);
    
            RowSelectionModel sm = GridPanel1.GetSelectionModel() as RowSelectionModel;
    
            int i = 0;
            foreach (Dictionary<string, string> row in grid1Data)
            {
                bool selected = false;
                foreach (SelectedRow srow in sm.SelectedRows)
                {
                    int s = srow.RowIndex;
                    if (s == i)
                    {
                        selected = true;
                        break;
                    }
                }
                if (selected)
                {
    
                }
                i++;
            }
        }
    }
    Attached Thumbnails Click image for larger version. 

Name:	CheckSelect.png 
Views:	90 
Size:	24.8 KB 
ID:	5447  
    Last edited by Daniil; Jan 23, 2013 at 6:56 AM. Reason: [CLOSED]
  2. #2
    Hello!

    You have to declare IDProperty:

    <Model>
    	<ext:Model ID="Model1" runat="server" IDProperty="company">
    		<Fields>
    			<ext:ModelField Name="company" />
    			<ext:ModelField Name="price" Type="Float" />
    			<ext:ModelField Name="change" Type="Float" />
    			<ext:ModelField Name="pctChange" Type="Float" />
    			<ext:ModelField Name="lastChange" Type="Date" DateFormat="M/d hh:mmtt" />
    			<ext:ModelField Name="industry" />
    		</Fields>
    	</ext:Model>
    </Model>
    Also, change calling of getRowsValues methods:

    <ext:Parameter Name="Testata" Value="Ext.encode(#{GridPanel1}.getRowsValues({ selectedOnly: true }))" Mode="Raw" />
  3. #3
    many thanks!!

Similar Threads

  1. Replies: 2
    Last Post: Nov 29, 2012, 9:30 AM
  2. Replies: 1
    Last Post: Oct 16, 2012, 9:19 AM
  3. [CLOSED] How to get selectedrows of gridpanel
    By egvt in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: May 31, 2012, 7:10 PM
  4. Replies: 13
    Last Post: Mar 29, 2012, 2:39 PM
  5. Replies: 0
    Last Post: Dec 29, 2008, 8:19 AM

Tags for this Thread

Posting Permissions