Call SQL Stored Procedure

[richself]

I'm connecting to a SQL Database and would like to know how to call a stored procedure from my program. Or would it be easier to create the procedure in VB? My SP are simply, Update_Report, Insert_Report and where created in SQL's Enterprise Manager.

Thanks

 

[RiverGuy]

Use a .SqlCommand object.

 

[chrissie1]

Me thinks Riverguy's answer are getting shorter.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[JohnEfford]

Do not forget to set the command type to stored procedure

command.CommandType = CommandType.StoredProcedure