查了很多资料,感觉应该能解决的,但是一天时间过去了,还是无可奈何,请教了,如果没有解决方法,只好换方案了。
测试代码如下:
<%@ Page language="C#" %>
<%@ Import Namespace="System.Data" %><html>
<script runat="server">DataTable Store = new DataTable();
DataView StoreView; void Page_Load(Object sender, EventArgs e)
{
if(Session["StoreData"] == null)
{
DataRow dr;
Store = new DataTable(); Store.Columns.Add(new DataColumn("Item", typeof(String)));
Session["StoreData"] = Store;
// Create sample data.
for (int i = 1; i <= 4; i++)
{
dr = Store.NewRow();
dr[0] = "0.0%";
Store.Rows.Add(dr);
} }
else
Store = (DataTable)Session["StoreData"]; StoreView = new DataView(Store);
StoreView.Sort="Item"; if(!IsPostBack)
BindGrid();
}void BindGrid()
{
MyDataGrid.DataSource = StoreView;
MyDataGrid.DataBind();
}private void Button1_Click(object sender, System.EventArgs e)
{
//export to excel Response.Clear();
Response.Charset = "";
Response.Buffer= true;
Response.AddHeader("Content-Disposition", "attachment; filename=myXls.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//this.ClearControls(MyDataGrid);
MyDataGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
private void ClearControls(Control control)
{
for (int i=control.Controls.Count -1; i>=0; i--)
{
ClearControls(control.Controls[i]);
}
if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
}
catch
{
}
control.Parent.Controls.Remove(control);
}
else
if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
Response.Write(literal.Text);
control.Parent.Controls.Remove(control);
}
}
return;
}
void Item_Bound(Object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
e.Item.Cells[0].Text=Convert.ToString(e.Item.ItemIndex);
}
} </script><body> <form runat="server">
<asp:Button id="Button1" runat="server" Text="导出表格" OnClick="Button1_Click"></asp:Button> <asp:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
CellPadding="2"
ShowFooter="True"
AutoGenerateColumns="false"
OnItemDataBound="Item_Bound"
> <Columns>
<asp:TemplateColumn> <HeaderTemplate>
<b> 所得税 </b>
</HeaderTemplate> <ItemTemplate>
<asp:TextBox id="sds" runat="server"/>
</ItemTemplate>
</asp:TemplateColumn>
</Columns> </asp:DataGrid> </form></body>
</html>
问题:1、转换EXCEL时TemplateColumn无值;2、中文乱码
测试代码如下:
<%@ Page language="C#" %>
<%@ Import Namespace="System.Data" %><html>
<script runat="server">DataTable Store = new DataTable();
DataView StoreView; void Page_Load(Object sender, EventArgs e)
{
if(Session["StoreData"] == null)
{
DataRow dr;
Store = new DataTable(); Store.Columns.Add(new DataColumn("Item", typeof(String)));
Session["StoreData"] = Store;
// Create sample data.
for (int i = 1; i <= 4; i++)
{
dr = Store.NewRow();
dr[0] = "0.0%";
Store.Rows.Add(dr);
} }
else
Store = (DataTable)Session["StoreData"]; StoreView = new DataView(Store);
StoreView.Sort="Item"; if(!IsPostBack)
BindGrid();
}void BindGrid()
{
MyDataGrid.DataSource = StoreView;
MyDataGrid.DataBind();
}private void Button1_Click(object sender, System.EventArgs e)
{
//export to excel Response.Clear();
Response.Charset = "";
Response.Buffer= true;
Response.AddHeader("Content-Disposition", "attachment; filename=myXls.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
//this.ClearControls(MyDataGrid);
MyDataGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
private void ClearControls(Control control)
{
for (int i=control.Controls.Count -1; i>=0; i--)
{
ClearControls(control.Controls[i]);
}
if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
}
catch
{
}
control.Parent.Controls.Remove(control);
}
else
if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
Response.Write(literal.Text);
control.Parent.Controls.Remove(control);
}
}
return;
}
void Item_Bound(Object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
e.Item.Cells[0].Text=Convert.ToString(e.Item.ItemIndex);
}
} </script><body> <form runat="server">
<asp:Button id="Button1" runat="server" Text="导出表格" OnClick="Button1_Click"></asp:Button> <asp:DataGrid id="MyDataGrid" runat="server"
BorderColor="black"
CellPadding="2"
ShowFooter="True"
AutoGenerateColumns="false"
OnItemDataBound="Item_Bound"
> <Columns>
<asp:TemplateColumn> <HeaderTemplate>
<b> 所得税 </b>
</HeaderTemplate> <ItemTemplate>
<asp:TextBox id="sds" runat="server"/>
</ItemTemplate>
</asp:TemplateColumn>
</Columns> </asp:DataGrid> </form></body>
</html>
问题:1、转换EXCEL时TemplateColumn无值;2、中文乱码
解决方案 »
- MS-SQL 表中一列有"已下单""处理中""已完成"三种,请问如何把数据按照已下单、处理中、已完成来排列
- |zyciis| NHibernate 在 Left join 的时候,On 如何添加条件,谢谢
- 讨论关于网站页面内容的显示问题
- 新手请教dropdownlist与textbox绑定的问题。
- 请问哪有较新版的C#.NET应用实例下载?顺便散100分
- 兄弟谁有线程的例子怎么把一个循环分成几个线程运行呢
- 新手提问:asp.net确认对话框的问题
- 代码高亮显示
- C#的This是什么意思?
- 谁有《中国青年出版社》的精通《C#与ASP.NET程序设计》的光盘的源程序
- 菜鸟请教: windows 2003 下安装 asp.net 2.0/1.0
- 急问三个问题,把所有分数都拿出来了!
{
//export to excelResponse.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=myXls.xls");
Response.ContentType = "application/vnd.ms-excel";this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);MyDataGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();}