Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
185
How to disable paging in order to export data from webdatagrid to excel??
posted

I  have paging enabled and I cannot export the entire data to excel

export button:

<img src="../images/i_exportXLS.png" />
<asp:Button ID="btnExport" runat="server" Text="Export to Excel" class="button" Width="140"
OnClick="btnExport_Click" />
<ig:WebExcelExporter ID="exporter" runat="server"
>
</ig:WebExcelExporter>

paging:

<ig:Paging PageSize="100" Enabled="true" PagingClientEvents-PageIndexChanging="batchUpdateAlert" PagerAppearance="Both" >
<PagingClientEvents PageIndexChanging ="batchUpdateAlert" />
</ig:Paging>

server side export function:

protected void btnExport_Click(object sender, EventArgs e)
{
try
{

if (wdgModifyPositions.Rows.Count >= 1)
{

this.exporter.Export(this.wdgModifyPositions);
lblError.Visible = false;
AlertPic.Visible = false;
}
else
{
lblError.Text = "Please Load Data into the Data Grid";
lblError.Visible = true;
AlertPic.Visible = true;
}
}
catch (Exception ex)
{
ErrorHandle.ExceptionHelper(ex);
}
}

I saw the examples on forum for ultragrid :

 UWGrid.DisplayLayout.Pager.AllowPaging = False

and this does not work on webdatagrid. What is possible way to disable paging on webdatagrid??

Thanks!!