Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterization of a query
Message
De
12/09/2010 18:28:29
 
 
À
12/09/2010 16:46:58
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01480890
Message ID:
01480913
Vues:
45
>>FYI. Unless @ has a meaning in .net it has no importance in Sql Anywhere. Unlike Sql Server, you don't have to start a variable with an @ sign.
>
>Yes, that is what I found. Does this mean that in general, no matter the backend, when we parameterize everything that we usually are ok with the ? approach?


The ? is only OK if you're using the OleDbDataAdapter. If you're using the SqlDataAdapter, you *must* use named parameters (those that start with @).

~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform