Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to call a stored procedure?
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00641043
Message ID:
00641171
Vues:
14
>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.asp
maybe 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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform