creating a xml ad file from a database source

ACE2084 · January 18th, 2005, 02:04 PM

hi, i have an adrotator webcontrol which i like to update its xml adfile from data stored in a sql database. how could i read this data from a dataset and build an advertisement file in its schema efficiently, i mean if is there any method that help me to do that instead of writing the adfile xml schema tag by tag. thanks....

Santhi · January 20th, 2005, 07:57 AM

DataSet have methods to create XML.Use that to create adfile.

Vadivel · January 21st, 2005, 01:56 AM

You might want to look into the following methods.

1. WriteXml
2. ReadXml
3. ReadXmlSchema
4. WriteXmlSchema

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

mehdi62b · January 21st, 2005, 04:53 AM

you can simply make your xml and it's schema,

Code:

objDataSet.WriteXml("C:\\...\\file.xml");//your XMLFile
objDataSet.WriteXmlSchema("C:\\...\\schema.xsd");//your Schema

if you encounter some errors about access control you should change the permissions and roles of your user where you make your result files.
(also you can write your result inside a temporary stream).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.

mehdi62b · January 21st, 2005, 05:53 AM

I meant from a temporary stream a MemoryStream,for not dealing with disk(not a Temp File).

_____________________________
Mehdi.
software engineering student.
Looking for a good job for summer 2005.