dynamicaly change ADs in ADRotator 1

[thehms]

hi all...

i am using an ADRotator control, what i want to do is to load the ads from an SQL 2000 DB. i have a table called 'ADs' and fields with all the attributes in the Ads XML file (ie. ImageUrl, NavigateUrl, AlternateText, Keyword, impressions).

i thought of 2 things that i could do:

1- let SQL Server export an XML file every, say, 24 hours with the format thats needed by the ADRotator.

2- load the table data and build it into a string and format the XML file in ASP.NET and write the output to the xml file.

i looked for the 1st one but i couldnt find it, and i used FOR XML AUTO clause in my select query, but the reesult is not formatted as i want it.

and for the second i dont know if it ispossible to write to a file in ASP.NET or not...

please help me out as to which approach is better (or if u have a 3rd one that even better) and as to how i can do it....

Thanx,
The HMS

 

[ca8msm]

Have you tried loading the data into a dataset? If not then it may be worth trying as DataSet's have a WriteXml property that allows to to save the results as an XML file.

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[thehms]

thank you ca8msm

it worked the way i want it exactly

The HMS