You can convert the DataTable's contents to XML, send the XML to the stored procedure in a Text or nText parameter, and parse the XML using OPENXML() in your stored procedure.
-Mike
>To All,
>
>I have a DataTable (in a DataSet) that I need to send to a stored procedure in SQL Server 2000 and wondered how to do that. I can't send it back row by row because the entire set of data needs to be parsed to actually perform the update to the related tables. How can I send the whole set of data? To create parameters would be enormous and seemingly inefficient. Any ideas??