WebMethod, XmlDocument and CreateProcessin gInstruction

[Lars Moastuen]

I'm currently writing a webservice. I've successfully written a
service that gives me some XML data, but now I want to link a
XLS-stylesheet to that data. The way I'm trying to do that is to
create a webmethod that returns a XmlDataDocument , and use
CreateProcessin gInstruction() to add a "stylesheet-header"... Problem
is that the headers I add using CreateProcessin gInstruction() seems to
be removed (?) when the data is transferred over the web. When I use
XmlDocument.Sav e() the output is fine... What causes this? Is there
any workaround?

The optimal solution would allow me to return a ADO.NET DataSet, and
still link an XLS-datasheet to the document. Reason is that I'm
intending to use the service with crystal reports through the ADO.NET
driver (doesn't recognize methods not returning DataSet). Is there a
way?

My method is as follows:
[WebMethod]
public XmlDataDocument test()
{
Basin tree = db.GetBasinTree ();

DataSet ds = new DataSet();
ds.EnforceConst raints = false;
DataTable tb = ds.Tables.Add(" basin");
tb.Columns.Add( "basinid", typeof(Decimal) );
tb.Columns.Add( "basinname" , typeof(String)) ;
tb.Columns.Add( "parent", typeof(Decimal) );
tb.Columns.Add( "haschildre n", typeof(bool));
AddBasinChildre n(tb, tree);

XmlDataDocument xmlDoc = new XmlDataDocument (ds);
String stylesheet = "type=\"tex t/xsl\" href=\"test.xsl \"";
XmlProcessingIn struction xlsNode =
xmlDoc.CreatePr ocessingInstruc tion("xml-stylesheet", stylesheet);
xmlDoc.InsertBe fore(xlsNode, xmlDoc.Document Element);
xmlDoc.Save("c: \\temp\\thiswor ks.xml");

return xmlDoc;
}

Help appreciated!
Lars Moastuen
GeoKnowledge

[David Davies]

I am trying to do an identical thing

Did you ever find the solution ?

David Davies,
Goldman Sachs

"Lars Moastuen" wrote:

I'm currently writing a webservice. I've successfully written a
service that gives me some XML data, but now I want to link a
XLS-stylesheet to that data. The way I'm trying to do that is to
create a webmethod that returns a XmlDataDocument , and use
CreateProcessin gInstruction() to add a "stylesheet-header"... Problem
is that the headers I add using CreateProcessin gInstruction() seems to
be removed (?) when the data is transferred over the web. When I use
XmlDocument.Sav e() the output is fine... What causes this? Is there
any workaround?

The optimal solution would allow me to return a ADO.NET DataSet, and
still link an XLS-datasheet to the document. Reason is that I'm
intending to use the service with crystal reports through the ADO.NET
driver (doesn't recognize methods not returning DataSet). Is there a
way?

My method is as follows:
[WebMethod]
public XmlDataDocument test()
{
Basin tree = db.GetBasinTree ();

DataSet ds = new DataSet();
ds.EnforceConst raints = false;
DataTable tb = ds.Tables.Add(" basin");
tb.Columns.Add( "basinid", typeof(Decimal) );
tb.Columns.Add( "basinname" , typeof(String)) ;
tb.Columns.Add( "parent", typeof(Decimal) );
tb.Columns.Add( "haschildre n", typeof(bool));
AddBasinChildre n(tb, tree);

XmlDataDocument xmlDoc = new XmlDataDocument (ds);
String stylesheet = "type=\"tex t/xsl\" href=\"test.xsl \"";
XmlProcessingIn struction xlsNode =
xmlDoc.CreatePr ocessingInstruc tion("xml-stylesheet", stylesheet);
xmlDoc.InsertBe fore(xlsNode, xmlDoc.Document Element);
xmlDoc.Save("c: \\temp\\thiswor ks.xml");

return xmlDoc;
}

Help appreciated!
Lars Moastuen
GeoKnowledge

[David Davies]

Trying a cross post to
microsoft.publi c.dotnet.framew ork.webservices

"David Davies" wrote:

I am trying to do an identical thing

Did you ever find the solution ?

David Davies,
Goldman Sachs

"Lars Moastuen" wrote:

I'm currently writing a webservice. I've successfully written a
service that gives me some XML data, but now I want to link a
XLS-stylesheet to that data. The way I'm trying to do that is to
create a webmethod that returns a XmlDataDocument , and use
CreateProcessin gInstruction() to add a "stylesheet-header"... Problem
is that the headers I add using CreateProcessin gInstruction() seems to
be removed (?) when the data is transferred over the web. When I use
XmlDocument.Sav e() the output is fine... What causes this? Is there
any workaround?

The optimal solution would allow me to return a ADO.NET DataSet, and
still link an XLS-datasheet to the document. Reason is that I'm
intending to use the service with crystal reports through the ADO.NET
driver (doesn't recognize methods not returning DataSet). Is there a
way?

My method is as follows:
[WebMethod]
public XmlDataDocument test()
{
Basin tree = db.GetBasinTree ();

DataSet ds = new DataSet();
ds.EnforceConst raints = false;
DataTable tb = ds.Tables.Add(" basin");
tb.Columns.Add( "basinid", typeof(Decimal) );
tb.Columns.Add( "basinname" , typeof(String)) ;
tb.Columns.Add( "parent", typeof(Decimal) );
tb.Columns.Add( "haschildre n", typeof(bool));
AddBasinChildre n(tb, tree);

XmlDataDocument xmlDoc = new XmlDataDocument (ds);
String stylesheet = "type=\"tex t/xsl\" href=\"test.xsl \"";
XmlProcessingIn struction xlsNode =
xmlDoc.CreatePr ocessingInstruc tion("xml-stylesheet", stylesheet);
xmlDoc.InsertBe fore(xlsNode, xmlDoc.Document Element);
xmlDoc.Save("c: \\temp\\thiswor ks.xml");

return xmlDoc;
}

Help appreciated!
Lars Moastuen
GeoKnowledge

[David Davies]

Try Cross posting to dotnet.framewor k.webservices

"David Davies" wrote:

I am trying to do an identical thing

Did you ever find the solution ?

David Davies,
Goldman Sachs

"Lars Moastuen" wrote:

I'm currently writing a webservice. I've successfully written a
service that gives me some XML data, but now I want to link a
XLS-stylesheet to that data. The way I'm trying to do that is to
create a webmethod that returns a XmlDataDocument , and use
CreateProcessin gInstruction() to add a "stylesheet-header"... Problem
is that the headers I add using CreateProcessin gInstruction() seems to
be removed (?) when the data is transferred over the web. When I use
XmlDocument.Sav e() the output is fine... What causes this? Is there
any workaround?

The optimal solution would allow me to return a ADO.NET DataSet, and
still link an XLS-datasheet to the document. Reason is that I'm
intending to use the service with crystal reports through the ADO.NET
driver (doesn't recognize methods not returning DataSet). Is there a
way?

My method is as follows:
[WebMethod]
public XmlDataDocument test()
{
Basin tree = db.GetBasinTree ();

DataSet ds = new DataSet();
ds.EnforceConst raints = false;
DataTable tb = ds.Tables.Add(" basin");
tb.Columns.Add( "basinid", typeof(Decimal) );
tb.Columns.Add( "basinname" , typeof(String)) ;
tb.Columns.Add( "parent", typeof(Decimal) );
tb.Columns.Add( "haschildre n", typeof(bool));
AddBasinChildre n(tb, tree);

XmlDataDocument xmlDoc = new XmlDataDocument (ds);
String stylesheet = "type=\"tex t/xsl\" href=\"test.xsl \"";
XmlProcessingIn struction xlsNode =
xmlDoc.CreatePr ocessingInstruc tion("xml-stylesheet", stylesheet);
xmlDoc.InsertBe fore(xlsNode, xmlDoc.Document Element);
xmlDoc.Save("c: \\temp\\thiswor ks.xml");

return xmlDoc;
}

Help appreciated!
Lars Moastuen
GeoKnowledge