使用en VB.网 [英] Using en VB. NET

问题描述

您好:

使用使用"时出现如下智能错误:

Hi:

I have a intelisense error when I use "Using" as follow:

<br />
Using (dbCommand = New SqlClient.SqlCommand(sqlText, dbConn))<br />
    dbCommand.Connection.Open()<br />
    dbScan = dbCommand.ExecuteReader()<br />
End Using<br />

智力说:

The intelisense says:

"Operator ''='' not defined for types System.Data.SqlClient.SqlCommand

整个代码是:

The whole codes is:

Public Function GetConnectionStr() As String

        GetConnectionStr = ConnectionStrings("SQLDB").ConnectionString
        Return GetConnectionStr

End Function
Public Function CreateReader(ByVal sqlText As String) As SqlClient.SqlDataReader
        Dim dbCommand As SqlClient.SqlCommand
        Dim dbScan As SqlClient.SqlDataReader
        Dim dbConn As SqlConnection

        dbConn = New SqlConnection(GetConnectionStr)

        If Not (HoldTransaction Is Nothing) Then dbCommand.Transaction = HoldTransaction

<code>Using (dbCommand = New SqlClient.SqlCommand(sqlText, dbConn))</code>
            dbCommand.Connection.Open()
            dbScan = dbCommand.ExecuteReader()
        End Using

        dbCommand = Nothing
        Return dbScan
End Function

多谢您的帮助

问候

César

I''ll appreciate your help

regards

César

推荐答案

Cesar Parrales写道:

Cesar Parrales wrote:

使用(dbCommand = New SqlClient.SqlCommand (sqlText，dbConn))

Using (dbCommand = New SqlClient.SqlCommand(sqlText, dbConn))

那不是创建命令的正确方法.

如果打开，可以将using与连接一起使用，而不是与命令一起使用.
看这里:
SqlCommand类 [ SqlConnection类 [

Thats not right way to create a command.

Using can be used with connection if open, not with a command.
Look here:
SqlCommand Class[^]
SqlConnection Class[^]

感谢很多，

我进行了更改，它看起来如下:

Thanks a lot,

I made the changes and it looks as follow:

Public Function GetConnectionStr() As String

    GetConnectionStr = ConnectionStrings("SQLDB").ConnectionString
    Return GetConnectionStr

End Function
Public Function CreateReader(ByVal sqlText As String) As SqlClient.SqlDataReader
    Dim dbCommand As SqlClient.SqlCommand
    Dim dbScan As SqlClient.SqlDataReader
    Dim cnxTxt As String

    cnxTxt = GetConnectionStr()

    Using dbConn As New SqlConnection(cnxTxt)
        dbCommand = New SqlClient.SqlCommand(sqlText, dbConn)
        If Not (HoldTransaction Is Nothing) Then dbCommand.Transaction = HoldTransaction
        dbCommand.Connection.Open()
        dbScan = dbCommand.ExecuteReader()
    End Using

    dbCommand = Nothing
    Return dbScan

End Function

再次感谢，

塞萨尔(César)

Again thanks,

César

这篇关于使用en VB.网的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！