免费国产午夜激情片,最近韩国电影HD中文,久久婷婷五月综合丁香人人爽

用NPOI工具把Sql Server數(shù)據(jù)導(dǎo)入到Excel文件

作者：西西點(diǎn)擊：226次評(píng)論：1次標(biāo)簽： Excel

【excel2007官方下載】Excel Viewer 2007官方中文原版

類(lèi)型：辦公軟件大�。�72.1M語(yǔ)言：中文評(píng)分：.9
標(biāo)簽：

立即下載

代碼中數(shù)據(jù)庫(kù)鏈接字符串自己修改，還有對(duì)應(yīng)的字段名之類(lèi)的信息；

新建一個(gè)Handler.ashx(一般處理程序) 代碼如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using NPOI.HSSF.UserModel;

namespace ExportToExcelWeb
{
    /// <summary>
    /// ExportToExcel 的摘要說(shuō)明
    /// </summary>
    public class ExportToExcel : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "application/x-excel";
            string fileName = HttpUtility.UrlEncode("數(shù)據(jù)庫(kù)文備份.xls");
            context.Response.AddHeader("Content-Disposition", "attachment; fileName=" + fileName);  //添加http協(xié)議報(bào)文;

            HSSFWorkbook workbook = new HSSFWorkbook(); //創(chuàng)建一個(gè)xls；
            HSSFSheet sheet = workbook.CreateSheet(); //創(chuàng)建一個(gè)Sheet頁(yè)

            string connectString = @"server=localhost\sql2008;database=MyBlog; uid=sa; pwd=sql2008";
            SqlConnection connection = new SqlConnection(connectString);
            connection.Open();

            using (IDbCommand cmd = connection.CreateCommand()) //接口編徎;
            {
                cmd.CommandText = "select * from Users";
                using (IDataReader reader = cmd.ExecuteReader())
                {
                    int rowsNum = 0;  //行號(hào)
                    while (reader.Read())
                    {
                        //根據(jù)字段名找出ID
                        string LoginId = reader.GetString(reader.GetOrdinal("LoginId"));
                        string LoginPwd = reader.GetString(reader.GetOrdinal("LoginPwd"));
                        string Name = reader.GetString(reader.GetOrdinal("Name"));
                        string QQ = reader.GetString(reader.GetOrdinal("QQ"));
                        string Mail = reader.GetString(reader.GetOrdinal("Mail"));

                        /******************以上代碼對(duì)應(yīng)數(shù)據(jù)庫(kù)表中的字段*********************/

                        HSSFRow row = sheet.CreateRow(rowsNum);
                        row.CreateCell(0, HSSFCell.CELL_TYPE_STRING).SetCellValue(LoginId);
                        row.CreateCell(1, HSSFCell.CELL_TYPE_STRING).SetCellValue(LoginPwd);
                        row.CreateCell(2, HSSFCell.CELL_TYPE_STRING).SetCellValue(Name);
                        row.CreateCell(3, HSSFCell.CELL_TYPE_STRING).SetCellValue(QQ);
                        row.CreateCell(4, HSSFCell.CELL_TYPE_STRING).SetCellValue(Mail);

                        /******************以上代碼對(duì)應(yīng)Excel文件的列************************/
                        rowsNum++;
                    }
                }
            }

            workbook.Write(context.Response.OutputStream);  //輸出到流中

        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

Aspx頁(yè)面代碼：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ExportToExcelWeb.Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <a href="ExportToExcel.ashx">下載備份數(shù)據(jù)庫(kù)文件到Excel格式</a>
    </div>
    </form>
</body>
</html>

NPOI文件包：http://u.115.com/file/aqr5pjb7