Hi,
I need to pass a recordset to a stored Procedure.
Basically I'm retriving a set or records from a third-party application using API calls. I stored the returned set in a datatable. Now what I need to do is to pass these values to a stored Procedure , do some processing and then return the results back.
One way to do this is to pass the datatable as an XML document to SQL Server SP and have the SP create the table from the XML doc. The problem with this is that the XML I'm getting from the third-party app is kinda tricky and not very clean. Its element centric and their naming conventions is wierd.
What other options do I have to pass a set of records to SQL Server using ADO.Net and VB.
Thanks
I need to pass a recordset to a stored Procedure.
Basically I'm retriving a set or records from a third-party application using API calls. I stored the returned set in a datatable. Now what I need to do is to pass these values to a stored Procedure , do some processing and then return the results back.
One way to do this is to pass the datatable as an XML document to SQL Server SP and have the SP create the table from the XML doc. The problem with this is that the XML I'm getting from the third-party app is kinda tricky and not very clean. Its element centric and their naming conventions is wierd.
What other options do I have to pass a set of records to SQL Server using ADO.Net and VB.
Thanks