asp.net C# 实现上传Excel文件导入数据到SQL Server 数据库

最新推荐文章于 2025-05-07 11:01:06 发布

Hunter_猎手

最新推荐文章于 2025-05-07 11:01:06 发布

阅读量1.2w

点赞数 15

分类专栏： C# asp.net

本文链接：https://blog.youkuaiyun.com/eagle_or_snail/article/details/82748226

版权

前台代码，有点简单：


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
      <div>
      <asp:FileUpload ID="FileUpload1" runat="server" />
      <asp:Button ID="Button1" runat="server"  Text="确定上传" onclick="Button1_Click" />
     </div>
    </form>
</body>
</html>

后台完整代码：


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;

namespace fileUpLoad
{
    public partial class Index : System.Web.UI.Page
    {
        /// <summary>
        /// time=2018.9.17
        /// </summary>
        /// <param name="fileUrl">文件的完整路径（包括扩展名）</param>
        /// <returns>DataTabl</returns>
         public static DataTable GetExcelDatatable(string fileUrl)
        {
            //支持.xls和.xlsx，即