asp.net 怎样将查询结果导出到Excel？解决思路

asp.net 怎样将查询结果导出到Excel？
asp.net 怎样将查询结果导出到Excel？

[解决办法]
我先帮定两个dataGrid，其中一个是隐藏的。

具体导入如下if(this.Datagrid2.Items.Count==0)
{
Response.Write("<script>alert('無信息')</script>");
}
else
{
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";

EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
this.Datagrid3.PagerStyle.Visible = false;


this.Datagrid2.Visible = true;
this.Datagrid2.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
[解决办法]
/// <summary>
/// 将DataTable数据写入Excel文件（自动分页）
/// </summary>
/// <param name="dt">DataTable</param>
/// <param name="rows">每个WorkSheet写入多少行数据</param>
/// <param name="top">表格数据起始行索引</param>
/// <param name="left">表格数据起始列索引</param>
public void DataTableToExcel(DataTable dt,int rows,int top,int left)
{
int rowCount = dt.Rows.Count;//DataTable行数
int colCount = dt.Columns.Count;//DataTable列数
sheetCount = this.GetSheetCount(rowCount,rows);//WorkSheet个数
//StringBuilder sb;

//复制sheetCount-1个WorkSheet对象
for(int i=1;i<sheetCount;i++)
{
workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(i);
workSheet.Copy(missing,workBook.Worksheets[i]);
}

for(int i=1;i<=sheetCount;i++)
{
int startRow = (i - 1) * rows;//记录起始行索引
int endRow = i * rows;//记录结束行索引

//若是最后一个WorkSheet，那么记录结束行索引为源DataTable行数
if(i == sheetCount)
endRow = rowCount;

//获取要写入数据的WorkSheet对象，并重命名
workSheet = (Excel.Worksheet)workBook.Worksheets.get_Item(i);
workSheet.Name = sheetPrefixName + "-" + i.ToString();

//将dt中的数据写入WorkSheet
//for(int j=0;j<endRow-startRow;j++)
//{
//for(int k=0;k<colCount;k++)
//{
//workSheet.Cells[top + j,left + k] = dt.Rows[startRow + j][k].ToString();
//}
//}

//利用二维数组批量写入
int row = endRow-startRow;
string[,] ss = new string[row,colCount];

for(int j=0;j<row;j++)
{
for(int k=0;k<colCount;k++)
{
ss[j,k] = dt.Rows[startRow + j][k].ToString();
}
}

range = (Excel.Range)workSheet.Cells[top,left];
range = range.get_Resize(row,colCount);
range.Value = ss;

#region 利用Windwo粘贴板批量拷贝数据（在Web下面行不通）
/*sb = new StringBuilder();

for(int j=0;j<endRow-startRow;j++)
{
for(int k=0;k<colCount;k++)
{
sb.Append( dt.Rows[startRow + j][k].ToString() );
sb.Append("\t");
}

sb.Append("\n");
}

System.Windows.Forms.Clipboard.SetDataObject(sb.ToString());

range = (Excel.Range)workSheet.Cells[top,left];
workSheet.Paste(range,false);*/
#endregion

}
}


[解决办法]
http://blog.csdn.net/saizhang/archive/2007/09/03/1770437.aspx
[解决办法]
//dtData是要导出为Excel的DataTable,FileName是要导出的Excel文件名(不加.xls)
public static void DataTable2Excel(System.Data.DataTable dtData, String FileName)

{
System.Web.UI.WebControls.GridView dgExport = null;
//当前对话 
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO用于导出并返回excel文件 
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;

if (dtData != null)
{
//设置编码和附件格式 
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)作用是方式中文文件名乱码
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "GB2312";

//导出Excel文件 
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的GridView 
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();

//下载到客户端 
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}