Converting dataset xml into adodb.recordset ???

Ed Staffin

Hi, I have a need to conver the xml produced by a .net
dataset (with a single table) into an adodb.recordset . The
adodb.recordset doesn't understand the xml that the
dataset.GetXml method produces. Can someone point me in
the right direction?
Thanks ... Ed

Nov 12 '05 #1

Subscribe Reply

4923

Teemu Keiski

Hi,

see the code download for Dino Esposito's "Applied XML Programming for
Microsoft .NET"
http://www.microsoft.com/MSPress/books/6235.asp . In chapter 4 there is
written as an example an XmlRecordsetWri ter class (custom XML writer) which
is capable to write ADO recordset compliant XML. It has WriteRecordset
method which can take a DataSet, DataTable or DataView and write it as
Recordset.

Hope this helps.

--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke

"Ed Staffin" <an*******@disc ussions.microso ft.com> wrote in message
news:1a******** *************** ******@phx.gbl. ..
Hi, I have a need to conver the xml produced by a .net
dataset (with a single table) into an adodb.recordset . The
adodb.recordset doesn't understand the xml that the
dataset.GetXml method produces. Can someone point me in
the right direction?
Thanks ... Ed

Nov 12 '05 #2

MFREIDGE

I found some code here: http://www.
xmlwebservices. cc/index_Samples.h tm to convert Dataset into an ADO
recordset on client VB6/Access VBA
-
MFREIDG
-----------------------------------------------------------------------
Posted via http://www.mcse.m
-----------------------------------------------------------------------
View this thread: http://www.mcse.ms/message549541.htm

Nov 12 '05 #3

Similar topics

9300

Classic ASP to .NET WebService interfacing (Dataset to RecordSet)

by: Adam Short | last post by:

I am trying to write a routine that will connect a .NET server with a classic ASP server. I know the following code doesn't work! The data is being returned as a dataset, however ASP does not recognise datasets and requires a recordset. Can the datatypes be converted? At the Classic ASP end or .NET end? Can SOAP toolkit provide the...

ASP / Active Server Pages

1248

Converting From ADO.Net XML to ADO problem

by: Ed Anady | last post by:

Using the method described in Microsofts Knowledge Base article http://support.microsoft.com/default.aspx?scid=kb;en-us;316337 to convert an XML file created by a DataSet into an XML file read by ADO. This seems pretty straight forward and the ADO recordset *opens* without error, however it's quite empty. Any attempt to use it (e.g....

.NET Framework

10236

convert recordset to dataset

by: Thaddeus | last post by:

//Author: //Thaddeus Jacobs, MCP //Kinematic Automation, Inc. //mailto:tjacobs@kinematic.com // //Description: //convert ADO .NET dataset to ADO 2.5 2.6 2.7 recordset and v/v //DataSet to recordset conversion. //Get RecordSet from Dataset //ds2rs DataSet2RecordSet

C# / C Sharp

3410

Converting Dataset to Recordset

by: Marathoner | last post by:

I have read Bill Vaughn's paper on this subject and I have one stumbling block. Bill wrote his demo in VB.NET. He converts a DataTable to an XML file. In VB.NET, he dimmed a recordset and used this syntax: rs.Open(sPathToXMLfile) When incorporating his code in my C# app, the ADODB.Recordset Open method takes 5 arguments, all required. ...

C# / C Sharp

13611

Convert Dataset to Recordset in C#

by: Marathoner | last post by:

I am trying to convert a dataset to an ADODB.Recordset. I create the sxl file and open it in VB.NET by using: Dim rs as ADODB.Recordset rs.Open("C:\files\xslfile.xsl") I want to do this same thing in C#. The open method in C# takes several additional parameters in addition to the xsl file: rs.Open("C:\files\xslfile.xsl", object...

C# / C Sharp

2596

COM Interoperability - Object type to Dataset

by: Prasad | last post by:

Hi I have a legacy DLL, that has functions which accept and return type "Variant" I want to use that DLL in .NET. I am able to use functions well that return variants but that return common data types like string, int etc There is one function that has a return type variant, but actually returns a recordset the return type of variant in...

ASP.NET

4437

Converting Recordset to DataView

by: kjvt | last post by:

Based on a prior posting, I've written a function to convert a recordset to a dataview. The first call to the function for a given recordset works perfectly, but the second call always returns a dataview with a count = 0. Can someone explain why and how I might work around this problem? Here is the code for my function: Public Shared...

Visual Basic .NET

10810

Filling a DataSet with an ADO Recordset or Record

by: James | last post by:

I am writing a web service for a classic ASP application. I need to consume an ADO recordset and then send it to another web service for processing. I found an MSDN ariticle telling how to do this (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconfillingdatasetwithadorecordset.asp), one big problem - it says...

C# / C Sharp

7700

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7614

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7924

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7974

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5513

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3653

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3642

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1221

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

938

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General