Hi
i have a collection of parameters that i prepared and i want to send all of to my command how?

thanks in advance.

Hi seco,

Check the followingthread for help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1959607&SiteID=1

Also, Microsoft has provide a Enterprise Library Data Access Application Block that implement common data access functionality. Check this page on MSDN

Hope thie helps.

Regards

Hi seco,

I am not quite following what you want. To add parameters to a command, we can useDbCommand.Parameters.AddRange method.

Hope this helps.

Regards

thanks for reply
i can't instantiate an instance of DbparameterCollection !!!

i want to send all of the parameters as a parameter to my sub like

Private Sub mysub(myparameter as DbParameterCollection)
'add my parameters to the command
end sub


thanks.

Hi seco,

Check the followingthread for help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1959607&SiteID=1

Also, Microsoft has provide a Enterprise Library Data Access Application Block that implement common data access functionality. Check this page on MSDN

Hope thie helps.

Regards