exceltosql.aspx.vb

使用互斥量。在进程启动的时候

Imports System.Data.OleDb

Public Class WebForm1
    Inherits System.Web.UI.Page

#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents Label1 As System.Web.UI.WebControls.Label
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
    Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label4 As System.Web.UI.WebControls.Label
    Protected WithEvents Label5 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox3 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label6 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox4 As System.Web.UI.WebControls.TextBox
    Protected WithEvents Label7 As System.Web.UI.WebControls.Label
    Protected WithEvents TextBox5 As System.Web.UI.WebControls.TextBox
    Protected WithEvents field As System.Web.UI.HtmlControls.HtmlInputFile
    Protected WithEvents message As System.Web.UI.WebControls.Label

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cn As OleDbConnection
        Dim strSQL As String


        Try

            cn = New OleDbConnection("Provider=SQLOLEDB;Data Source='" & TextBox3.Text & "';" & _
                "Initial Catalog='" & TextBox1.Text & "';User ID='" & TextBox4.Text & "';Password='" & TextBox5.Text & "'")

            cn.Open()
            'Import by using OPENDATASOURCE.

            strSQL = "Select * into " & TextBox2.Text & " FROM " & _
                "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _
                "'Data Source=" & field.Value & ";" & _
                "Extended Properties=Excel 8.0')...[Sheet1$]"


            Dim com As OleDbCommand
            com = New OleDbCommand(strSQL, cn)
            com.ExecuteNonQuery()
            cn.Close()
        Catch ex As Exception
            ' Response.Write("<script>alert(ex.Message);</script>")
            message.Text = ex.Message
            ' Response.Write(ex.Message)
            Exit Sub
        End Try
        Response.Write("<script>alert('Import Success！');</script>")
    End Sub
End Class