I have one stored procedure in MS SQL Server.

sp_DeleteEmployee @id INT

I can call this stored procedure by two way.
One is:
VB Code:
  1. cnn.Execute "sp_DeleteEmployee " & txtID.Text
The other used Command Objcet and Parameter, then execute the Command Object.


Which one is better? why?