|
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/x-excel"; string filename = HttpUtility.UrlEncode("用戶數(shù)據(jù).xls");
context.Response.AddHeader("Content-Disposition", "attachment;filename="+filename); HSSFWorkbook workbook=new HSSFWorkbook();
HSSFSheet sheet=workbook.CreateSheet();
using(SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UserDB.mdf;Integrated Security=True;User Instance=True"))
{ conn.Open();
using (IDbCommand cmd = conn.CreateCommand())
{ cmd.CommandText = "select * from T_Users";
using (IDataReader reader = cmd.ExecuteReader())
{ int rownum = 0;
while (reader.Read())
{
string username = reader.GetString(reader.GetOrdinal("UserName"));
string password = reader.GetString(reader.GetOrdinal("Password"));
HSSFRow row = sheet.CreateRow(rownum);
row.CreateCell(0,HSSFCell.CELL_TYPE_STRING).SetCellValue(username);
row.CreateCell(1,HSSFCell.CELL_TYPE_STRING).SetCellValue(password);
rownum++;
} } } }
workbook.Write(context.Response.OutputStream);
}
|
|
|
來自： 悟靜 > 《JavaScript》
