[Solved] All controls getting disable

[Satheesh]

Hi,

 When i try to export data from RAD GRID to excel sheet, data is transfering to excel sheet but all controls in web page is disabled.

please give solution as soon as possible.

Thanks,
 Dileep

[Shinu]

Hi Satheesh,

Try the following code snippet in the Export button click event.

CS:

    RadGrid1.ExportSettings.OpenInNewWindow = true;
    RadGrid1.MasterTableView.ExportToExcel();

Thanks
Shinu.

[Satheesh]

Hi Shinu,

I tried your suggestion but the controls in web page is still disabled. Even in excelsheet data is transfering but images is not copied.

Thanks,
 Dileep

[Princy]

Hi Satheesh,

Try setting ExportOnlyData to false while exporting.

CS:

  protected void Button1_Click(object sender, EventArgs e)
    {
        RadGrid1.ExportSettings.ExportOnlyData = false;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

You can also refer the following help article.
Exporting tips and tricks

Princy.

[Satheesh]

Hi Princy,

I used these two lines in my code(click event).

RadGrid1.ExportSettings.ExportOnlyData = false;

RadGrid1.ExportSettings.OpenInNewWindow = true;

But problem remains same. All page controls are disabled.

Thanks,
 Dileep

[Shinu]

Hi,

Which version of the Grid are you using? Try Upgrading to the latest version of the Grid.
Updating RadControls for ASP.NET to another version or license


Shinu.

[Satheesh]

Hi,

 We are using 5.1.3.0 version RAD GRID control.

 Thanks,
  Dileep

[Shinu]

Hi Dileep,

I am using RadGrid(5.1.1) and it is working as expected. Can you check whether you have written any code behind function that perform this behavior. Sending your codebehind will be  more good.

Shinu.

[Satheesh]

Hi shinu,

This is my work..

protected

void Exportto_click(object sender, EventArgs e)

{

ContactListControl.Export();

}

in ContactListControl class

public

void Export()

{

ContactListGrid.MasterTableView.Columns.FindByUniqueName(

"ContactImageColumn").Visible = false;

ContactListGrid.MasterTableView.Columns.FindByUniqueName(

"ExternalContact").Visible = false;

ContactListGrid.MasterTableView.Columns.FindByUniqueName(

"LastName").ShowSortIcon = false;

ContactListGrid.PagerStyle.Visible =

false;

ContactListGrid.ExportSettings.ExportOnlyData =

false;

ContactListGrid.ExportSettings.OpenInNewWindow =

true;

ContactListGrid.MasterTableView.ExportToExcel();

}

How can i remove sortIcon from header?

Even i use  showsorticon to false, image is appearing...


Thanks,
 Dileep

[Shinu]

Hi Dileep,

Try making all the columns visible  (which you initially made Visible=False while exporting ) after doing the Export function as shown below.

CS:

public void Export()

{

ContactListGrid.MasterTableView.Columns.FindByUniqueName("ContactImageColumn").Visible = false;

ContactListGrid.MasterTableView.Columns.FindByUniqueName("ExternalContact").Visible = false;

ContactListGrid.MasterTableView.Columns.FindByUniqueName("LastName").ShowSortIcon = false;

ContactListGrid.PagerStyle.Visible =false;

ContactListGrid.Rebind();

ContactListGrid.ExportSettings.ExportOnlyData =false;

ContactListGrid.ExportSettings.OpenInNewWindow =true;

ContactListGrid.MasterTableView.ExportToExcel();

ContactListGrid.MasterTableView.Columns.FindByUniqueName("ContactImageColumn").Visible = True;

ContactListGrid.MasterTableView.Columns.FindByUniqueName("ExternalContact").Visible = True;

ContactListGrid.PagerStyle.Visible =True;

ContactListGrid.Rebind();


}

Thanks
Shinu.