How I can generate XML files form the database for using it as the source XML of Adrotator ??

you can simply generate your xml and it's schema
----
objDataSet.WriteXml("C:\\...\\file.xml");
objDataSet.WriteXmlSchema("C:\\...\\schema.xsd");
----
if you encounter some errors about access control you should change the permissions and roles of your user(ASP.NET Machine Account) in that special directory.

--------------------------------------------
Mehdi.