why radgrid disappeared when using custom datasource from code behind?

[khaled jendi]

hi,

I was following this example here: http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/exporting/defaultvb.aspx
the only difference is that I am binding data source from code behind in page_load method, means instead of:
 <telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" .......
I am using binding in page_load like this:
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not IsPostBack Then
        dsClients = clsDB.getData(strSQL)
        RadGrid1.DataSource = dsClients
        RadGrid1.DataBind()
        End If
    End Sub





please note that I am using master page and aspx page, in master page I put rad script manager like this:
<telerik:RadScriptManager ID="RadScriptManager1" runat="server" AsyncPostBackTimeout="10000" />

and in aspx page I put the ajax panel and rad grid like this:

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
        <ClientEvents OnRequestStart="onRequestStart" />
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadGrid1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>

                                    <telerik:RadGrid ID="RadGrid1" AllowSorting="True"
        AllowPaging="True" PageSize="5" runat="server" GridLines="None" Width="95%"
        OnItemCommand="RadGrid1_ItemCommand">
        <ExportSettings HideStructureColumns="true" />
                <MasterTableView Width="100%" CommandItemDisplay="Top">
            <PagerStyle Mode="NextPrevNumericAndAdvanced" />
            <CommandItemSettings ShowExportToWordButton="true" ShowExportToExcelButton="true"
                ShowExportToCsvButton="true" />
        </MasterTableView>
        </telerik:RadGrid>


so when I click any button in the grid its disappeared!

any help?

[Iana Tsolova]

Hi Khaled,

Frm the provided code I can see that you are using simple data-binding for the grid. However exporting is not supported with it. I suggest that you bind the grid through its NeedDataSource event instead. Find more information below:
http://www.telerik.com/help/aspnet-ajax/grid-simple-data-binding.html
http://www.telerik.com/help/aspnet-ajax/grid-advanced-data-binding.html

Additionally, note that you should disable ajax upon export, as for the export to work properly, a regular postback is required.

Regards,
Iana
the Telerik team

[khaled jendi]

thank you this works,
but when I save the file, I got its name something looks like: RadGridExport.csv

how to change file the file name?

[Iana Tsolova]

Hi Khaled,

Try setting the predefined name in the grid ExportSettings as below:

<telerik:RadGrid ID="RadGrid1" runat="server">
    <ExportSettings FileName="Myreport" />

All the best,
Iana
the Telerik team

[khaled jendi]

thank you very much

this works with me for csv, word, and excel, but not pdf, the file name still same on pdf

[Shinu]

Hello Khaled,

Try setting OpenInNewWindow to true to get the same Filename in pdf.

<ExportSettings FileName="Myreport" OpenInNewWindow="true">
</ExportSettings>

Thanks,
Shinu.

[khaled jendi]

hi,

OpenInNewWindow="true" is not working for me !

still I got file name RadGridExport.pdf

[Jayesh Goyani]

Hello,

protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)

        {

            if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToExcelCommandName ||

                e.CommandName == Telerik.Web.UI.RadGrid.ExportToWordCommandName ||

                e.CommandName == Telerik.Web.UI.RadGrid.ExportToCsvCommandName ||
e.CommandName == Telerik.Web.UI.RadGrid.ExportToPdfCommandName)

            {

                ConfigureExport();

            }

        }

       

        public void ConfigureExport()

        {

            RadGrid1.ExportSettings.FileName = "YourFileName";

  

            RadGrid1.ExportSettings.OpenInNewWindow = true;

        }

try with above code snippet and let me know its working or not.

If it is not working then please provide some part of your code.

Thanks,
Jayesh Goyani