What's New?

[CLOSED] Wrong Date Format on the store

  1. #1
    Mar 25, 2011, 5:34 PM

    [CLOSED] Wrong Date Format on the store 

    this.Store.DataSource = ((DataTable)tbl).DefaultView;
    where {ColumnDate} have type DateTime

    Test 1
                JsonReader StoreFields = new JsonReader();
                    if (recordType == RecordFieldType.Date)
                    {
                        StoreFields.Fields.Add(sg.cColumnName, recordType, "yyyy-MM-dd");
                    }
    {View Date in DataBase MSSQL} =>=>=> {View Date in GridPanel with DateColumn.Format = "yyyy-MM-dd";}
    "2011-03-31 00:00:00.000" =>=>=> "2011-03-31"
    "2011-04-12 00:00:00.000" =>=>=> "2011-04-12"
    "2011-06-23 09:24:00.000" =>=>=> "" // undefined

    Test 2
                JsonReader StoreFields = new JsonReader();
                    if (recordType == RecordFieldType.Date)
                    {
                        StoreFields.Fields.Add(sg.cColumnName, recordType, "yyyy-MM-dd HH:mm");
                    }
    {View Date in DataBase MSSQL} =>=>=> {View Date in GridPanel with DateColumn.Format = "yyyy-MM-dd";}
    "2011-03-31 00:00:00.000" =>=>=> "" // undefined
    "2011-04-12 00:00:00.000" =>=>=> "" // undefined
    "2011-06-23 09:24:00.000" =>=>=> "2011-06-23"

    Test 3
                JsonReader StoreFields = new JsonReader();
                    if (recordType == RecordFieldType.Date)
                    {
                        StoreFields.Fields.Add(sg.cColumnName, recordType, "yyyy-MM-dd HH:mm:ss");
                    }
    {View Date in DataBase MSSQL} =>=>=> {View Date in GridPanel with DateColumn.Format = "yyyy-MM-dd";}
    "2011-03-31 00:00:00.000" =>=>=> "" // undefined
    "2011-04-12 00:00:00.000" =>=>=> "" // undefined
    "2011-06-23 09:24:00.000" =>=>=> "" // undefined

    Test 4
                JsonReader StoreFields = new JsonReader();
                    if (recordType == RecordFieldType.Date)
                    {
                        StoreFields.Fields.Add(sg.cColumnName, recordType);
                    }
    {View Date in DataBase MSSQL} =>=>=> {View Date in GridPanel with DateColumn.Format = "yyyy-MM-dd";}
    "2011-03-31 00:00:00.000" =>=>=> "" // undefined
    "2011-04-12 00:00:00.000" =>=>=> "" // undefined
    "2011-06-23 09:24:00.000" =>=>=> "" // undefined


    What is this????
    Last edited by Daniil; Mar 25, 2011 at 10:01 PM. Reason: [CLOSED]
  2. #2
    Mar 25, 2011, 6:51 PM
    Hi,

    Please don't use .DateFormat if there is .DateTime format of value.

    .DateFormat makes sense if there is a string.

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

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

<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest)
        {
            Store store = this.GridPanel1.GetStore();
            store.DataSource = new object[] 
            { 
                new object[] 
                { 
                    DateTime.Now,
                    "2011-03-25"
                },
                new object[] 
                { 
                    DateTime.Now.AddDays(1),
                    "2011-03-26"
                }
            };
            store.DataBind();
        }
    }
</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>Ext.Net Example</title>
</head>
<body>
    <form runat="server">
    <ext:ResourceManager runat="server" />
    <ext:GridPanel ID="GridPanel1" runat="server" AutoHeight="true">
        <Store>
            <ext:Store runat="server">
                <Reader>
                    <ext:ArrayReader>
                        <Fields>
                            <ext:RecordField Name="test1" Type="Date" />
                            <ext:RecordField Name="test2" Type="Date" DateFormat="yyyy-MM-dd" />
                        </Fields>
                    </ext:ArrayReader>
                </Reader>
            </ext:Store>
        </Store>
        <ColumnModel runat="server">
            <Columns>
                <ext:DateColumn Header="DateTime" DataIndex="test1" />
                <ext:DateColumn Header="String" DataIndex="test2" />
            </Columns>
        </ColumnModel>
    </ext:GridPanel>
    </form>
</body>
</html>
  3. #3
    Mar 25, 2011, 9:56 PM

    Thanks

    Thanks! In version Pro all works..

    <%@ Page Language="C#" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>

<script runat="server">
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!X.IsAjaxRequest && !IsCallback)
        {
            DataTable dt = new DataTable();
            dt.BeginInit();
            {
                dt.TableName = "MyTable";
                dt.Columns.AddRange(new DataColumn[]
                {
                    new DataColumn("id", typeof(int)),
                    new DataColumn("date1", typeof(DateTime)),
                    new DataColumn("date2", typeof(DateTime)),
                    new DataColumn("date3", typeof(DateTime)),
                    new DataColumn("date4", typeof(DateTime))
                });
            }
            dt.EndInit();
            
            dt.BeginLoadData();
            {
                int i = 1;
                DateTime date = DateTime.Now;
                dt.Rows.Add(i++, date, date, date, date);

                date = date.Date;
                dt.Rows.Add(i++, date, date, date, date);

                date = date.AddHours(13);
                dt.Rows.Add(i++, date, date, date, date);

                date = date.AddMinutes(15);
                dt.Rows.Add(i++, date, date, date, date);

                date = date.AddSeconds(30);
                dt.Rows.Add(i++, date, date, date, date);

                date = date.AddTicks(150);
                dt.Rows.Add(i++, date, date, date, date);
            }
            dt.EndLoadData();

            this.Store1.Reader.Clear();
            this.Store1.Reader.Add(new JsonReader() { IDProperty = "id" });
            this.Store1.Reader.Reader.Fields.AddRange(new RecordFieldCollection()
            {
                new RecordField("id", RecordFieldType.Int),
                new RecordField("date1", RecordFieldType.Date),
                new RecordField("date2", RecordFieldType.Date),
                new RecordField("date3", RecordFieldType.Date),
                new RecordField("date4", RecordFieldType.Date)
            });

            this.GridPanel1.ColumnModel.Columns.Clear();
            this.GridPanel1.ColumnModel.Columns.AddRange(new ColumnCollection()
            {
                new NumberColumn() { DataIndex = "id", Format = "0", Header = "ID", Width = new Unit("50px") },
                new DateColumn() { DataIndex = "date1", Format = "yyyy-MM-dd", Header = "Date 1", Width = new Unit("150px") },
                new DateColumn() { DataIndex = "date2", Format = "yyyy-MM", Header = "Date 2", Width = new Unit("150px") },
                new DateColumn() { DataIndex = "date3", Format = "yyyy-MM-dd HH:mm", Header = "Date 3", Width = new Unit("150px") },
                new DateColumn() { DataIndex = "date4", Format = "yyyy-MM-dd HH:mm:ss", Header = "Date 4", Width = new Unit("150px") }
            });

            this.Store1.DataSource = dt.DefaultView;
            this.GridPanel1.DataBind();
        }
    }
</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></title>
</head>
<body>
    <form id="form1" runat="server">
        <ext:ResourceManager ID="ResourceManager1" runat="server" />
        <ext:GridPanel ID="GridPanel1" runat="server" AutoHeight="true">
            <Store>
                <ext:Store ID="Store1" runat="server" />
            </Store>
            <ColumnModel runat="server" />
        </ext:GridPanel>
    </form>
</body>
</html>
    Result:

    Ext.data.PagingMemoryProxy([
	{"id":1,"date1":"2011-03-25T23:19:23","date2":"2011-03-25T23:19:23","date3":"2011-03-25T23:19:23","date4":"2011-03-25T23:19:23"},
	{"id":2,"date1":"2011-03-25T00:00:00","date2":"2011-03-25T00:00:00","date3":"2011-03-25T00:00:00","date4":"2011-03-25T00:00:00"},
	{"id":3,"date1":"2011-03-25T13:00:00","date2":"2011-03-25T13:00:00","date3":"2011-03-25T13:00:00","date4":"2011-03-25T13:00:00"},
	{"id":4,"date1":"2011-03-25T13:15:00","date2":"2011-03-25T13:15:00","date3":"2011-03-25T13:15:00","date4":"2011-03-25T13:15:00"},
	{"id":5,"date1":"2011-03-25T13:15:30","date2":"2011-03-25T13:15:30","date3":"2011-03-25T13:15:30","date4":"2011-03-25T13:15:30"},
	{"id":6,"date1":"2011-03-25T13:15:30","date2":"2011-03-25T13:15:30","date3":"2011-03-25T13:15:30","date4":"2011-03-25T13:15:30"}
	], false)})

Similar Threads

  1. [CLOSED] Date format property set twice when creating Date Picker Menu
    By anup in forum 2.x Legacy Premium Help
    Replies: 3
    Last Post: May 09, 2012, 4:28 PM
  2. how to set date format(d/mY) in dynamic created control in gridpanel after selecting or changing the date
    By praveencat123 in forum 1.x Help
    Replies: 1
    Last Post: Apr 13, 2012, 1:52 PM
  3. [CLOSED] Quick Question: Is it Possible to change the Date Format of the Date Fields in the Edit Event Window?
    By rbarr in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Jun 30, 2011, 3:30 PM
  4. [CLOSED] How to Set Date Format in a Coolite Date Field
    By speedstepmem3 in forum 1.x Legacy Premium Help
    Replies: 2
    Last Post: Dec 02, 2010, 8:47 AM
  5. Date format problem with ext:GridPanel and ext:Store
    By hansweber2 in forum 1.x Help
    Replies: 0
    Last Post: Jul 07, 2009, 4:34 AM

Tags for this Thread

Posting Permissions