.net导入excel和word 类

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Data.SqlClient;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
private DataSet myDS = new DataSet();

    private void Page_Load(object sender, System.EventArgs e)
    {
        Data_Load();
    }

    #region   Web   重写使用gridView控件时必须重写
    public override void VerifyRenderingInServerForm(Control control)
    {
        // Confirms that an HtmlForm control is rendered for
    }
    #endregion

    private void ExportDataGrid(string FileType, string FileName)
    {
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }

private void Data_Load()
{

        SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("select top 20 * from dbo.spt_values", myConnection);
        cmd.CommandType = CommandType.Text;
        myConnection.Open();

        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }

    DataView CreateDataSource()
    {
        string nowDSN = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection myConnection = new SqlConnection(nowDSN);

SqlCommand cmd = new SqlCommand("select top 20 * from dbo.spt_values", myConnection);
cmd.CommandType = CommandType.Text;

        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;
        da.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        myConnection.Close();
        Page.DataBind();
        return ds.Tables[0].DefaultView;

    }

    protected void BtnImportWord_Click1(object sender, EventArgs e)
    {
        ExportDataGrid("application/ms-word", "Word.doc");
    }

}

//前台

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

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

posted @ 2009-02-18 21:35 学会感恩阅读(747) 评论(0) 编辑收藏举报

园中小雪

雪中小园

.net导入excel和word 类

公告