Look into SQLXML. SQLXML allows you to retrieve and update multiple records of data by sending XML back and forth.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp