<%@ Page Title="主頁" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

<%@ Register assembly="obout_Interface" namespace="Obout.Interface" tagprefix="cc1" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        歡迎使用 ASP.NET!
    </h2>
    <p>
        若要了解關于 ASP.NET 的詳細信息，請訪問 <a href="http://www.tutupao.com/user" title="ASP.NET 網站">www.tutupao.com</a>。
    </p>
    <p>ID:<cc1:OboutTextBox ID="text1" runat="server" ></cc1:OboutTextBox>
       Number:<cc1:OboutTextBox ID="text2" runat="server"></cc1:OboutTextBox>
       <br />
        <cc1:OboutButton ID="OboutButton1" Text="添加到表中>>" runat="server" 
        onclick="OboutButton1_Click" style="top: 0px; left: 0px">
    </cc1:OboutButton>
    <hr />
    <cc1:OboutButton ID="OboutButton2" Text="清空datatable" runat="server" 
        onclick="OboutButton2_Click">
</cc1:OboutButton>

    </p>
    <p>
    
        <asp:GridView ID="GridViewone" runat="server">
        </asp:GridView>
    
    </p>
    <p>
        <asp:TextBox ID="name_exl" runat="server" BackColor="White" 
            BorderColor="#888888" BorderStyle="Ridge" Text="起個名吧"  BorderWidth="3px"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" BackColor="Transparent" 
            BorderStyle="Solid" BorderWidth="3px" BorderColor="#888888" Text="導出Excel" 
            onclick="Button1_Click" />
    
    </p>
    <p>
        您還可以找到 ttp://go.microsoft.com/fwlink/?LinkID=152368"
            title="MSDN ASP.NET 文檔">MSDN 上有關 ASP.NET 的文檔</a>。
    </p>
    
</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Wuqi.Webdiyer;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {



    }
    /// <summary>
    /// 導出excel
    /// </summary>
    /// <param name="ds">DataTable類型的數據集</param>
    /// <param name="FileName">保存文件的默認文件名</param>
    public void CreateExcel(DataTable ds, string FileName)
    {
        HttpResponse resp;
        resp = Page.Response;
        resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName+".xls");
        string colHeaders = "", ls_item = "";
        int i = 0;
        if (ds.Rows.Count > 0)
        {
            DataTable dt = ds;

            //取得數據表各列標題，各標題之間以\t分割，最后一個列標題后加回車符
            colHeaders = "";
            for (i = 0; i < dt.Columns.Count; i++)
            {
                colHeaders += dt.Columns[i].Caption.ToString() + "\t";
            }
            colHeaders += "\n";

            //向HTTP輸出流中寫入取得的數據信息
            resp.Write(colHeaders);

            //逐行處理數據
            foreach (DataRow row in dt.Rows)
            {
                ls_item += "";
                //在當前行中，逐列獲得數據，數據之間以\t分割，結束時加回車符\n
                for (i = 0; i < row.ItemArray.Length; i++)
                {
                    ls_item += row[i].ToString() + "\t";
                }
                ls_item += "\n";

            }
            resp.Write(ls_item);
        }

        //寫緩沖區中的數據到HTTP頭文件中
        resp.End();
    }

    private void binGred(DataTable dt)
    {
        GridViewone.DataSource = dt;
        GridViewone.DataBind();
    }

    protected void OboutButton1_Click(object sender, EventArgs e)
    {
        string t_id = text1.Text;
        string t_num = text2.Text;
        if (Application["data"] != null)
        {
            DataTable dt = Application["data"] as DataTable;
            DataRow drt = dt.NewRow();
            drt["S_id"] = t_id.ToString();
            drt["S_num"] = t_num.ToString();
            dt.Rows.Add(drt);
            Application["data"] = dt;
            binGred(dt);
        }
        else
        {
            DataTable dt = new DataTable();
            DataColumn dc1 = new DataColumn("S_id", typeof(string));
            dt.Columns.Add(dc1);
            DataColumn dc2 = new DataColumn("S_num", typeof(string));
            dt.Columns.Add(dc2);
            DataRow drow = dt.NewRow();
            drow["S_id"] = t_id.ToString();
            drow["S_num"] = t_num.ToString();
            dt.Rows.Add(drow);
            Application["data"] = dt;
            binGred(dt);
        }

    }
    protected void OboutButton2_Click(object sender, EventArgs e)
    {
        Application["data"] = null;
        binGred(null);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Application["data"] != null)
        {
            DataTable db = Application["data"] as DataTable;
            CreateExcel(db,name_exl.Text);
        }
    }
}