Stored Procedure With User-Defined Table Type

Joe Tannouri asked on June 2, 2017 12:32

How can I call a stored procedure in custom code that have a parameter type as User-Defined Table Type? I can't figure out how to assign the TypeName to the DataParameter item. I'm using V8.1.

Recent Answers

Peter Mogilnitski answered on June 2, 2017 14:15

How to pass table value parameters to stored procedure from .net code

0 votesVote for this answer Mark as a Correct answer

Joe Tannouri answered on June 2, 2017 14:37

Thank you Peter M for the reply, but you can't add the TypeName to the DataParameter of the DataQuery object, or am I missing something here?

1 votesVote for this answer Mark as a Correct answer