Tuesday, 6 August 2013

Passing c# DataTable as a parameter to stored procedure in MS SQL Server 2008

Passing c# DataTable as a parameter to stored procedure in MS SQL Server 2008

I want to pass a DataDable to a stored procedure as parameter cointaing
the columns below:
1) Supp_Id int
2) Del_Methode_Id int
3) Ord_Ammount int
4) Promo_Id int
5) Discount_Ammount Money
Now I want to use this datatable in stored procedure and want to declare a
cursor on it. And use that cursor to insert values into the database table
sequentialy.
Please tell me how to declare datatable paramete**r in stored procedure
and then using **cursor on that parameter. Thanks in advance
please tell me how to do it so. thanks in advance.

No comments:

Post a Comment