Panelgrid work Typed DataSets?

[carlosmupe]

Hi dear...

i'm Carlos....

i'm work with coolite library, but i have problems with panelgrid, i'm working with Typed Datasets and i dont know how i can work with them.

so somebody can i help me?

thanks everybody!!!

[geoffrey.mcgill]

Hi Carlos,

The following sample is based on the v1.0 code base, although down-converting to v0.8.x should not be a problem.

Example

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Xml.Xsl" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Linq" %>

<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<script runat="server">
    private DataTable GetDataTable()
    {
        DataTable table = new DataTable();

        table.Columns.AddRange(new DataColumn[] {
            new DataColumn("Company")   { ColumnName = "Company",    DataType = typeof(string) },
            new DataColumn("Price")     { ColumnName = "Price",      DataType = typeof(double) },
            new DataColumn("Change")    { ColumnName = "Change",     DataType = typeof(double) },
            new DataColumn("PctChange") { ColumnName = "PctChange",  DataType = typeof(double) },
            new DataColumn("PctChange") { ColumnName = "LastChange", DataType = typeof(DateTime) }
        });

        foreach (object[] obj in this.Data)
        {
            table.Rows.Add(obj);
        }

        return table;
    }
    
    private object[] Data
    {
        get
        {
            DateTime now = DateTime.Now;
            
            return new object[]
            {
                new object[] { "3m Co", 71.72, 0.02, 0.03, now },
                new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, now },
                new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, now },
                new object[] { "American Express Company", 52.55, 0.01, 0.02, now },
                new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, now },
                new object[] { "AT&amp;T Inc.", 31.61, -0.48, -1.54, now },
                new object[] { "Boeing Co.", 75.43, 0.53, 0.71, now },
                new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, now },
                new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, now },
                new object[] { "E.I. du Pont de Nemours and Company", 40.48, 0.51, 1.28, now },
                new object[] { "Exxon Mobil Corp", 68.1, -0.43, -0.64, now },
                new object[] { "General Electric Company", 34.14, -0.08, -0.23, now },
                new object[] { "General Motors Corporation", 30.27, 1.09, 3.74, now },
                new object[] { "Hewlett-Packard Co.", 36.53, -0.03, -0.08, now },
                new object[] { "Honeywell Intl Inc", 38.77, 0.05, 0.13, now },
                new object[] { "Intel Corporation", 19.88, 0.31, 1.58, now },
                new object[] { "International Business Machines", 81.41, 0.44, 0.54, now },
                new object[] { "Johnson &amp; Johnson", 64.72, 0.06, 0.09, now },
                new object[] { "JP Morgan &amp; Chase &amp; Co", 45.73, 0.07, 0.15, now },
                new object[] { "McDonald\"s Corporation", 36.76, 0.86, 2.40, now },
                new object[] { "Merck &amp; Co., Inc.", 40.96, 0.41, 1.01, now },
                new object[] { "Microsoft Corporation", 25.84, 0.14, 0.54, now },
                new object[] { "Pfizer Inc", 27.96, 0.4, 1.45, now },
                new object[] { "The Coca-Cola Company", 45.07, 0.26, 0.58, now },
                new object[] { "The Home Depot, Inc.", 34.64, 0.35, 1.02, now },
                new object[] { "The Procter &amp; Gamble Company", 61.91, 0.01, 0.02, now },
                new object[] { "United Technologies Corporation", 63.26, 0.55, 0.88, now },
                new object[] { "Verizon Communications", 35.57, 0.39, 1.11, now },
                new object[] { "Wal-Mart Stores, Inc.", 45.45, 0.73, 1.63, now }
            };
        }
    }
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            this.Store1.DataSource = this.GetDataTable();
            this.Store1.DataBind(); 
        }
    }

    protected void Store1_RefreshData(object sender, StoreRefreshDataEventArgs e)
    {
        this.Store1.DataSource = this.GetDataTable();
        this.Store1.DataBind(); 
    }

    protected void Store1_Submit(object sender, StoreSubmitDataEventArgs e)
    {
        string format = this.FormatType.Value.ToString();

        XmlNode xml = e.Xml;

        this.Response.Clear();

        switch (format)
        {
            case "xml":
                string strXml = xml.OuterXml;
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xml");
                this.Response.AddHeader("Content-Length", strXml.Length.ToString());
                this.Response.ContentType = "application/xml";
                this.Response.Write(strXml);

                break;
            case "xls":
                this.Response.ContentType = "application/vnd.ms-excel";
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xls");
                XslCompiledTransform xtExcel = new XslCompiledTransform();
                xtExcel.Load(Server.MapPath("Excel.xsl"));
                xtExcel.Transform(xml, null, Response.OutputStream);

                break;
            case "csv":
                this.Response.ContentType = "application/octet-stream";
                this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.csv");
                XslCompiledTransform xtCsv = new XslCompiledTransform();
                xtCsv.Load(Server.MapPath("Csv.xsl"));
                xtCsv.Transform(xml, null, Response.OutputStream);

                break;
        }

        this.Response.End();
    }
</script>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>GridPanel using DataTable with Paging and Remote Reloading - Ext.NET Examples</title>
    <link href="../../../../resources/css/examples.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript">
        var template = '{1}';

        var change = function (value) {
            return String.format(template, (value > 0) ? "green" : "red", value);
        };

        var pctChange = function (value) {
            return String.format(template, (value > 0) ? "green" : "red", value + "%");
        };

        var exportData = function (format) {
            FormatType.setValue(format);
            var store = GridPanel1.store;
            store.directEventConfig.isUpload = true;

            var records = store.reader.readRecords(store.proxy.data).records,
                values = [];
            
            for (i = 0; i < records.length; i++) {
                var obj = {}, dataR;
                
                if (store.reader.meta.id) {
                    obj[store.reader.meta.id] = records[i].id;
                }

                dataR = Ext.apply(obj, records[i].data);                
                
                if (!Ext.isEmptyObj(dataR)) {
                    values.push(dataR);
                }
            }
            
            store.submitData(values);

            store.directEventConfig.isUpload = false;
        };
    </script>
</head>
<body>
    <form runat="server">
        <ext:ResourceManager runat="server" />
        
        <h1>GridPanel using DataTable with Paging and Remote Reloading</h1>
        
        <p>Demonstrates how to create a grid from Array data with Local Paging and Remote Reloading.</p>
        
        <ext:Store 
            ID="Store1" 
            runat="server" 
            OnRefreshData="Store1_RefreshData"
            OnSubmitData="Store1_Submit">
            <Reader>
                <ext:JsonReader>
                    <Fields>
                        <ext:RecordField Name="Company" />
                        <ext:RecordField Name="Price" Type="Float" />
                        <ext:RecordField Name="Change" Type="Float" />
                        <ext:RecordField Name="PctChange" Type="Float" />
                        <ext:RecordField Name="LastChange" Type="Date" DateFormat="yyyy-MM-ddTHH:mm:ss" />
                    </Fields>
                </ext:JsonReader>
            </Reader>
        </ext:Store>
        
        <ext:Hidden ID="FormatType" runat="server" />

        <ext:GridPanel 
            id="GridPanel1"
            runat="server" 
            StoreID="Store1" 
            Title="DataTable Grid" 
            Width="600" 
            Height="320"
            AutoExpandColumn="Company">
            <ColumnModel runat="server">
                <Columns>
                    <ext:Column ColumnID="Company" Header="Company" Width="160" DataIndex="Company">
                        <Editor>
                            <ext:TextField runat="server" />
                        </Editor>
                    </ext:Column>
                    <ext:Column Header="Price" Width="75" DataIndex="Price">
                        <Renderer Format="UsMoney" />
                        <Editor>
                            <ext:TextField ID="TextField1" runat="server" />
                        </Editor>
                    </ext:Column>
                    <ext:Column Header="Change" Width="75" DataIndex="Change">
                        <Renderer Fn="change" />
                    </ext:Column>
                    <ext:Column Header="Change" Width="75" DataIndex="PctChange">
                        <Renderer Fn="pctChange" />
                    </ext:Column>
                    <ext:DateColumn Header="Last Updated" Width="85" DataIndex="LastChange" />
                </Columns>
            </ColumnModel>
            <SelectionModel>
                <ext:RowSelectionModel runat="server" />
            </SelectionModel>
            <LoadMask ShowMask="true" />
            <TopBar>
                <ext:Toolbar runat="server">
                    <Items>
                        <ext:ToolbarFill runat="server" />
                        <ext:Button ID="Button1" runat="server" Text="To XML" Icon="PageCode">
                            <Listeners>
                                <Click Handler="exportData('xml');" />
                            </Listeners>
                        </ext:Button>
                        
                        <ext:Button ID="Button2" runat="server" Text="To Excel" Icon="PageExcel">
                            <Listeners>
                                <Click Handler="exportData('xls');" />
                            </Listeners>
                        </ext:Button>
                        
                        <ext:Button ID="Button3" runat="server" Text="To CSV" Icon="PageAttach">
                            <Listeners>
                                <Click Handler="exportData('csv');" />
                            </Listeners>
                        </ext:Button>
                    </Items>
                </ext:Toolbar>
            </TopBar>
            <BottomBar>
                <ext:PagingToolbar runat="server" PageSize="10" StoreID="Store1" />
            </BottomBar>
        </ext:GridPanel>
    </form>
</body>
</html>

Hope this helps.

[carlosmupe]

thanks dear...

but only i need transform the typed dataset for a array or json object

how do i fill "object[]" with me typed dataset??

private object[] Data ->
{
get
{
DateTime now = DateTime.Now;

return new object[]
{
new object[] { "3m Co", 71.72, 0.02, 0.03, now },
new object[] { "Alcoa Inc", 29.01, 0.42, 1.47, now },
new object[] { "Altria Group Inc", 83.81, 0.28, 0.34, now },
new object[] { "American Express Company", 52.55, 0.01, 0.02, now },
new object[] { "American International Group, Inc.", 64.13, 0.31, 0.49, now },
new object[] { "AT&T Inc.", 31.61, -0.48, -1.54, now },
new object[] { "Boeing Co.", 75.43, 0.53, 0.71, now },
new object[] { "Caterpillar Inc.", 67.27, 0.92, 1.39, now },
new object[] { "Citigroup, Inc.", 49.37, 0.02, 0.04, now }
};
}
}


i was tried this form, for example this is code, but this don't work, in this line "item.Fields.Add("Id_Aplicacion", "Descripcion_Aplicacion");" show me errors





protected void Page_Load(object sender, EventArgs e)


{


strAplicaciones.DataSource = BLLSectores_Productivos.AplicacionBLL.Listado();
JsonReader item = new JsonReader();
item.Fields.Add("Id_Aplicacion", "Descripcion_Aplicacion");
strAplicaciones.Reader.Add(item);
strAplicaciones.DataBind(); //LLenar Store
GridAplicacion.StoreID = strAplicaciones.ClientID;
GridAplicacion.DataBind();





}

thanks for all..

[geoffrey.mcgill]

Can you just set the Stores .DataSource property with your DataTable/Dataset?

[carlosmupe]

hi Dear,

here set store object with my dataset
strAplicaciones.DataSource = BLLSectores_Productivos.AplicacionBLL.Listado();

but how do i fill the grid??
can i fill the grid with me dataset?


JsonReader item = new JsonReader();

here don't work :(
item.Fields.Add("Id_Aplicacion", "Descripcion_Aplicacion");
--

strAplicaciones.Reader.Add(item);
strAplicaciones.DataBind(); //LLenar Store
GridAplicacion.StoreID = strAplicaciones.ClientID;
GridAplicacion.DataBind();


thanks for all

[Vladimir]

Hi,

I believe that you have to use DataTable from DataSet

Store1.DataSource = dataSet.Tables["TABLE1"];

[carlosmupe]

Dear,

this is the code layer BLL

**** BLLSectores_Productivos.AplicacionBLL ****



public static DataTable Listado()


{


using (AplicacionTableAdapter da = new AplicacionTableAdapter())


{


DataTable dt = new DataTable("tabla");


dt = da.TraerAplicacionesALL();





return dt;


}


}

thanks for all

[Vladimir]

Hi,

What columns contains that DataTable?

[carlosmupe]

Dear

this is DTO




namespace DTOSectores_Productivos


{


public class AplicacionDTO


{


private short _id_Aplicacion;


public short id_Aplicacion


{


get { return _id_Aplicacion; }


set { _id_Aplicacion = value; }


}


private string _Descripcion_Aplicacion;


public string Descripcion_Aplicacion


{


get { return _Descripcion_Aplicacion; }


set { _Descripcion_Aplicacion = value; }


}


private short _Orden_Aplicacion;


public short Orden_Aplicacion


{


get { return _Orden_Aplicacion; }


set { _Orden_Aplicacion = value; }


}


private string _Estado_Aplicacion;


public string Estado_Aplicacion


{


get { return _Estado_Aplicacion; }


set { _Estado_Aplicacion = value; }


}


}


}this is BLL layer





public static DataTable Listado()


{


using (AplicacionTableAdapter da = new AplicacionTableAdapter())


{


//Aplicacion dt = new Aplicacion("tabla");


DataTable dt = new DataTable("tabla");


dt = da.TraerAplicacionesALL();





//da.Fill(dt);


return dt;


}


}
this is aplication web




protected void Page_Load(object sender, EventArgs e)


{


strAplicaciones.DataSource = BLLSectores_Productivos.AplicacionBLL.Listado();


JsonReader item = new JsonReader();


item.Fields.Add("id_aplicacion", "descripcion_aplicacion");


strAplicaciones.Reader.Add(item);


strAplicaciones.DataBind(); //LLenar Store


GridAplicacion.StoreID = strAplicaciones.ClientID;


GridAplicacion.DataBind();








}


this design web html and coolite



<ext:ScriptManager ID="ScriptManager1" runat="server">


</ext:ScriptManager>


<ext:Store ID="strAplicaciones" runat="server">


</ext:Store>


<ext:GridPanel ID="GridAplicacion" runat="server" Height="600">


<ColumnModel>


<Columns>


<ext:Column ColumnID="id_aplicacion" Header="Id" DataIndex="id_aplicacion"></ext:Column>


<ext:Column ColumnID="descripcion_aplicacion" Header="Descripcion" DataIndex="descripcion_aplicacion"></ext:Column>


</Columns>


</ColumnModel>


</ext:GridPanel>




dear geoffrey.mcgill, in the last example the code GetDataTable()


private DataTable GetDataTable()
{
DataTable table = new DataTable();

table.Columns.AddRange(new DataColumn[] {
new DataColumn("Company") { ColumnName = "Company", DataType = typeof(string) },
new DataColumn("Price") { ColumnName = "Price", DataType = typeof(double) },
new DataColumn("Change") { ColumnName = "Change", DataType = typeof(double) },
new DataColumn("PctChange") { ColumnName = "PctChange", DataType = typeof(double) },
new DataColumn("PctChange") { ColumnName = "LastChange", DataType = typeof(DateTime) }
});

foreach (object[] obj in this.Data)
{
table.Rows.Add(obj);
}

return table;
}

where do you set datatable?? becouse only set type struct... where object[] is an array with data no dynamic


thaks for all

[Vladimir]

Hi,

You use different letter case


1. DataIndex in column doesn't match Name in Field
2. Field's names doesn't match properties names in your DTO class


Please use the same letter case anywhere