Retrieve an XML stream from my business class

[Grant Merwitz]

I am trying to write an XML file from my database.

Currently, i have this code on an ASPX page, but have also built a business
layer that manages all the DataRetrieval and is reference in my main ASP.NET
project.
I would like to retrieve either a stream/XmlTextWriter from the Business
layer, that i can just retrieve and write from the front end,

Whats the best method to do this?
Any advice would be greatly appreciated

Currenlty, i am writing the code directly on the page as follows:
(obviously bogus data here, as i'm just getting it to work before i use real
data - also, this is in a control, hence Page.Response)

Page.Response.C lear();

Page.Response.C ontentType = "text/xml";

XmlTextWriter xr = new XmlTextWriter(P age.Response.Ou tputStream,
System.Text.Enc oding.UTF8);

//Write opening elements

xr.WriteStartDo cument();

xr.WriteStartEl ement("rss");

xr.WriteAttribu teString("versi on","2.0");

xr.WriteStartEl ement("channel" );

xr.WriteElement String("title", "Workshare Corporate Blog");

xr.WriteElement String("link", "http://www.workshare.c om/company/blog");

xr.WriteElement String("descrip tion", "Latest news from Workshare.COM") ;

xr.WriteElement String("copyrig ht", "(c) Workshare.com") ;

xr.WriteElement String("ttl","5 ");

//Write the articles

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title1");

xr.WriteElement String("descrip tion","this is title 1");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title2");

xr.WriteElement String("descrip tion","this is title 2");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

//Close the opening elements

xr.WriteEndElem ent();

xr.WriteEndElem ent();

xr.WriteEndDocu ment();

xr.Flush();

xr.Close();

Page.Response.E nd();

[Grant Merwitz]

Got it, just posting up so no one has to worry
I chagned my method to be a return type of String

Them wrote the XmlTextReader directly to a memorystream,
Then using the StreamReader, wrote the to a string.

I'm happy now :)

"Grant Merwitz" <gr***@workshar e.com> wrote in message
news:eQ******** ******@tk2msftn gp13.phx.gbl...

I am trying to write an XML file from my database.

Currently, i have this code on an ASPX page, but have also built a
business layer that manages all the DataRetrieval and is reference in my
main ASP.NET project.
I would like to retrieve either a stream/XmlTextWriter from the Business
layer, that i can just retrieve and write from the front end,

Whats the best method to do this?
Any advice would be greatly appreciated

Currenlty, i am writing the code directly on the page as follows:
(obviously bogus data here, as i'm just getting it to work before i use
real data - also, this is in a control, hence Page.Response)

Page.Response.C lear();

Page.Response.C ontentType = "text/xml";

XmlTextWriter xr = new XmlTextWriter(P age.Response.Ou tputStream,
System.Text.Enc oding.UTF8);

//Write opening elements

xr.WriteStartDo cument();

xr.WriteStartEl ement("rss");

xr.WriteAttribu teString("versi on","2.0");

xr.WriteStartEl ement("channel" );

xr.WriteElement String("title", "Workshare Corporate Blog");

xr.WriteElement String("link", "http://www.workshare.c om/company/blog");

xr.WriteElement String("descrip tion", "Latest news from Workshare.COM") ;

xr.WriteElement String("copyrig ht", "(c) Workshare.com") ;

xr.WriteElement String("ttl","5 ");

//Write the articles

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title1");

xr.WriteElement String("descrip tion","this is title 1");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title2");

xr.WriteElement String("descrip tion","this is title 2");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

//Close the opening elements

xr.WriteEndElem ent();

xr.WriteEndElem ent();

xr.WriteEndDocu ment();

xr.Flush();

xr.Close();

Page.Response.E nd();

[Grant Merwitz]

Got it, just posting up so no one has to worry
I chagned my method to be a return type of String

Them wrote the XmlTextReader directly to a memorystream,
Then using the StreamReader, wrote the to a string.

I'm happy now :)

"Grant Merwitz" <gr***@workshar e.com> wrote in message
news:eQ******** ******@tk2msftn gp13.phx.gbl...

I am trying to write an XML file from my database.

Currently, i have this code on an ASPX page, but have also built a
business layer that manages all the DataRetrieval and is reference in my
main ASP.NET project.
I would like to retrieve either a stream/XmlTextWriter from the Business
layer, that i can just retrieve and write from the front end,

Whats the best method to do this?
Any advice would be greatly appreciated

Currenlty, i am writing the code directly on the page as follows:
(obviously bogus data here, as i'm just getting it to work before i use
real data - also, this is in a control, hence Page.Response)

Page.Response.C lear();

Page.Response.C ontentType = "text/xml";

XmlTextWriter xr = new XmlTextWriter(P age.Response.Ou tputStream,
System.Text.Enc oding.UTF8);

//Write opening elements

xr.WriteStartDo cument();

xr.WriteStartEl ement("rss");

xr.WriteAttribu teString("versi on","2.0");

xr.WriteStartEl ement("channel" );

xr.WriteElement String("title", "Workshare Corporate Blog");

xr.WriteElement String("link", "http://www.workshare.c om/company/blog");

xr.WriteElement String("descrip tion", "Latest news from Workshare.COM") ;

xr.WriteElement String("copyrig ht", "(c) Workshare.com") ;

xr.WriteElement String("ttl","5 ");

//Write the articles

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title1");

xr.WriteElement String("descrip tion","this is title 1");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

xr.WriteStartEl ement("item");

xr.WriteElement String("title", "title2");

xr.WriteElement String("descrip tion","this is title 2");

xr.WriteElement String("link"," http://www.workshare.c om");

xr.WriteElement String("pubDate ", DateTime.Now.To String());

xr.WriteEndElem ent();

//Close the opening elements

xr.WriteEndElem ent();

xr.WriteEndElem ent();

xr.WriteEndDocu ment();

xr.Flush();

xr.Close();

Page.Response.E nd();