I have NA 2008 release 1 and am developing an ASP.NET application. Several of the WebGrid controls I have implemented have datetime values in the dataset/table that I bind to the grid. I am able to toggle the sort order by clicking on the header but the sort is based upon the month first rather than the year. So, all of the December rows are together, November, etc regardless of year.
Has anyone dealt with this problem?
what is the solution. I have the same issue too....
Hello,
is client side sorting for date field possible in Webgrid. We are facing the same issue as posted in this forum, that is the column sorts by string rather than date.
ver: Infragistics35.WebUI.UltraWebGrid.v8.1.dll
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
Column in ASPX is:
<igtbl:UltraGridColumn BaseColumnName="DueDate" IsBound="True" Key="DueDate" DataType="System.DateTime">
<Header Caption="DueDate">
<RowLayoutColumnInfo OriginX="4" />
</Header>
<HeaderStyle Width="60px" />
<CellStyle Width="60px" />
<Footer>
</Footer>
</igtbl:UltraGridColumn>
Is there a way I can guarantee that its doesn’t get converted someplace?
Is there are way that implicitly gets the data converted from DateTime to String? For example, can you please double check that the colunm that is defined in the ASPX for the grid is also of type System.DataTime? Is there a way the data gets converted to string (e.g. if it comes from XML datasource, etc).
Hi,
Mine is a datatype of System.DateTime and I'm getting the same error.
I'm binding directlty to the Grid:
this.UltraWebGrid122.DataSource = GetData();this.UltraWebGrid122.DataBind();