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
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