asked on

Trouble with Executing a VB Command against SQL Stored Procedure

Can't get this code to execute - it is telling me that I have an invalid connection.... I know my connection string works because it executes with other statements.

What am i missing?

Thanks.

Dim strCon As String
        Dim xID as Integer
        strCon = "MyConnection"  'Valid Connection String
        Dim sqlConn As New Data.SqlClient.SqlConnection(strCon)
        Dim command As New Data.SqlClient.SqlCommand
 
        Try
            command.Connection = sqlConn
            command.CommandType = Data.CommandType.StoredProcedure
            command.CommandText = "UpdateNewLoan"
            command.Parameters.AddWithValue("@ID", xID)
            command.ExecuteNonQuery()
 
        Catch ex As Exception
            MessageBox.Show("Failed to execute command")
        Finally
            sqlConn.Close()
        End Try

Open in new window

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

PaulHews

Open the connection:

Dim strCon As String
Dim xID as Integer
strCon = "MyConnection" 'Valid Connection String
Dim sqlConn As New Data.SqlClient.SqlConnection(strCon)
Dim command As New Data.SqlClient.SqlCommand

Try
command.Connection = sqlConn
command.CommandType = Data.CommandType.StoredProcedure
command.CommandText = "UpdateNewLoan"
command.Parameters.AddWithValue("@ID", xID)
sqlCon.Open()
command.ExecuteNonQuery()

Catch ex As Exception
MessageBox.Show("Failed to execute command")
Finally
sqlConn.Close()
End Try

rrowe68

ASKER

DUH.

Sometime this obvious with me is the hardest part.