VS2010 I am reading any existing params and I want to load them into a
ByRef params As StoredProcedureParameterCollection for use later.
As the code runs I get a null exception error and I cannot understand
why? p has values for use to param and param has values for params.
spF is a loaded StoredProcedure off of the "From" server. I have to
copy it's parts over to a SP off of the "To" server. This goes after
Params, and we have A LOT OF THEM!
For Each p As StoredProcedureParameter In spF.Parameters
Dim param As StoredProcedureParameter = New
StoredProcedureParameter(spF, p.Name, p.DataType)
params.Add(Add(param, cnt)) ' << Get a null exception here??
cnt = cnt + 1
Next
Anyone else done this? Please don't say buy red-gate. That door
slammed on my fingers day 1 here. :(
--
Stephen Russell
Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018
Telephone: 888.510.2667
901.246-0159 cell
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
