Select data from database and display it as xml format in aspx page

[newtodotnet1]

Hi all,

I retrieved data from database and i want to display the retrieved data in xml format in aspx page using asp.net and c#.net...

Please get me the code.. i am using asp.net and c#.net


I want to use WebClient....

Thanks and Regards,

NewToDotNet..

[Plater]

Do you have an XML schema created?

Although you could jsut use the built in functionality of DataTables and do .WriteXML() and use a stream object (possibly the response stream?) and write out your data.

[nateraaaa]

Hi all,

I retrieved data from database and i want to display the retrieved data in xml format in aspx page using asp.net and c#.net...

Please get me the code.. i am using asp.net and c#.net


I want to use WebClient....

Thanks and Regards,

NewToDotNet..

I don't really understand what you are wanting to do. Are you wanting to use a web service to return the data from the database and pass the data back to your website via a XML web service response? Or are you trying to retrieve the data from a database fill a dataset and use the dataset and show the data as XML nodes on your web page?

Nathan

[newtodotnet1]

I don't really understand what you are wanting to do. Are you wanting to use a web service to return the data from the database and pass the data back to your website via a XML web service response? Or are you trying to retrieve the data from a database fill a dataset and use the dataset and show the data as XML nodes on your web page?

Nathan

Hi Nathan,

I am trying to retrieve the data from a database fill a dataset and use the dataset and show the data as XML nodes on a web page.

I need to use WebClient in my code...

Please help me...

Thanks..

[Plater]

Then I say again:
Use the .WriteXML() function and supply your own stream for it.

[newtodotnet1]

Then I say again:
Use the .WriteXML() function and supply your own stream for it.

Hi Plator,

I dont know how to use WriteXML.() .. Please help me.. I am new in .net and please get me the source code for my requirement,,,

Thanks..

[Plater]

Check MSDN, it's good.

Quick and dirty:

myDataTable.WriteXML(Response.OutputStream);
Response.End();
 

But you could always populate a different stream, and properly set all the response headers (length, content type) and then feed that stream to the output stream.

[newtodotnet1]

Check MSDN, it's good.

Quick and dirty:

myDataTable.WriteXML(Response.OutputStream);
Response.End();
 

But you could always populate a different stream, and properly set all the response headers (length, content type) and then feed that stream to the output stream.

Hi,
Can yu get me the url in msdn??


Thanks...

[Plater]

You make me bang my head on the desk.

http://www.msdn.com/

[nateraaaa]

You make me bang my head on the desk.

http://www.msdn.com/

Don't hurt yourself Plater. We need you around here.

Nathan

[newtodotnet1]

Don't hurt yourself Plater. We need you around here.

Nathan

Hi everybody,

I am trying to retrieve the data from a database fill a dataset and use the dataset and show the data as XML nodes on a web page.

Please get me the code...

Thanks,.....

[nateraaaa]

Hi everybody,

I am trying to retrieve the data from a database fill a dataset and use the dataset and show the data as XML nodes on a web page.

Please get me the code...

Thanks,.....

Try this site:
http://aspnet.4guysfromrolla.com/articles/071702-1.aspx
In the future when we make a suggestion for the code you need to implement (for example dataset.WriteXML) please search google for the code.

thanks
Nathan