Hi:
I'm wondering if there's a way for me to pass a DataTable
that is created within an asp.net page to a Stored Procedure
in SQL2005.
Specifically, I have a multi-select listbox for for user to
select a number of items that want to include for further
'processing.' Users can select anywhere from 1 to 500
items. What I want to do is to iterate through the list and
add each selected item as a row in a DataTable that is
created within the asp.net page, and then pass that table to
a stored procedure and use it as part of an inner join
statement with other tables.
I've seen an article from sqlcentral on passing a table as a
parameter using XML from one stored procedure to another,
but I have not seen anything that allows the passing of a
table parameter from asp.net page to a stored procedure.
I'm wondering if this could be done and, if so, how. . .
Thanks for your help!
Justin
Need SQL Advice? http://sqladvice.com
Need RegEx Advice? http://regexadvice.com
Need XML Advice? http://xmladvice.com
|
