WEB/111.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 BLL;
using MODEL;
using System.ComponentModel;
using System.Data.OleDb;
public partial class _111 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        EntityDataSource();
    }
    private DataTable DataSource
    {
        get
        {
            if (ViewState["_dataSource"] == null)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn("编号"));
                dt.Columns.Add(new DataColumn("名称"));
                //dt.Columns.Add(new DataColumn("new名称"));
                dt.Columns.Add(new DataColumn("备注"));
                //dt.Columns.Add(new DataColumn("new备注"));
                //dt.Columns.Add(new DataColumn("更改状态"));
                ViewState["_dataSource"] = dt;
            }
            return ViewState["_dataSource"] as DataTable;
        }
        set
        {
            ViewState["_dataSource"] = value;
        }
    }

    /// <summary>
    /// 读取Excel数据
    /// </summary>
    /// <param name="filepath"></param>
    /// <returns></returns>
    public DataTable ExcelDataSource(string filepath, ref bool existsSheetname)
    {
        DataTable dt = null;
        string sheetname = "模板工作表$";
        string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
        OleDbConnection conn = new OleDbConnection(strConn);
        conn.Open();
        DataTable sheetNames = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
        conn.Close();