[RESOLVED] Collect a returned value from SP

[goluguddu]

Hi thanks alot for help..but still its not working. Here is the code I am running....

SQL = "EXEC ins_Template " & _
                      "@vchar_TemplateName = '" & Name & "'," & _
                      "@int_CustomerId = " & CustomerID
 
Dim UCommand As SqlClient.SqlCommand = New SqlCommand(SQL, BlitzKarte4.GlobalConnection)
 
UCommand.Parameters.Add(New SqlClient.SqlParameter("@vchar_TemplateName", SqlDbType.VarChar, 100))
        UCommand.Parameters.Add(New SqlClient.SqlParameter("@int_CustomerId", SqlDbType.Int))
 
        UCommand.Parameters("@vchar_TemplateName").Value = Name
        UCommand.Parameters("@int_CustomerId").Value = CustomerID
 
        MyResult = UCommand.ExecuteScalar()