Equivalent to Command.Parameters.Refresh

Ray · Aug 13, 2003

Hi,
Does anyone know what is the equivalent of Refresh method
in VB6 for ado.net command object.
Thanks in advance,
Ray

Carl Prothman [MVP] · Aug 13, 2003

Ray said:
Does anyone know what is the equivalent of Refresh method
in VB6 for ado.net command object.
Thanks in advance,

Ray,
You can either use the SqlCommandBuilder.DeriveParameters method
http://msdn.microsoft.com/library/e...lCommandBuilderClassDeriveParametersTopic.asp

Or you can call sp_help and create the parameters using custom code.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com