excel导入asp数据库

using OfficeOpenXml;

public DataTable ReadExcelFile(string filePath)
{
    var dataTable = new DataTable();
    using (var package = new ExcelPackage(new FileInfo(filePath)))
    {
        var worksheet = package.Workbook.Worksheets[0];
        foreach (var firstRowCell in worksheet.Cells[1, 1, 1, worksheet.Dimension.End.Column])
        {
            dataTable.Columns.Add(firstRowCell.Value.ToString());
        }
        for (int row = 2; row <= worksheet.Dimension.End.Row; row++)
        {
            var rowData = worksheet.Cells[row, 1, row, worksheet.Dimension.End.Column];
            DataRow dataRow = dataTable.NewRow();
            foreach (var cell in rowData)
            {
                dataRow[cell.Start.Column - 1] = cell.Value;
            }
            dataTable.Rows.Add(dataRow);
        }
    }
    return dataTable;
}

public void InsertDataToDatabase(DataTable dataTable)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        foreach (DataRow row in dataTable.Rows)
        {
            string query = "INSERT INTO TableName (Column1, Column2) VALUES (@Column1, @Column2)";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Column1", Convert.ToInt32(row["Column1"]));
                command.Parameters.AddWithValue("@Column2", row["Column2"].ToString());
                command.ExecuteNonQuery();
            }
        }
    }
}

public void InsertDataToDatabase(DataTable dataTable)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        foreach (DataRow row in dataTable.Rows)
        {
            string query = "IF NOT EXISTS (SELECT 1 FROM TableName WHERE Column1 = @Column1) INSERT INTO TableName (Column1, Column2) VALUES (@Column1, @Column2)";
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Column1", Convert.ToInt32(row["Column1"]));
                command.Parameters.AddWithValue("@Column2", row["Column2"].ToString());
                command.ExecuteNonQuery();
            }
        }
    }
}