How can retrive images frim database in Adrotator

Question

Hai I am having a problem. How can i retrive images from Sqlserver2005 database and how it will display in Adrotator control? I am expecting the  if any one refreshing the page the image should be change? How?

Lalit M · Answer

You can use this code sample fatch image from data base. private DataTable FetchAdsFromDB() { string sql = select * from YourAdRotatorTableName; SqlDataAdapter da = new SqlDataAdapter(sql ); DataTable dt = new DataTable(); da.Fill(dt); return dt; } more details show this article Here articles of how to use Adrotator hope this help...U