Hi,

I insert the following snippet and receive th error message "Declaration expected" but I thought the "Dim cmd As New SqlCommand" was the declaration!  What am I missing!

Thanks in advance. 

Public Class Class1
    Dim cmd As New SqlCommand
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT CustomerID, CompanyName FROM Customers WHERE CompanyName LIKE @companyName"
cmd.Connection = conn
    ' Create a SqlParameter for each parameter in the stored procedure.
    Dim companyNameParam As New SqlParameter("@companyName", "a%")
cmd.Parameters.Add(companyNameParam)

End Class

not sure if you have same issue, but have a look

http://news.umailcampaign.com/message/30539.aspx

Many thanks for your response. I've not been online for a while so apologies for not responding sooner.

The following is a code sample copied from Microsoft documentation (reference ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_raddata/html/8a929e96-2cf5-43a5-b5b7-c0a5a397bbc5.htm)

Imports Microsoft.VisualBasic

Public Class Class3
    Dim sqlConnection1 As New System.Data.SqlClient.SqlConnection("ReservationsDBConnectionString")
    Dim cmd As New System.Data.SqlClient.SqlCommand
    Dim rowsAffected As Integer

cmd.CommandText = "StoredProcedureName"
cmd.CommandType = CommandType.StoredProcedure
cmd.Connection = sqlConnection1
sqlConnection1.Open()
rowsAffected = cmd.ExecuteNonQuery()
sqlConnection1.Close() 
End Class
 

I get the error "Declaration expected" for each of the 6 lines before the End Class line. I am clearly missing something terribly simple!

Hi there,

It's because you are not declaring a method i.e. you are trying to run code outside an event handler; try this...

Imports Microsoft.VisualBasic

Public Class Class3

    Dim sqlConnection1 As New System.Data.SqlClient.SqlConnection("ReservationsDBConnectionString")
    Dim cmd As New System.Data.SqlClient.SqlCommand
    Dim rowsAffected As Integer

    ' For security create a public method so it can be referenced from a class instance (you do not expose the class code this way)
    Public Function OpenConn()
        ' Call private method returning the integer value
        Return p_OpenConn()
    End Function

    Private Function p_OpenConn()
        cmd.CommandText = "StoredProcedureName"
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Connection = sqlConnection1
        sqlConnection1.Open()
        rowsAffected = cmd.ExecuteNonQuery()

        ' Now return your value and close the connection
        Return rowsAffected
        sqlConnection1.Close()
    End Function

End Class

Matt,

Many thanks for this fulsome explanation - it's very helpful and greatly appreciated.

Thanks for the kind comments, just glad to help...

Did it resolve your issue?  I think that you can mark the post as answered if it did; i'm happy to offer more help if required