December 4, 2008 09:59pm pst

06.13.2008 at 08:47AM PDT, ID: 23483127

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

Exporting GridView to Excel - usual stuff isn't working

Asked by SeTech in Microsoft Visual C#.Net, Programming for ASP.NET, Visual Studio

Tags: ASP.Net

I know that these days, the question of exporting a GridView to Excel is a tired, worn-out one. Questions and answers and websites aboutn on this topic, so don't think I'm just asking the same old how-do-I here. I've got a problem that's annoying, but likely has a simple solution, I just don't know what it is.

So the setup is simple. A GridView. An ImageButton that is supposed to export to Excel when clicked. It's not the only GridView-to-Excel setup I've worked with, and the others are functioning properly. My suspicion is that what's throwing this one off is the fact of having the Edit/Delete column. The last column in the GridView is an Edit/Delete column that is a TemplateColumn. And when I try to export to Excel, the error message I get says "Control 'ctl07' of type 'DataControlLinkButton' must be placed inside a form tag with runat=server.". And if I try to override the "VerifyRenderingInServerForm(Control control)" method, I get yet another error about not being able to call it when I'm trying to, blah blah blah. I even tryied to remove the last column before exporting (as you'll see inside the code snippet below), but it doesn't seem to be working.

In order to try to resolve earlier issues, I am implementing a method I got from the website http://mattberseth.com/, that basically takes the contents of a GridView, breaks it down row by row, cell by cell, and makes everything plain text inside an HTML table, and exports THAT to Excel. But when I try to throw some kind of catch in there for the "DataControlLinkButton" control, I can't because Intellisense can't figure it out and the compiler doesn't recognize it. I even added an else in this structure that if the control inside a cell is none of the recognized one, it's supposed to just flat-out remove it. But somehow, this is slipping through, and I am officially stumped.

So I am attaching the declaration of the GridView column below, so you can see what I mean there, and also the code for my Exporting to Excel methods, so if the answer is in there, glaringly obvious, please help me see it.

Thanks in advance for all help offered!Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:

           
           
             <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>
                        <asp:LinkButton runat="server" Text="Edit" CommandName="Edit" CausesValidation="false" />
                        <asp:LinkButton runat="server" Text="Delete" CommandName="Delete" CausesValidation="false" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:LinkButton runat="server" Text="Update" CommandName="Update" CausesValidation="true" />
                        <asp:LinkButton runat="server" Text="Cancel" CommandName="Cancel" CausesValidation="false" />
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:LinkButton ID="lnkAdd" runat="server" Text="Add" Width="80%" CommandName="Insert"
                            CausesValidation="true" ValidationGroup="OkToValidate" OnClick="lnkAdd_Click" />
                    </FooterTemplate>
                </asp:TemplateField>
///////////////////////////////////////////////////////
protected void btnExport_Click(object sender, ImageClickEventArgs e)
    {
        gvResult.AllowPaging = false;
        gvResult.ShowFooter = false;
        DataControlField dt;
        dt = gvResult.Columns[7];
        gvResult.Columns.Remove(gvResult.Columns[7]);
        Export("claimdir.xls", gvResult);
        gvResult.AllowPaging = true;
        gvResult.ShowFooter = true;
        gvResult.Columns.Insert(7, dt);
    }
 
    /// <summary>
    /// Got this online from http://mattberseth.com/
    /// </summary>
    /// <param name="fileName"></param>
    /// <param name="gv"></param>
    public static void Export(string fileName, GridView gv)
    {
        string style = @"<style> .mytext { mso-number-format:\@; } </style> ";
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.AddHeader(
            "content-disposition", string.Format("attachment; filename={0}", fileName));
        HttpContext.Current.Response.ContentType = "application/ms-excel";
 
        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter htw = new HtmlTextWriter(sw))
            {
                //  Create a table to contain the grid
                Table table = new Table();
 
                //  include the gridline settings
                table.GridLines = gv.GridLines;
 
                //  add the header row to the table
                if (gv.HeaderRow != null)
                {
                    PrepareControlForExport(gv.HeaderRow);
                    table.Rows.Add(gv.HeaderRow);
                }
 
                //  add each of the data rows to the table
                foreach (GridViewRow row in gv.Rows)
                {
                    PrepareControlForExport(row);
                    table.Rows.Add(row);
                }
 
                //  add the footer row to the table -- not in this page
                //if (gv.FooterRow != null)
                //{
                //    PrepareControlForExport(gv.FooterRow);
                //    table.Rows.Add(gv.FooterRow);
                //}
 
                //  render the table into the htmlwriter
                table.RenderControl(htw);
 
                //  render the htmlwriter into the response
                HttpContext.Current.Response.Write(style);
                HttpContext.Current.Response.Write(sw.ToString());
                HttpContext.Current.Response.End();
            }
        }
    }
 
    /// <summary>
    /// Replace any of the contained controls with literals
    /// Got this online from http://mattberseth.com/
    /// </summary>
    /// <param name="control"></param>
    private static void PrepareControlForExport(Control control)
    {
        for (int i = 0; i < control.Controls.Count; i++)
        {
            Control current = control.Controls[i];
            if (current is LinkButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
            }
            else if (current is ImageButton)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
            }
            else if (current is HyperLink)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
            }
            else if (current is DropDownList)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
            }
            else if (current is CheckBox)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
            }
            else if (current is TextBox)
            {
                control.Controls.Remove(current);
                control.Controls.AddAt(i, new LiteralControl((current as TextBox).Text));
            }
            else
            {
                control.Controls.Remove(current);
            }
 
            if (current.HasControls())
            {
                PrepareControlForExport(current);
            }
        }
    }

           
         

Keywords: Exporting GridView to Excel - usual st…

	Title
1	Filter 1 DropDownList With Selection o…
2	Export Datagrid Contents to Excel
3	asp.net gridview
4	How to tie in dropdownlist into gridview
5	Export gridView to CSV
6	Gridview Hyperlink in ASP.NET 2.0…

Loading Advertisement...

20080716-EE-VQP-32 - Hierarchy / EE_QW_2_20070628

1. TheLearn... 421,860
2. jaime_oliv... 376,805
3. Fernando... 287,081
4. Dhaest 160,323
5. p_davis 136,515
6. angelIII 136,230
7. philipjonat... 126,745
8. ragi0017 125,183
9. emoreau 122,202
10. Idle_Mind 117,037
11. graye 105,930
12. prairiedog 101,673
13. ororiole 99,514
14. ShazbotOK 95,170
15. naspinski 92,990
16. gregoryyo... 87,665
17. BondinASP 85,507
18. jcoehoorn 85,290
19. ZachSmith 83,600
20. TechTiger... 78,963
21. GreenGho... 76,620
22. jpaulino 71,265
23. jandromeda 70,285
24. BillyDvD 65,615
25. margajet24 62,348

1. TheLearn... 650,334
2. jaime_oliv... 552,772
3. Fernando... 370,308
4. gregoryyo... 215,715
5. p_davis 208,900
6. Dhaest 194,123
7. Idle_Mind 178,127
8. angelIII 175,780
9. emoreau 154,759
10. ragi0017 132,183
11. gauthampj 127,805
12. graye 126,780
13. philipjonat... 126,745
14. JimBrandley 117,431
15. GreenGho... 110,610
16. ShazbotOK 108,338
17. prairiedog 102,173
18. jcoehoorn 101,915
19. dstanley9 100,134
20. ororiole 99,514
21. surajguptha 98,150
22. naspinski 92,990
23. BondinASP 85,507
24. ZachSmith 83,600
25. jpaulino 79,889

Exporting GridView to Excel - usual stuff isn't working

Asked by SeTech in Microsoft Visual C#.Net, Programming for ASP.NET, Visual Studio

Tags: ASP.Net

About this solution