Click here to Skip to main content
15,886,919 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
SledgeHammer018-Feb-12 3:58
SledgeHammer018-Feb-12 3:58 
GeneralRe: Optimising data retrieval in application with high refresh rate Pin
SledgeHammer017-Feb-12 19:27
SledgeHammer017-Feb-12 19:27 
Questionprogramming unknown conditions Pin
SilimSayo7-Feb-12 15:40
SilimSayo7-Feb-12 15:40 
AnswerRe: programming unknown conditions Pin
R. Giskard Reventlov7-Feb-12 15:53
R. Giskard Reventlov7-Feb-12 15:53 
AnswerRe: programming unknown conditions Pin
candogu7-Feb-12 20:32
candogu7-Feb-12 20:32 
AnswerRe: programming unknown conditions Pin
BillWoodruff8-Feb-12 4:06
professionalBillWoodruff8-Feb-12 4:06 
AnswerRe: programming unknown conditions Pin
BobJanova8-Feb-12 4:07
BobJanova8-Feb-12 4:07 
AnswerRe: programming unknown conditions Pin
jschell8-Feb-12 8:23
jschell8-Feb-12 8:23 
AnswerRe: programming unknown conditions Pin
GParkings14-Feb-12 0:24
GParkings14-Feb-12 0:24 
Questionmysql table to Access database Pin
srscuda7-Feb-12 9:42
srscuda7-Feb-12 9:42 
AnswerRe: mysql table to Access database Pin
Richard Andrew x647-Feb-12 10:35
professionalRichard Andrew x647-Feb-12 10:35 

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.