Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLParameter converting to integer
Message
 
 
À
24/06/2008 10:35:32
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
C# 3.0
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01326205
Message ID:
01326368
Vues:
20
>>>At least I think I tried it yesterday already.
>>>>
>>>>BTW, what about my other question regarding declaration of the array? Does it make sense to put it outside the loop or it doesn't matter?
>>>>
>>>>I guess I need to re-read the Array chapter.
>>>
>>>What message ?
>>
>>The original question in this thread. I asked two questions there.
>>
>>I also think I need to add UpdateProgress to my page...
>
>Oh, this
>
> SqlParameter[] parameters = new SqlParameter[2];
>  parameters[0] = new SqlParameter("RegistrationID", RegID);
>  parameters[1] = new SqlParameter("PersonID", 0);
>
>
>The general idea is to create as less objects a possible
>
>If this is in a loop (SqlParameter[] parameters = new SqlParameter[2]), say n times, you will create n objects that will have to be collected
>
>So I would put
>
>SqlParameter[] parameters = new SqlParameter[2];
>
outside the loop
>
>
>As to, new SqlParameter(), you may try to resuse them, by setting their value - if at all possible

Ok, let me try that. The only problem I already approved all the people, I need to insert more records for my tests :)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform