Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing Parameters - Correctly
Message
De
15/01/2013 15:59:06
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Passing Parameters - Correctly
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01562820
Message ID:
01562820
Vues:
51
I promise, last question....

for today

I've got a Store Procedure that wants parameters @Subbank, @SCN, and @TCN. I'm trying to pass said parameters from VB.

So far, I haven't found anything VB likes yet.

I've tried
.Parameters.Add(Subbank)     && It doesn't like this

.Parameters.Add("Subbank")  && doesn't like this - wants object, not string

.Parameters.Add(@Subbank)  && doesn't like this - Expression expected
All three of these examples have come up in various results of Google-fu.

What is the correct way?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform