Hi,
I have separate date and time field in 2 fields at database table. I am bounding it under ItemTemplate of a GridTemplateColumn . It is showing fine but can not be filtered by any means.
<telerik:RadGrid ID="grdDiscussionList" Skin="WebBlue"
runat="server" GridLines="None"
AutoGenerateColumns="False"
AllowSorting="True"
AllowFilteringByColumn = "true"
AllowPaging="True" PageSize="10"
OnNeedDataSource="grdDiscussionList_NeedDataSource"
OnItemCommand="grdDiscussionList_ItemCommand"
OnItemDataBound="grdDiscussionList_ItemDataBound"
OnItemCreated="grdDiscussionList_ItemCreated">
<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
<MasterTableView DataKeyNames="Discussion_Id" CommandItemDisplay="Top" EditMode="PopUp">
<CommandItemSettings ShowAddNewRecordButton="false"/>
<EditFormSettings PopUpSettings-Modal="true" />
<Columns>
<telerik:GridBoundColumn DataField="Discussion_Id" DataType="System.Int32"
HeaderText="Discussion Id" ReadOnly="True" SortExpression="Discussion_Id"
UniqueName="Discussion_Id" Visible="false" >
</telerik:GridBoundColumn>
………………………….
<telerik:GridTemplateColumn UniqueName="Discussion_Date" HeaderText="Discussion date"
SortExpression="Discussion_Date" ItemStyle-Width="100">
<ItemTemplate>
<%# showDiscussionDate(Container.DataItem) %> <%# showDiscussionTime(Container.DataItem) %>
</ItemTemplate>
</telerik:GridTemplateColumn>
…………………………………………………..
</Columns>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true"></ClientSettings>
</telerik:RadGrid>
public string showDiscussionDate(object dataItem)
{
string retDate = string.Empty;
string inDate = string.Empty;
inDate = DataBinder.Eval(dataItem, "discussion_date").ToString();
retDate = clsUtility.returnDateFormat(inDate);
return retDate;
}
public string showDiscussionTime(object dataItem)
{
string retTime = string.Empty;
string inTime = string.Empty;
inTime = DataBinder.Eval(dataItem, "Discussion_Time").ToString();
//retTime = clsUtility.returnTimeFormat(inTime);
retTime = inTime;
return retTime;
}
Any idea , how to resolve this problem?
I have separate date and time field in 2 fields at database table. I am bounding it under ItemTemplate of a GridTemplateColumn . It is showing fine but can not be filtered by any means.
<telerik:RadGrid ID="grdDiscussionList" Skin="WebBlue"
runat="server" GridLines="None"
AutoGenerateColumns="False"
AllowSorting="True"
AllowFilteringByColumn = "true"
AllowPaging="True" PageSize="10"
OnNeedDataSource="grdDiscussionList_NeedDataSource"
OnItemCommand="grdDiscussionList_ItemCommand"
OnItemDataBound="grdDiscussionList_ItemDataBound"
OnItemCreated="grdDiscussionList_ItemCreated">
<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
<MasterTableView DataKeyNames="Discussion_Id" CommandItemDisplay="Top" EditMode="PopUp">
<CommandItemSettings ShowAddNewRecordButton="false"/>
<EditFormSettings PopUpSettings-Modal="true" />
<Columns>
<telerik:GridBoundColumn DataField="Discussion_Id" DataType="System.Int32"
HeaderText="Discussion Id" ReadOnly="True" SortExpression="Discussion_Id"
UniqueName="Discussion_Id" Visible="false" >
</telerik:GridBoundColumn>
………………………….
<telerik:GridTemplateColumn UniqueName="Discussion_Date" HeaderText="Discussion date"
SortExpression="Discussion_Date" ItemStyle-Width="100">
<ItemTemplate>
<%# showDiscussionDate(Container.DataItem) %> <%# showDiscussionTime(Container.DataItem) %>
</ItemTemplate>
</telerik:GridTemplateColumn>
…………………………………………………..
</Columns>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true"></ClientSettings>
</telerik:RadGrid>
public string showDiscussionDate(object dataItem)
{
string retDate = string.Empty;
string inDate = string.Empty;
inDate = DataBinder.Eval(dataItem, "discussion_date").ToString();
retDate = clsUtility.returnDateFormat(inDate);
return retDate;
}
public string showDiscussionTime(object dataItem)
{
string retTime = string.Empty;
string inTime = string.Empty;
inTime = DataBinder.Eval(dataItem, "Discussion_Time").ToString();
//retTime = clsUtility.returnTimeFormat(inTime);
retTime = inTime;
return retTime;
}
Any idea , how to resolve this problem?