C#文件上传

using System;
using System.IO;
using System.Net;
using System.Web;
using System.Web.Script.Serialization;
using System.Data.SqlClient;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using OfficeOpenXml;
//引用Epplus.dll

//apsx.cs的文件上传
  protected void Button1_Click(object sender, EventArgs e)
    {
        if (THBIAO.HasFile)
        {
            Random random = new Random();

            //保存文件的虚拟路径
            string path = "../../photos/";

            //获取选择的文件名
            string fileName = THBIAO.PostedFile.FileName;

            //获取文件扩展名称
            string fileExt = Path.GetExtension(fileName);

            if (fileExt == ".xls" || fileExt == ".xlsx")
            {
                //生成新文件名
                string newName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + random.Next(0, 9999).ToString();

                //获取指定虚机路径的物理路径
                string fullPath = HttpContext.Current.Server.MapPath(path);

                //上传文件保存路径
                string savePath = fullPath + newName + fileExt;

                //保存文件到服务器
                THBIAO.PostedFile.SaveAs(savePath);

                try
                {
                    //获取导入的数据
                    DataSet ds = ImportExcel(savePath);
                    if (ds != null && ds.Tables.Count > 0)
                    {
                        //这里可以写插入数据库的方法
                        try
                        {
                            insertDate(ds);
                        }
                        catch (Exception ex)
                        {
                            Page.ClientScript.RegisterStartupScript(this.GetType(), "view", "hide_wait()", true);
                            string scri = "";
                            scri = "<script language ='javascript'>  alert(\"导入的样本信息结构不符合要求！" + ex.Message + "\"); </script>";
                            ClientScript.RegisterStartupScript(this.GetType(), "alert1", scri);
                        }

                    }
                }
                catch (Exception ex)
                {

                    throw;
                }
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "view", "hide_wait()", true);
                string scri = "";
                scri = "<script language ='javascript'>  alert(\"请传递excel文件！\"); </script>";
                ClientScript.RegisterStartupScript(this.GetType(), "alert1", scri);

            }
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "view", "hide_wait()", true);
            string scri = "";
            scri = "<script language ='javascript'>  alert(\"请传递excel文件！\"); </script>";
            ClientScript.RegisterStartupScript(this.GetType(), "alert1", scri);


        }
    }

//返回DataSet
 public DataSet ImportExcel(string filePath)
    {
        DataSet ds = null;

        try
        {
            //打开文件
            FileStream fileStream = new FileStream(filePath, FileMode.Open);

            //读取文件流
            ExcelPackage package = new ExcelPackage(fileStream);

            //获取 sheet 表
            ExcelWorksheets worksheets = package.Workbook.Worksheets;

            ExcelWorksheet worksheet = null;

            ds = new DataSet();
            DataTable dt = null;

            for (int i = 1; i <= worksheets.Count; i++)
            {
                dt = new DataTable();
                dt.TableName = "table" + i.ToString();

                worksheet = worksheets[i];

                //获取行数
                int rowCount = worksheet.Dimension.End.Row;

                //获取列数
                int colCount = worksheet.Dimension.End.Column;

                //起始行为 1 
                int rowIndex = worksheet.Dimension.Start.Row;

                //起始列为 1 
                int colIndex = worksheet.Dimension.Start.Column;

                DataColumn dc = null;

                for (int j = colIndex; j <= colCount; j++)
                {
                    dc = new DataColumn(worksheet.Cells[rowIndex, j].Value.ToString());
                    dt.Columns.Add(dc);
                }

                rowIndex++;

                for (int k = rowIndex; k <= rowCount; k++)
                {
                    DataRow dr = dt.NewRow();

                    for (int l = colIndex; l <= colCount; l++)
                    {
                        if (worksheet.GetValue(k, l) == null)
                        {
                            continue;
                        }

                        dr[l - 1] = worksheet.GetValue(k, l).ToString();
                    }

                    dt.Rows.Add(dr);
                }

                ds.Tables.Add(dt);
            }

            package.Dispose();

            worksheet = null;
            worksheets = null;
            package = null;

            fileStream.Close();
            fileStream.Dispose();
        }
        catch (Exception ex)
        {
            throw;
        }

        return ds;
    }