datagrid的数据到处到excel出现错误
我的datagrid里有EditCommandColumn列,且ButtonType="LinkButton"
还有一个Checkbox列
导出到Excel时出现问题:型“DataGridLinkButton”的控件“recorddg__ctl2__ctl0”必须放在具有 runat=server 的窗体标记内。
代码:
private void exportbt_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.Buffer= true;
Response.Charset="GB2312";
Response.AppendHeader("Content-Disposition","attachment;filename=FileName.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter (oStringWriter);
this.recorddg.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
可datagrid里有runat=server啊
问题点数:20、回复次数:5Top
1 楼freedomfans(见了鬼)回复于 2004-12-03 13:52:50 得分 0
还有,我不希望把EditCommandColumn列和Checkbox列的内容导出到Excel里去,该如何做啊 ?Top
2 楼jxzhang615(冰河)回复于 2004-12-03 13:58:34 得分 2
帮顶!Top
3 楼liuwaiqiang1981(在郁闷中努力)回复于 2004-12-03 14:07:48 得分 16
http://blog.csdn.net/sheercony/archive/2004/07/13/40642.aspx
http://www.lionsky.net/MyWebsite/article/list.aspx?id=428Top
4 楼zhangqilin(zql)回复于 2004-12-03 15:22:37 得分 2
哥们帮你顶,我的问题和你一样Top
5 楼freedomfans(见了鬼)回复于 2004-12-03 17:07:30 得分 0
我把要输出的数据帮定到另一个datagrid,不要的数据不绑定,这样就可以了Top




