Are you sure you meant the inner Add() function? params.Add(*Add*(param, cnt))
Because I guess that function returns a null. On 1 June 2011 17:31, Stephen Russell <[email protected]> wrote: > 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 > -- 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
