Click here to Skip to main content
15,915,702 members
Home / Discussions / C#
   

C#

 
AnswerRe: EKRN.EXE Pin
Luc Pattyn8-Feb-12 5:33
sitebuilderLuc Pattyn8-Feb-12 5:33 
GeneralRe: EKRN.EXE Pin
Eddy Vluggen8-Feb-12 6:12
professionalEddy Vluggen8-Feb-12 6:12 
GeneralRe: EKRN.EXE Pin
Dave Kreskowiak8-Feb-12 2:28
mveDave Kreskowiak8-Feb-12 2:28 
AnswerRe: EKRN.EXE Pin
Calla7-Feb-12 21:16
Calla7-Feb-12 21:16 
AnswerRe: EKRN.EXE Pin
BobJanova8-Feb-12 4:11
BobJanova8-Feb-12 4:11 
AnswerRe: EKRN.EXE Pin
Wes Aday8-Feb-12 5:31
professionalWes Aday8-Feb-12 5:31 
GeneralRe: EKRN.EXE Pin
candogu8-Feb-12 19:25
candogu8-Feb-12 19:25 
GeneralRe: EKRN.EXE Pin
Pete O'Hanlon8-Feb-12 22:12
mvePete O'Hanlon8-Feb-12 22:12 
GeneralRe: EKRN.EXE Pin
candogu9-Feb-12 2:54
candogu9-Feb-12 2:54 
QuestionResource Sharing and Conflict Management System Pin
shaistamin7-Feb-12 19:20
shaistamin7-Feb-12 19:20 
AnswerRe: Resource Sharing and Conflict Management System Pin
Richard MacCutchan7-Feb-12 22:38
mveRichard MacCutchan7-Feb-12 22:38 
AnswerRe: Resource Sharing and Conflict Management System Pin
Eddy Vluggen8-Feb-12 0:21
professionalEddy Vluggen8-Feb-12 0:21 
QuestionReplacing LF with CRLF in text file Pin
KimberlyKetchum7-Feb-12 19:06
KimberlyKetchum7-Feb-12 19:06 
AnswerRe: Replacing LF with CRLF in text file Pin
SledgeHammer017-Feb-12 19:36
SledgeHammer017-Feb-12 19:36 
Questionsend mail in windows application Pin
Member 6126317-Feb-12 18:59
Member 6126317-Feb-12 18:59 
AnswerRe: send mail in windows application Pin
SledgeHammer017-Feb-12 19:32
SledgeHammer017-Feb-12 19:32 
AnswerRe: send mail in windows application Pin
Richard MacCutchan7-Feb-12 22:37
mveRichard MacCutchan7-Feb-12 22:37 
AnswerRe: send mail in windows application Pin
Jitendra Parida - Jeetu8-Feb-12 1:25
Jitendra Parida - Jeetu8-Feb-12 1:25 
QuestionExport to excel attachments not coming in excel Pin
Vinayak B7-Feb-12 18:36
Vinayak B7-Feb-12 18:36 
Hi All,

I have got stuck with some issue with export option of gridview to excel sheet. Kindly help me is sloving the porblem. Attachments are not coming in the excel exported.

Thank you.

Here is code

public void Export(string fileName, GridView gv) 
        { 
            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 form to contain the grid  
                    Table table = new Table(); 
                     
                    table.GridLines = GridLines.Both; 
                     
 
                    //  add the header row to the table  
                    if (gv.HeaderRow != null) 
                    { 
                        PrepareControlForExport(gv.HeaderRow); 
                        table.Rows.Add(getheader()); 
                        table.Rows.Add(gv.HeaderRow); 
                        table.Rows[0].BackColor = System.Drawing.Color.FromArgb(37, 96, 133); 
                    } 
 
                    //  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  
                    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(sw.ToString()); 
                    HttpContext.Current.Response.End(); 
                } 
            } 
        } 
 
 
/// <summary>  
        /// Replace any of the contained controls with literals  
        /// </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")); 
                } 
 
                if (current.HasControls()) 
                { 
                    PrepareControlForExport(current); 
                } 
            } 
        } 

QuestionOptimising data retrieval in application with high refresh rate Pin
brendanpi7-Feb-12 17:16
brendanpi7-Feb-12 17:16 
AnswerRe: Optimising data retrieval in application with high refresh rate Pin
SledgeHammer017-Feb-12 18:34
SledgeHammer017-Feb-12 18:34 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
brendanpi7-Feb-12 18:40
brendanpi7-Feb-12 18:40 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
Mycroft Holmes7-Feb-12 18:48
professionalMycroft Holmes7-Feb-12 18:48 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
SledgeHammer017-Feb-12 19:30
SledgeHammer017-Feb-12 19:30 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
Mycroft Holmes7-Feb-12 20:08
professionalMycroft Holmes7-Feb-12 20:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.