admin/DaoRuStuinfo.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Data.OleDb;
using System.Data.SqlClient;

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

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DaoRu();
    }

    private void DaoRu()
    {
        string XLS_Path = "";
        string XLS_Name = DateTime.Now.Ticks.ToString();
        string fileExtName = "";
        if (FileUpload1.PostedFile.ContentLength > 0)
        {
            try
            {
                fileExtName = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf("."));
                if (fileExtName != ".xls" || fileExtName.Length < 1)
                {
                    Response.Write("<script language=javascript>alert('数据导入失败.可能是文件格式或路径不正确！！！');</script>");
                    return;
                }
                FileUpload1.PostedFile.SaveAs(Server.MapPath("UpFiles/") + XLS_Name + fileExtName);
                XLS_Path = Server.MapPath("UpFiles/") + XLS_Name + fileExtName;
            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
        }
        else
        {
            Response.Write("<script language=javascript>alert('请选择文件后再上传！！！');</script>");
            return;
        }
        string mystring = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = '" + XLS_Path + "'" + ";Extended Properties=Excel 8.0";
        OleDbConnection cnnxls = new OleDbConnection(mystring);
        cnnxls.Open();
        DataTable dtexr = cnnxls.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
        int count = 0;
        //for (int jj = 0; jj < dtexr.Rows.Count; jj++)
        //{
        //string tablename = dtexr.Rows[jj]["TABLE_NAME"].ToString();