aspexcel上传数据库

using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;

public partial class UploadExcel : System.Web.UI.Page
{
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile)
        {
            string connectionString = "Server=your_server;Database=your_database;User Id=your_username;Password=your_password;";
            string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileUpload1.FileName + ";Extended Properties='Excel 12.0;HDR=YES;'";

            using (OleDbConnection oleDbConn = new OleDbConnection(excelConnectionString))
            {
                oleDbConn.Open();
                string query = "SELECT * FROM [Sheet1$]";
                using (OleDbCommand oleDbCmd = new OleDbCommand(query, oleDbConn))
                {
                    using (OleDbDataReader reader = oleDbCmd.ExecuteReader())
                    {
                        using (SqlConnection sqlConn = new SqlConnection(connectionString))
                        {
                            sqlConn.Open();
                            string insertQuery = "INSERT INTO YourTable (Column1, Column2, Column3) VALUES (@Column1, @Column2, @Column3)";
                            using (SqlCommand sqlCmd = new SqlCommand(insertQuery, sqlConn))
                            {
                                while (reader.Read())
                                {
                                    sqlCmd.Parameters.Clear();
                                    sqlCmd.Parameters.AddWithValue("@Column1", reader["Column1"]);
                                    sqlCmd.Parameters.AddWithValue("@Column2", reader["Column2"]);
                                    sqlCmd.Parameters.AddWithValue("@Column3", reader["Column3"]);
                                    sqlCmd.ExecuteNonQuery();
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}