Object of SQLParameterCollection

[vicks]

SQLParameterCollection's constructor is private - so cannot directly write as -

Dim objSQLParameterCollection as New SQLParameterCollection

If you cannot instantiate object, then how does SQLCommand object create SQLParameterCollection object?
(It returns SQLParameterCollection object with Parameters property)

 

[TechGnome]

You don't create the collection.... you create the parameters, and add them to the Parameters collection of the Command object.

This has some examples on how it's done:
http://www.developerkb.com/modules/wfsection/article.php?articleid=58


-tg

 

[vicks]

That's perfectly alright. I was curious about SQLCommand class.

How does SQLCommand create object of SQLParameterCollection internally ? (that was my question...)
Does it have special permissions (or whatever...) ?

 

[TechGnome]

Basicaly, in a nutshell... yes... the class is essentialy a non-creatable class... a shared class .... static in C terms. It actualy isn't a collection as much as it is a helper class of sorts to basicaly make it easier for you to manipulate the parameters. Internaly there probably is a collection, but it's proly just that a colection. The SQLParameterCollection class is you interface to it.

-tg