Feb 14, 2014, 12:34 PM
[CLOSED] mssql datetime can not convert to proper date format?
mssql column's type is datetime , its's data is {2014/2/14 19:46:51} can not conver to yyyy-MM-dd
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest)
{
var cases = caseDao.AllCases();
store1.DataSource = cases;
store1.DataBind();
}
}
<ext:GridPanel runat="server">
<Store>
<ext:Store runat="server" ID="store1">
<Model>
<ext:Model runat="server">
<Fields>
<ext:ModelField Name="id"></ext:ModelField>
<ext:ModelField Name="casename"></ext:ModelField>
<ext:ModelField Name="pic"></ext:ModelField>
<ext:ModelField Name="info"></ext:ModelField>
<ext:ModelField Name="url"></ext:ModelField>
<ext:ModelField Name="addtime" Type="Date"></ext:ModelField>
</Fields>
</ext:Model>
</Model>
</ext:Store>
</Store>
<ColumnModel>
<Columns>
<ext:Column runat="server" DataIndex="id" Text="编号"></ext:Column>
<ext:Column runat="server" DataIndex="casename" Text="案例" Flex="1"></ext:Column>
<ext:Column runat="server" DataIndex="pic" Text="缩略图" ></ext:Column>
<ext:Column runat="server" DataIndex="url" Text="网址"></ext:Column>
<ext:Column runat="server" DataIndex="addtime" Text="时间" Format="yyyy-MM-dd"></ext:Column>
</Columns>
</ColumnModel>
</ext:GridPanel>
Last edited by Daniil; Feb 17, 2014 at 3:38 AM.
Reason: [CLOSED]