Visual studio 2005 (VB) and SQL code (1 Viewer)

[cooldods]

Ive designed my stored procedures in SQL code and have them set as stored procedures on my database in VB BUT i dont know how to call them, or to use any SQL code in Visual basic, if anyone knows how could they please tell me, or direct me to somewhere i could find out

 

[Winston]

You have to use the SqlCommand object.

Create an instance of that object, making sure you pass in the name of the stored procedure as an argument, and then set the CommandType to CommandType.StoredProcedure.

Invoke the ExecuteReader()/ExecuteNonQuery() methods, depending on what you want to do.

Check this link out:

http://www.c-sharpcorner.com/UploadFile/dclark/InsOutsinCS11302005072332AM/InsOutsinCS.aspx