微软企业库ExecuteDataset，传参执行方法

最新推荐文章于 2016-09-05 20:36:41 发布

原创最新推荐文章于 2016-09-05 20:36:41 发布 · 1.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#微软 #cmd #dataset #function #database #string

ASP.NET 专栏收录该内容

17 篇文章

订阅专栏

本文深入探讨了如何使用特定的公共共享函数来执行SQL命令，包括存储过程和普通SQL命令，通过参数化操作增强安全性并提高效率。

Public Shared Function ExecuteDataset(ByVal commandType As CommandType, _
ByVal commandText As String, _
ByVal ParamArray commandParameters() As SqlParameter) As DataSet

    Dim db As Database = DatabaseFactory.CreateDatabase()
    Dim cmd As DbCommand

    If commandType = CommandType.StoredProcedure Then
        cmd = db.GetStoredProcCommand(commandText)
    Else
        cmd = db.GetSqlStringCommand(commandText)
    End If

    If Not commandParameters Is Nothing Then
        For Each param As SqlParameter In commandParameters
            db.AddInParameter(cmd, param.Name, param.Type, param.Value)
        Next
    End If

    Return db.ExecuteDataset(cmd)

End Function 'ExecuteDataset