how can I call an store procesure on visual studio?

Question

Let't assume the sql connection is opened already but if I just do and Sql command ("exec sp_name where @id=" '" + a +"') does nothing.

Answer 1

Use Sqlcommad class, refer msdn for syntax help..

Answer 2

exec sp_name @id="+a+"