[RESOLVED] How do I call a Stored Procedure from a VB Sub

[capella07]

I have an Update Stored Procedure on SQL Server and I just simply want to call a Sub that "fires" off that SP.

Sub UpdateTableWithSP()
sqlConn.Open() 'connection declared globally
 
Dim sqlSP As New SqlCommand("MTFE_UpdateTable")
 
sqlSP.Connection = sqlConn
sqlSP.CommandType = CommandType.StoredProcedure
 
sqlSP.ExecuteReader()
 
sqlConn.Close()
End Sub

This doesn't seem right, how exactly is this supposed to be coded?

Thanks!