Datagrid Export to Excel

r_ganesh76 · April 15th, 2005, 02:22 AM

Hi Experts,

I am held up with a problem. I have a datagrid in my aspx search page and I also have an "Export to Excel" button both of which will be displayed when a valid search is made. I have the following code written in my Export Button click event.

The grid contains LinkButtons inside one of the Template Columns and other bound columns.

when I export the grid to excel, I get the correct output the first time. However, if the grid data changes, I am not getting the changed result in the excel. The old data is retained all the time. If i reset the IIS and then do a fresh query, I get the correct result.

Can anyone please help me solve this issue.

Thanking in advance

Regards
Ganesh

r_ganesh76 · April 15th, 2005, 02:26 AM

I thought the code which I used would be useful for solving this issue.

Code:

private void cmdExportToExcel_Click(object sender, System.EventArgs e)
{
    Response.Clear(); 
    Response.Buffer = true; 
    Response.ContentType = "application/vnd.ms-excel"; 
    Response.Charset = ""; 
    EnableViewState = false; 
    System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 

    // Optional function call to convert the controls to string literals 
    ClearControls(MyGrid);     
    MyGrid.RenderControl(oHtmlTextWriter); 

    Response.Write(oStringWriter.ToString()); 
    Response.End(); 
}

private void ClearControls(Control Ctrl) 
{ 
    for (int i= Ctrl.Controls.Count - 1; i >= 0; i--) 
    { 
        ClearControls(Ctrl.Controls[i]); 
    } 
    string x = Ctrl.GetType().ToString();

    if (!(Ctrl is TableCell)) 
    { 
        if (Ctrl.GetType().GetProperty("SelectedItem") != null) 
        { 
            LiteralControl Lt = new LiteralControl(); 
            Ctrl.Parent.Controls.Add(Lt); 
            try 
            { 
                Lt.Text = (string)Ctrl.GetType().GetProperty("SelectedItem").GetValue(Ctrl, null); 
            } 
            catch {} 

            Ctrl.Parent.Controls.Remove(Ctrl); 
        } 
        else if (Ctrl is LinkButton)
        {
            LiteralControl Lt = new LiteralControl(); 

            Lt.Text = ((LiteralControl) Ctrl.Controls[0]).Text;
            Ctrl.Parent.Controls.Add(Lt); 
            Ctrl.Parent.Controls.Remove(Ctrl); 
        }
        else if (Ctrl.GetType().GetProperty("Text") != null) 
        { 
            LiteralControl Lt = new LiteralControl(); 
            Ctrl.Parent.Controls.Add(Lt); 
            Lt.Text = (string)Ctrl.GetType().GetProperty("Text").GetValue(Ctrl, null); 

            Ctrl.Parent.Controls.Remove(Ctrl); 
        }
    } 
    return; 
}

Regards
Ganesh

gadhiav · April 15th, 2005, 05:12 AM

Hi Ganesh,
What happening is that you are not able to clear the objects value after the first runthrough of your code.
Just try to dispose off all the objects that you have created during your code just befreo completing execution.

Hope this works..
Cheers....
Vishal

Life is not the Triumph but the Struggle

r_ganesh76 · April 19th, 2005, 04:15 AM

Thanx Vishal,

That was some problem with the browser settings. Everything is working fine when the same site is accessed from a different machienes.

Now I have another problem. I have implemeted paging in my datagrid. But I want all the rows to be exported to Excel. Is there any way to achieve this.

Thanking in advance

Regards
Ganesh