程式搜集分享精靈

protected void Button3_Click(object sender, EventArgs e)
{
HSSFWorkbook wb = new HSSFWorkbook();
MemoryStream ms = new MemoryStream();
HSSFSheet hs= wb.CreateSheet("測試表1") as HSSFSheet;
SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString);
SqlDataReader sr = null;
SqlCommand cmd = new SqlCommand("select * from test", conn);
try
{
conn.Open();
sr = cmd.ExecuteReader();
int k = 0;
while (sr.Read())
{
HSSFRow hr = hs.CreateRow(k) as HSSFRow;
for (int i = 0; i < sr.FieldCount; i++)
{
hr.CreateCell(i).SetCellValue(sr.GetValue(i).ToString());
}
k++;
}
}
catch(Exception ex)
{
Response.Write("錯誤訊息：" + ex.ToString());
}
finally
{
if (sr != null)
{
cmd.Cancel();
sr.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
conn.Dispose();
}
}
wb.Write(ms);
Response.AddHeader("Content-Disposition", String.Format("attachment;fileName=EmptyWorkbook1_db.xls"));
Response.BinaryWrite(ms.ToArray());
wb = null;
ms.Close();
ms.Dispose();
}