October 7, 2011 at 7:17 am
Hi,
I want to know how can I use the Table Valued Parameters when I am passing a datatable from ASP.NET web page so I need an example to demonstrate - C# code and SQL Stored Procedure.
Please help.
Thanks.
October 7, 2011 at 7:41 am
This help? http://msdn.microsoft.com/en-us/library/bb675163.aspx
Explains the process and shows C# code.
October 7, 2011 at 7:41 am
Oddly enough I happen to have an example of exactly what you are looking for. I think it was Gus who suggested that I should write up an article on this very topic. Thanks for reminding to give that some serious thought. This topic comes up from time to time on here. Hope this helps.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply