Alex Rivera | Logout

How to pass User Defined Table Type as Stored Procedured parameter in C#

Asked 2009-06-23T06:07:55.010
27

In SQL Server 2008, we can define a table type and use it as a stored procedures' parameter.

But how can I use it in C# invocation of this stored procedure? In other words, how to create a table or list and pass it into a stored procedure in C# code with this new feature of SQL Server 2008?

Edit
Report

1 Answer

2

The easiest way is by passing a DataTable as the parameter. Check out some examples here.

answered 2009-06-23T06:14:33.813

Your Answer