This is a migrated thread and some comments may be shown as answers.

Date filtering problem

8 Answers 98 Views

Grid

This is a migrated thread and some comments may be shown as answers.

8 Answers, 1 is accepted

answered on 06 Aug 2009, 01:08 PM

Hello sir,

First of all i'm thanking you for the attention that you have
made to my problem.

It works fine in the demo but unfortunately it doesn't
work as expected in the demo in my code.

Here's the code
<telerik:RadGrid ID="gvDiseaseGrid" runat="server" AllowPaging="True"
                        AllowSorting="True" AutoGenerateColumns="False" GridLines="None"
                        ondeletecommand="gvDiseaseGrid_DeleteCommand"
                        onitemdatabound="gvDiseaseGrid_ItemDataBound"
                        onpageindexchanged="gvDiseaseGrid_PageIndexChanged"
                        onpagesizechanged="gvDiseaseGrid_PageSizeChanged"
                        onselectedindexchanged="gvDiseaseGrid_SelectedIndexChanged"
                        onsortcommand="gvDiseaseGrid_SortCommand" style="margin-bottom: 0px"
                        AllowFilteringByColumn="True" onitemcommand="gvDiseaseGrid_ItemCommand" Height="170px">
                        <MasterTableView DataKeyNames="DisPKey" PageSize="5">
                            <Columns>
                                <telerik:GridBoundColumn DataField="disease" HeaderText="Disease"
                                    UniqueName="disease" AllowFiltering="true">
                                </telerik:GridBoundColumn>
                                 <telerik:GridDateTimeColumn DataField="startdate" HeaderText="Start Date"
                                    UniqueName="startdate" DataFormatString="{0:dd-MMM-yyyy}" AllowFiltering="true">
                                </telerik:GridDateTimeColumn>

                                <telerik:GridDateTimeColumn DataField="enddate" HeaderText="End date"
                                    UniqueName="enddate" DataFormatString="{0:dd-MMM-yyyy}" AllowFiltering="true"
                                    PickerType="DatePicker" SortExpression="enddate" >
                                </telerik:GridDateTimeColumn>
                                <telerik:GridBoundColumn DataField="medNote" HeaderText="Medical Notes"
                                    UniqueName="medNote">
                                </telerik:GridBoundColumn>
                                <telerik:GridTemplateColumn UniqueName="Sel" AllowFiltering="false">
                                    <ItemTemplate>
                                        <mm:mmImageButton ID="imgbtnSel" runat="server" CommandName="select"
                                            ImageUrl="~/Images/deselect.GIF" Text="mmImageButton" ToolTip="Select" />
                                    </ItemTemplate>
                                    <ItemStyle Height="5px" Width="5px" />
                                </telerik:GridTemplateColumn>
                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandArgument="Delete"
                                    CommandName="Delete" HeaderTooltip="Delete" ImageUrl="~/Images/delete.gif"
                                    Text="Delete" UniqueName="imgbtnDel">
                                    <ItemStyle Height="5px" Width="5px" />
                                </telerik:GridButtonColumn>
                            </Columns>
                        </MasterTableView>
                        <ClientSettings Scrolling-AllowScroll="true"></ClientSettings>
                    </telerik:RadGrid>

I tried with the eg provided in the demo but no result.

Thanks in advance
Unni

answered on 06 Aug 2009, 04:34 PM

grid-filtering-problem.zip

Hi,

I followed your scenario in order to replicate the issue, but to no avail.
Please find attached a simple working project that demonstrates the needed approach. Give it a try and let me know if it works for you.

Kind regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 07 Aug 2009, 06:39 AM

Hello Sir,

the attached working project did run with the required feature.
i had done the same thing with only one difference is that
I'm binding the datasource of the grid in the server side that
was the only difference i had seen and here's the function
for databinding

protected void radGrid_ItemCommand(object source, GridCommandEventArgs e)
    {

        if (e.CommandName == RadGrid.FilterCommandName)
        {
               DataTable dtGrid = this.oFdrDiseaseChart.FillDiseaseGrid();
               this.radGrid.DataSource = dtGrid;
               this.radGrid.DataBind();
         }
   }

Is there any problem with this type of binding .
but all other filtering except the date column works
fine.

give me the steps for solving the pblm.

Thanks in advance
Unni