ASP.NET

itsbijusamuel wrote:

Response.Clear();

gvCycleRpt.Columns[8].Visible = false;
string style = @" .text { mso-number-format:\@; } ";
Response.AddHeader("content-disposition", "attachment;filename=CycleReport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter StringWriter = new System.IO.StringWriter();
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
gvCycleRpt.RenderControl(HtmlTextWriter);
// Style is added dynamically
Response.Write(style);
Response.Write(StringWriter.ToString());
Response.End();
gvCycleRpt.Columns[8].Visible = true;

Response.Clear();<br />
<br />
gvCycleRpt.Columns[8].Visible = false;<br />
string style = @"<style> .text { mso-number-format:\@; } </style> ";<br />
Response.AddHeader("content-disposition", "attachment;filename=CycleReport.xls");<br />
Response.Charset = "";<br />
Response.ContentType = "application/vnd.xls";<br />
StringWriter StringWriter = new System.IO.StringWriter();<br />
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);<br />
gvCycleRpt.RenderControl(HtmlTextWriter);<br />
// Style is added dynamically<br />
StringBuilder sb = new StringBuilder();<br />
sb.Append(style);<br />
sb.Append(StringWriter.ToString());<br />
Response.Write(sb.ToString());<br />
Response.End();<br />
gvCycleRpt.Columns[8].Visible = true;

itsbijusamuel wrote:

Now my defalt edit command has UpdateText as Edit. based on a condition i have to change the text to 'Approve'

itsbijusamuel wrote:

I need to do this on runtime and not in design mode.