Hi,
I am using radgrid with grouping options,the problem it loads fine ,however after that it never binds even on paging,sorting or on other controls.when i remove grouping it works fine. can you please reply soon.its very urgent.
below is my code
<telerik:RadGrid ID="RgrdConsultantVacationweek" AutoGenerateColumns="false" AllowPaging="true"
PageSize="8" runat="server" DataMember="ConsultantID" OnNeedDataSource="RgrdConsultantVacationweek_NeedDataSource"
AllowSorting="true" OnItemCommand="RgrdConsultantVacationweek_ItemCommand" ShowGroupPanel="true"
ShowFooter="True">
<ExportSettings HideStructureColumns="true" />
<ClientSettings>
<Selecting AllowRowSelect="true" />
<ClientEvents OnRowDblClick="OnRowDblClick" />
</ClientSettings>
<MasterTableView CommandItemDisplay="Top" ClientDataKeyNames="VacationRequestID"
ShowGroupFooter="true" EnableViewState ="true">
<CommandItemTemplate>
<table width="100%">
<tr>
<td style="text-align: right">
<asp:LinkButton ID="LnkExportToexcel" runat="server" CommandName="ExportToExcel">
<asp:Image ID="imgexportToexcel" ImageUrl="~/Img/Export to excel.gif" runat="server" />
</asp:LinkButton>
<asp:LinkButton ID="LnkExportTopdf" runat="server" CommandName="ExportTopdf">
<asp:Image ID="ImgPdf" ImageUrl="~/Img/ExportToPDF.gif" runat="server" />
</asp:LinkButton>
<asp:LinkButton ID="LnkExporrtToCsv" runat="server" CommandName="ExporrtToCsv">
<asp:Image ID="Imgcsv" ImageUrl="~/Img/ExportToCSV.gif" runat="server" />
</asp:LinkButton>
<asp:LinkButton ID="LnkExportToWord" runat="server" CommandName="ExportToWord">
<asp:Image ID="ImgWord" ImageUrl="~/Img/ExportToWord.gif" runat="server" />
</asp:LinkButton>
</td>
</tr>
</table>
</CommandItemTemplate>
<GroupHeaderTemplate>
<asp:Label runat="server" ID="Label1" Text='<%#Eval("vacationmonth") %>' Visible="true">
</asp:Label>
</GroupHeaderTemplate>
<GroupFooterTemplate>
<asp:Label ID="lblBusinessdaystext" Text="Total " runat="server"></asp:Label>
<asp:Label ID="lblBusinessdays" runat="server" Text='<%# Eval("Businessdays") %>'>
</asp:Label>
</GroupFooterTemplate>
<Columns>
<telerik:GridBoundColumn DataField="VacationRequestID" HeaderText="VacationRequestID"
Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ConsultantID" HeaderText="ConsultantID" Visible="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ConsultantName" HeaderText="Resource" SortExpression="ConsultantName">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn ItemStyle-Width="15%" HeaderText="Dates">
<ItemTemplate>
<asp:Label ID="lblDates" runat="server" Text='<%#String.Format("{0}-{1}", Eval("startdate").ToString(),Eval("enddate").ToString()) %>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn Aggregate="Sum" DataField="Businessdays" HeaderText="Business Days"
Visible="true" FooterText="Total ">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Approved" HeaderText="Approved" Visible="true">
</telerik:GridBoundColumn>
</Columns>
<GroupByExpressions>
<telerik:GridGroupByExpression>
<GroupByFields>
<telerik:GridGroupByField FieldName="vacationmonth" />
</GroupByFields>
</telerik:GridGroupByExpression>
</GroupByExpressions>
</MasterTableView>
</telerik:RadGrid>
protected void RgrdConsultantVacationweek_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
try
{
BindRgrdConsultantVacationweek();
}
catch (Exception ex)
{
}
}
protected void BindRgrdConsultantVacationweek()
{
try
{
//DateTime lastDate = GetLastDateOfWeek((DateTime.Now).Date, DayOfWeek.Saturday);
DataTable dt = GetConsultantRequest(Convert.ToInt32(Session["CRUserID"]), true, Convert.ToInt32(Session["UserType"]), Convert.ToInt32(ddlTypeOfLeave.SelectedValue), rdpProjectStartDate.SelectedDate, rdpProjectEndDate.SelectedDate, Convert.ToInt32(ddlPractices.SelectedValue));
RgrdConsultantVacationweek.DataSource = dt;
}
catch (Exception ex)
{
}
}
thanks in advance.