C# SQL server 2000 xml question

padlad · 03-08-2006 1:29am #1

I have a simple sql server 2000 table and I want to pull the info out of it into a c# webservice app so it can pass back the results to the calling client.

I was hoping to use XmlDocument to store the xml results and pass that back to the client.

Has anyone constructed an xmldocument object using a sql query or does anyone have any ideas, as everything I try doesn't appear to work too well

Cheers

bonkey · 03-08-2006 7:16am

http://www.c-sharpcorner.com/Code/2002/Nov/ViewWriteXmlUsingDataSet.asp

Smoggy · 03-08-2006 8:46am

As you pull the data out fo sql server you store it in a Dataset, the Dataset object has a method for converting to xml (GetXml). Alternatly the better method would be to return the data from sql server to ur calling client as xml, I think for that you use "FOR XML EXPLICIT", but you would have to read about that.

Evil Phil · 03-08-2006 11:29am

Afiak you can return a dataset through the webservice e.g.

[Webmethod]
public DataSet foo()
{
    // does something
    return dataset;
}

Visual Studio/.Net framework will convert it to XML for you just like the GetXml() method. This may only be version 2 though.

<edit>
Yep, you can. .Net will serialise the dataset to xml for you - however the consumer may not recognise the schema used.

C# SQL server 2000 xml question

Comments