asp.net中Excel导入sql server数据库

 

**.aspx页面：

代码：

<div style="margin-top:15px;">
   
                    <asp:FileUpload ID="FileUpload1"  runat="server" Width="305px" CssClass="reg_table_ctrolbtn"  />
                    <asp:Button ID="Button1" class="reg_table_ctrolbtn" runat="server" OnClick="Button1_Click" Text="导入SQL" />
                   
                   
</div>

------------------------------------------------------------------------------------------------------------

**.aspx.cs页面

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

namespace Web.Admin.StudentInfo
{
    public partial class importInfo : System.Web.UI.Page
    {
        string strConn = ConfigurationManager.ConnectionStrings["StuHelpConnectionString"].ConnectionString;
        //string strConn = "Data Source=ying;DataBase=StuHelp;Uid=sa;Pwd=123"; //链接SQL数据库
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection cn = new SqlConnection(strConn);
            cn.Open();
            //SqlDataAdapter sda = new SqlDataAdapter("select * from class", cn);
            //DataSet ds = new DataSet();
            //sda.Fill(ds);
            //t