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

rrowe68Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
connection is not open:
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
            sqlConn.Open
            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

0
 
PaulHewsCommented:
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
0
 
rrowe68Author Commented:
DUH.

Sometime this obvious with me is the hardest part.
0
All Courses

From novice to tech pro — start learning today.