• GridView数据的导入导出


    前台:

    <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="GridView._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">
       <asp:GridView ID="GridView1" runat="server"    AutoGenerateColumns="False" CellPadding="3"
                             BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px"   >
                            <FooterStyle BackColor="White" ForeColor="#000066" />
                            <Columns>
                                <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
                                <asp:BoundField DataField="姓名" HeaderText="姓名"  />
                                <asp:BoundField DataField="出生日期" HeaderText="出生日期"  />
                                <asp:BoundField DataField="家庭住址" HeaderText="家庭住址"  />
                                <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" />
                                <asp:BoundField DataField="起薪" HeaderText="起薪"  />
                             
                            </Columns>
                            <RowStyle ForeColor="#000066" />
                            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                        </asp:GridView>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="导出" />
            <asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text ="导入" />
        </form>
    </body>
    </html>

    后台:

    using System;
    using System.Collections;
    using System.Configuration;
    using System.Data;
    using System.Linq;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Xml.Linq;
    using System.Text;
    using System.IO;
    using System.Data.OracleClient;
    using System.Data.OleDb;

    namespace GridView
    {
        public partial class _Default : System.Web.UI.Page
        {
            OracleConnection cn;
            //OracleCommand cmd;
            string strCon = "Data Source=192.168.1.103/orcl;User ID=system;Password=sa;Unicode=True";

            protected void Page_Load(object sender, EventArgs e)
            {
                if (!IsPostBack)
                {
                    bind();
                }
            }
            public void bind()
            {
                string sqlStr = "select *from Employee";
                cn = new OracleConnection(strCon);
                OracleDataAdapter da = new OracleDataAdapter(sqlStr, cn);
                DataSet ds = new DataSet();
                cn.Open();
                da.Fill(ds, "Employee");
                GridView1.DataSource = ds;
                GridView1.DataKeyNames = new string[] { "身份证号码" };
                GridView1.DataBind();
                cn.Close();
            }

            protected void Button1_Click(object sender, EventArgs e)
            {
                Export("application/vnd.ms-excel", "学生成绩报表.xlsx");
            }

            private void Export(string FileType, string FileName)
            {
                Response.Charset = "GB2312";
                Response.ContentEncoding = System.Text.Encoding.UTF32;
                Response.AppendHeader("Content-Disposition", "attachment;filename=" +
                   HttpUtility.UrlEncode(FileName, Encoding.UTF32).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();
            }

            public override void VerifyRenderingInServerForm(Control control)
            {

            }

            private DataSet CreateDataSource()
            {
                string strCon;
                strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Employee.xls") + "; Extended Properties=Excel 8.0;";
                OleDbConnection olecon = new OleDbConnection(strCon);
                OleDbDataAdapter myda = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strCon);
                DataSet myds = new DataSet();
                myda.Fill(myds);
                return myds;
            }

            protected void Button2_Click(object sender, EventArgs e)
            {
                GridView1.DataSource = CreateDataSource();
                GridView1.DataBind();
            }
          
        }
    }

  • 相关阅读:
    8 网站用户密码保存
    10 XSRF和XSS
    评分预测
    社会化推荐
    借助上下文信息
    UGC
    冷启动
    Git秘籍:在 Git 中进行版本回退
    Google在三大系统上停止对Chrome Apps的支持
    Windows 的 AD 域寄生于 Linux 机器
  • 原文地址:https://www.cnblogs.com/cpcpc/p/2123130.html
Copyright © 2020-2023  润新知