M
mrmagoo
Dim cn As SqlConnection = New SqlConnection("<ConnStr>")
cn.Open()
Dim cmd As SqlCommand = New SqlCommand("scsp_Stored_Proc", cn)
cmd.CommandType = CommandType.StoredProcedure
Dim pc As SqlParameterCollection = cmd.Parameters
pc.Add("@Param1", Param1Val)
pc.Add("@Param2", Param2Val)
If Param3Val <> 0 Then
pc.Add("@Param3", Param3Val)
Else
pc.Add("@Param4", Param4Val)
End If
cmd.ExecuteNonQuery()
what am I doing wrong?
It's erroring out on the last line:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll
Additional information: System error.
cn.Open()
Dim cmd As SqlCommand = New SqlCommand("scsp_Stored_Proc", cn)
cmd.CommandType = CommandType.StoredProcedure
Dim pc As SqlParameterCollection = cmd.Parameters
pc.Add("@Param1", Param1Val)
pc.Add("@Param2", Param2Val)
If Param3Val <> 0 Then
pc.Add("@Param3", Param3Val)
Else
pc.Add("@Param4", Param4Val)
End If
cmd.ExecuteNonQuery()
what am I doing wrong?
It's erroring out on the last line:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred
in system.data.dll
Additional information: System error.