[CLOSED] GridPanel GroupHeaderTplString when datasource is datatable

  1. #1

    [CLOSED] GridPanel GroupHeaderTplString when datasource is datatable

    https://examples2.ext.net/#/GridPane...oupingSummary/

    v2 Example: GroupHeaderTplString="{name}" , the Store's datasource is 'List<Project>' .
    when my datasource is datatable, what is GroupHeaderTplString ?
    this is wrong : GroupHeaderTplString = "{ProductpName}";

    
                <Features>               
                    <ext:GroupingSummary ID="GroupingSummary1" runat="server" GroupHeaderTplString="{name}" HideGroupedHeader="true" 
                        EnableGroupingMenu="false">                   
                    </ext:GroupingSummary>
                </Features>     
    
    .cs:
                GridPanel1.GetStore().GroupField = "ProductpName";
                GridPanel1.GetStore().DataSource = dt;
                GridPanel1.GetStore().DataBind();
    Last edited by Daniil; Mar 15, 2013 at 1:17 PM. Reason: [CLOSED]
  2. #2
    Hi @CPA1158139,

    Is there no mistype in this?
    ProductpName
    Probably, "p" in the center is redundant.
  3. #3
    Quote Originally Posted by Daniil View Post
    Hi @CPA1158139,

    Is there no mistype in this?


    Probably, "p" in the center is redundant.
    'ProductpName' is a column name,no problem.
    The datatable dt include ProductpID,ProductpName,cost 3 columns
  4. #4
    OK.

    So, does not GroupHeaderTplString="{name}" work? If so, please provide a test case to reproduce.
  5. #5
    Quote Originally Posted by Daniil View Post
    OK.

    So, does not GroupHeaderTplString="{name}" work? If so, please provide a test case to reproduce.
    It works well.
    I mistakenly thought that the word '{name}' means that word --column's name.
    pls close post.
    thank you very much.

    <%@ Page Language="C#" %>
    
    <%@ Import Namespace="System.Collections.Generic" %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data" %>
    <%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
    
    
    <!DOCTYPE html>
    
    <script runat="server">
        protected void Page_Load(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("ProjectID", typeof(string));
            dt.Columns.Add("ProjectName", typeof(string));
            dt.Columns.Add("Cost", typeof(Decimal));
            dt.Columns.Add("ItemID", typeof(Int32));
            dt.Rows.Add(new object[] { "110", "Field Anchoring", 150.00, 1 });
            dt.Rows.Add(new object[] { "120", "Field Anchoring", 220.00, 2 });
            dt.Rows.Add(new object[] { "130", "Field Anchoring", 350.00, 3 });
    
            dt.Rows.Add(new object[] { "210", "level Grouping", 335.00, 4 });
            dt.Rows.Add(new object[] { "220", "level Grouping", 442.00, 5 });
            dt.Rows.Add(new object[] { "230", "level Grouping", 555.00, 6 });
    
            this.Store1.DataSource = dt;
            this.Store1.DataBind();
        }
    
        
    </script>
    
    <html>
    <head id="Head1" runat="server">
        <title>GroupingSummary Plugin - Ext.NET Examples</title>
    
        <link href="/resources/css/examples.css" rel="stylesheet" />
    
        <style>
            .x-grid-body .x-grid-cell-Cost {
                background-color: #f1f2f4;
            }
    
            .x-grid-row-summary .x-grid-cell-Cost .x-grid-cell-inner {
                background-color: #e1e2e4;
            }
    
            .task .x-grid-cell-inner {
                padding-left: 15px;
            }
    
            .x-grid-row-summary .x-grid-cell-inner {
                font-weight: bold;
                font-size: 11px;
                background-color: #f1f2f4;
            }
        </style>
    
        <script>
            var totalCost = function (records) {
                var i = 0,
                    length = records.length,
                    total = 0,
                    record;
    
                for (; i < length; ++i) {
                    record = records[i];
                    total += record.get('Cost');
                }
                return total;
            };
        </script>
    
    </head>
    <body>
        <form id="Form1" runat="server">
            <h1>Group Summary Plugin</h1>
            <p>Advanced grouping grid that allows cell editing and includes custom dynamic summary calculations.</p>
    
            <ext:ResourceManager ID="ResourceManager1" runat="server" />
    
            <ext:Store ID="Store1" runat="server" GroupField="ProjectName">
                <Sorters>
                    <ext:DataSorter Property="ProjectID" Direction="ASC" />
                </Sorters>
                <Model>
                    <ext:Model ID="Model1" runat="server" IDProperty="ItemID">
                        <Fields>
                            <ext:ModelField Name="ProjectID" />
                            <ext:ModelField Name="ProjectName" />
                            <ext:ModelField Name="Cost" Type="Float" />
                            <ext:ModelField Name="ItemID" Type="Int" />
                        </Fields>
                    </ext:Model>
                </Model>
            </ext:Store>
    
            <ext:GridPanel
                ID="GridPanel1"
                runat="server"
                Frame="true"
                StoreID="Store1"
                Title="Sponsored Projects"
                Collapsible="true"
                AnimCollapse="false"
                Icon="ApplicationViewColumns"
                Width="800"
                Height="450">
                <Plugins>
                    <ext:CellEditing ID="CellEditing1" runat="server" ClicksToEdit="1" />
                </Plugins>
                <ColumnModel ID="ColumnModel1" runat="server">
                    <Columns>
                        <ext:SummaryColumn ID="SummaryColumn1"
                            runat="server"
                            TdCls="task"
                            Text="ProjectID"
                            Sortable="true"
                            DataIndex="ProjectID"
                            Hideable="false"
                            SummaryType="Count"
                            Flex="1">
                            <SummaryRenderer Handler="return ((value === 0 || value > 1) ? '(' + value +' Tasks)' : '(1 Task)');" />
                        </ext:SummaryColumn>
                        <ext:Column runat="server"  DataIndex="ProjectName" Text="ProjectName" ></ext:Column>
                        <ext:SummaryColumn
                            runat="server"
                            Width="75"
                            ID="Cost"
                            Text="Cost"
                            Sortable="false"
                            Groupable="false"
                            DataIndex="Cost"
                            CustomSummaryType="totalCost">
                            <Renderer Handler="return Ext.util.Format.usMoney(record.data.Cost);" />
                            <SummaryRenderer Fn="Ext.util.Format.usMoney" />
                        </ext:SummaryColumn>
                    </Columns>
                </ColumnModel>
                <View>
                    <ext:GridView ID="GridView1" runat="server" StripeRows="true" MarkDirty="false" />
                </View>
                <Features>
                    <ext:GroupingSummary
                        ID="GroupingSummary1"
                        runat="server"
                        GroupHeaderTplString="{name}"
                        HideGroupedHeader="true"
                        EnableGroupingMenu="false" />
                </Features>
    
               
            </ext:GridPanel>
        </form>
    </body>
    </html>
  6. #6
    Good.

    There are another options available.
    http://docs.sencha.com/ext-js/4-2/#!...groupHeaderTpl

Similar Threads

  1. Replies: 4
    Last Post: Jul 30, 2012, 7:24 PM
  2. How to use GridPanel with DataTable
    By kkp0633 in forum 1.x Help
    Replies: 4
    Last Post: Feb 15, 2012, 9:30 AM
  3. Replies: 5
    Last Post: Feb 01, 2012, 11:54 AM
  4. Save Gridpanel to DataTable
    By mkshields9w57 in forum 1.x Help
    Replies: 0
    Last Post: Jun 28, 2011, 8:53 PM
  5. GridPanel with DataTable?
    By MrMp3 in forum 1.x Help
    Replies: 2
    Last Post: Oct 03, 2008, 4:59 PM

Posting Permissions