asp.net(vb.net)连接sql server 2000数据库的连接模块(module)

最新推荐文章于 2018-07-05 08:46:00 发布

原创最新推荐文章于 2018-07-05 08:46:00 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#asp.net #module #sql server #vb.net #数据库 #dataset

Asp.net 专栏收录该内容

10 篇文章

订阅专栏

博客展示了一个名为MdlCommon的Module，包含存放SQL语句、记录集和错误信息的变量。定义了ExecuteSQL函数，用于执行SQL语句，根据不同类型的语句进行不同处理，最后给出了在ASP.NET后台调用该函数的示例。

Module MdlCommon
    Public txtSQL As String     '存放SQL语句
    Public DBSet As DataSet     '查询得到的记录集
    Public ErrorMsg As String   '存放错误信息

    Public Function ExecuteSQL(ByVal strSQL As String, ByRef errMsg As String) As DataSet
        Dim cnn As SqlClient.SqlConnection
        Dim cmd As New SqlClient.SqlCommand()
        Dim adpt As SqlClient.SqlDataAdapter
        Dim rst As New DataSet()
        Dim SplitSQL() As String
        errMsg = ""
        Try
            SplitSQL = Split(strSQL)
            cnn = New SqlClient.SqlConnection("data source=(local);initial catalog=urp;user id=sa;pwd=1234")

            If InStr("INSERT,DELETE,UPDATE", UCase$(SplitSQL(0))) Then
                cmd.Connection = cnn
                cmd.Connection.Open()
                cmd.CommandText = strSQL
                cmd.ExecuteNonQuery()
            Else
                adpt = New SqlClient.SqlDataAdapter(strSQL, cnn)
                adpt.Fill(rst)
                ExecuteSQL = rst
            End If
        Catch ex As Exception
            errMsg = ex.Message
        Finally
            rst = Nothing
            cnn = Nothing
        End Try
    End Function End Module
调用时在asp.net后台写上txtSQL="SELECT ....FROM........";
DBSet=ExecuteSQL(txtSQL,ErrorMsg)