Convert xml string to ADO recordset

[BC]

Hi all,

I'm looking for some c# examples how to convert xml string to ado
recordset. Im currently working on a project in asp.net (c#) that
requires to call a COM object (business object) which takes a recordset
as one of the arguments.


Thanks,

Benny

 

[Brett Romero]

Here's one method in VB.NET. This shouldn't give you much trouble in
converting it to c# http://support.microsoft.com/?kbid=309702

You can also use the XSD.EXE tool to generate a strongly typed dataset
object. This link gives you some good information about the process,
specifically the section titled, "Reading XML Data with DataSets" -
http://www.c-sharpcorner.com/Code/2002/Nov/ViewWriteXmlUsingDataSet.asp

If you want to throw the XML directly into an SQL Server, check the SQL
Server extension OpenXML. It accepts XML into a stored procedure.

Brett