如何通过传递数据执行存储过程？ [英] How to execute stored procedure with passing datatable?

问题描述

我想通过传递数据表来执行存储过程。



我知道如何传递简单参数并执行存储过程。



可以对此有所帮助，如何执行存储过程？

I want to execute the store procedure with passing datatable.

I know how to pass simple parameter and execute the stored procedure.

can some one help on this, How to execute the stored procedure?

推荐答案

一点点研究会找到你这些CP文章：



将数组或DataTable传递给存储过程 [ ^ ]



[ ^ ]



将DataTable发送到存储过程 [ ^ ]



C＃和表值参数 [ ^ ]

A little research would have found you these CP articles:

Passing an array or DataTable into a stored procedure[^]

Passing a datatable to a Stored Procedure in SQL Server 2008[^]

Sending a DataTable to a Stored Procedure[^]

C# and Table Value Parameters[^]

这篇关于如何通过传递数据执行存储过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！