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

Problem with RadGrid and ExportToExcel in IE8 not in IE7

9 Answers 208 Views

Grid

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

9 Answers, 1 is accepted

answered on 31 May 2010, 09:37 PM

Hello Christopher,

My problem are that the first time I load the website the Grid shows all the rows with data correct.

Then I want to search for a specific name but it return rows that the grid doesn't show.

Can you please provide some more details about this problem? I'm not sure that I understand you completely.

The export to excel function in grid doesn't work in IE8.

This function work in IE7.

This is not a common problem so it is hard to guess what might cause it. I would appreciate if you could post your code or attach a runnable demo (in support ticket) so I can examine the problem locally.

Regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

answered on 01 Jun 2010, 09:12 AM

Hello Daniel!

Thanks for you reply so quick.

The first problem with the grid is when the website loads for the first time, all rows shows upp in the grid.

After I search "Pro" for example there doesn't show any rows, but I can see there are 6 items in the grid that has the letters in the name.

I attached some files for you with the problem.

The code works for sure in IE7,and other browsers but not in IE8. Here is the code

    
            protected void Page_Load(object sender, EventArgs e) 
        
                    { 
        
                        if (!IsPostBack) 
        
                        { 
        
                            Session["DT_LEFT"] = null; 
        
                            Session["DT_RIGHT"] = null; 
        
                            Session["DT"] = null; 
        
                            this.RadGrid1.MasterTableView.Columns.Clear(); 
        
                            this.PopRadGrid2(); 
        
                            this.RadTextBox1_TextChanged(null, null); 
        
                        } 
        
            //Searchbox 
        
            protected void RadTextBox1_TextChanged(object sender, EventArgs e) 
        
                    { 
        
                        string text = RadTextBox1.Text; 
        
                        if (text != null) 
        
                        { 
        
                            Dt = GetDataTable("SELECT * FROM Licenses WHERE LicenseName LIKE '%" + text + "%' ORDER BY LicenseName"); 
        
                            DatabindAll(); 
        
                        } 
        
                    } 
        
            //Highlight the specific letters 
        
             protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) 
        
                    { 
        
                        string searchtext = RadTextBox1.Text.Trim(); 
        
                        if (searchtext.Length > 0) 
        
                        { 
        
                            foreach (TableCell cell in e.Item.Cells) 
        
                            { 
        
                                string cellText = cell.Text; 
        
                                int leftIndex = cellText.IndexOf(searchtext, StringComparison.OrdinalIgnoreCase); 
        
                                if (leftIndex != -1) 
        
                                { 
        
                                    int rightIndex = leftIndex + searchtext.Length; 
        
                                    StringBuilder builder = new StringBuilder(); 
        
                                    builder.Append(cellText, 0, leftIndex); 
        
                                    builder.Append("<span class=\"highlight\">"); 
        
                                    builder.Append(cellText, leftIndex, rightIndex - leftIndex); 
        
                                    builder.Append("</span>"); 
        
                                    builder.Append(cellText, rightIndex, 
        
                                    cellText.Length - rightIndex); 
        
                                    cell.Text = builder.ToString(); 
        
                                } 
        
                            } 
        
                        } 
        
                    } 
        
            //RadGrid1 is Main Grid that shows all data. 
        
            //RadGrid2 and 3 are column chooser. 
        
            private void DatabindAll() 
        
                  { 
        
                      RadGrid RadGrid2 = (RadGrid)RadPanelBar1.FindItemByValue("RadGrid2").FindControl("RadGrid2"); 
        
                      RadGrid2.DataSource = Dt_left; 
        
                      RadGrid2.DataBind(); 
        
                      RadGrid RadGrid3 = (RadGrid)RadPanelBar1.FindItemByValue("RadGrid2").FindControl("RadGrid3"); 
        
                      RadGrid3.DataSource = Dt_right; 
        
                      RadGrid3.DataBind(); 
        
                      RadGrid1.DataSource = Dt; 
        
                      RadGrid1.DataSourceID = string.Empty; 
        
                      RadGrid1.DataBind(); 
        
                  } 
        
             private void ConfigureExport() 
        
                    { 
        
                        RadGrid1.ExportSettings.FileName = "AllLicenses"; 
        
                        RadGrid1.ExportSettings.ExportOnlyData = false; 
        
                        RadGrid1.ExportSettings.IgnorePaging = true; 
        
                    } 
        
             protected void ImageButton1_Click(object sender, ImageClickEventArgs e) 
        
                    { 
        
                        ConfigureExport(); 
        
                        RadGrid1.MasterTableView.ExportToExcel(); 
        
                    }

I think the second problem ExportToExcel is from the first problem. But even if I try to export when the website first load there is nothing in the excel file. But also this is working in all other browsers except IE8.

So I hope we can solve this together.

For a runable demo I need to send sensitive information to your email. You can send you email to:

christopher dot svensson at ateaspintop dot com

Regards

Christopher Svensson

System Developer

atespintop.com

answered on 01 Jun 2010, 09:21 AM

gridonload.PNG

aftersearchgrid.PNG

Files

answered on 04 Jun 2010, 11:25 AM

Hello Christopher,

The problem is probably caused by a databinding issue. I recommend that you try the following options:

1) Set RadGrid1.ExportSettings.IgnorePaging = false; and then let me know whether the problem still persists

2) Try advanced data-binding (NeedDataSource event) instead of simple data-binding. This is the easiest way to address such issues.

Advanced Data-binding topic
Simple Data-binding topic
Advanced Data Binding demo

If you need to share sensitive data/information please use the ticketing system to submit it.

Best regards,
Daniel
the Telerik team

Accepted

answered on 23 Jun 2010, 12:52 PM

Hi everybody out there!

Now I have solve my issue.

If you use Session-variables to store a DataTable in, it can be cause that you get problem with IE8.

This was the problem for me.

IE8 seems to have some security that not allowed me to use Session in this particular case.

Only thing I changed was to use ViewState instead of Session to store my DataTable in.

So now everything works in all the major browsers on the market.

The function ExportToExcel works great when the grid has something to show. This issue was an error that was caused by the Session issue.

Don't forget to Databind and check if your datasource is not empty.

Best Regards

Christopher Svensson

System Developer

Site: www.atespintop.com

Facebook :Ateaspintop

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Problem with RadGrid and ExportToExcel in IE8 not in IE7

9 Answers, 1 is accepted