>How do you call a stored procedure in VB.NET? Also, I haven't done this before, but someone told me that you can attach a stored procedure to a connection object and run it just like a method. How is this possible? Is there a design interface that shows this? Where is this interface? Thanks for the help.
VFP or SQL Server?
SP returns rows or just a single value?
If your stored proc doesn't return any rows you can run ExecuteNonQuery of the Command Object.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/bdadotnetdata1.aspmaybe thats what they were talking about? Of course you can create your own Data Access component and make up your own method that calls the stored procedure.