HOW TO DISPLAY IMAGE FR DATABASE TO ADROTATE IN ASP.NET c#

Question

hey, brothers, can you all teach me how to display image from database (.mdf) to adRotate control... for my concept was using the ad Rotate as a banner for users to display their picture as advertisement.

the database that i created only
imageName - varchar
imageUP - image type

can all the talent show me how to do, can show the the data type also (database)..

I USING VB2008, ASP.NET C#
<THANK YOU>

Gai Ben Ben · Answer

First, i must thank you.. but i can't run it, because this error appear "The control with ID 'Timer1' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it." . is it like this?? private DataTable FetchAdsFromDB() { string sql = "select * from the database i 1 retrieve"; SqlDataAdapter da = new SqlDataAdapter(sql, db connection); DataTable dt = new DataTable(); da.Fill(dt); return dt; } no need create any database connection.. and what if my database contain many many pictures, and i 1 to let user to choose the picture that he already UpLoad??

Master Billa · Answer

Hi Add adrotator in your html code and write code like this way with timer tick to display image in interval just simple code snippet here private DataTable GetImages() { string sql = "select * from YourAdRotatorTableName"; SqlDataAdapter da = new SqlDataAdapter(sql, con); DataTable dt = new DataTable(); da.Fill(dt); return dt; } protected void Timer1_Tick(object sender, EventArgs e) { AdRotator1.DataSource = GetImages(); AdRotator1.DataBind(); } and more details here http://www.aspdotnetcodes.com/Asp.Net_AdRotator_Database.aspx thank you

Roei Bar · Answer

here is the code: private DataTable FetchAdsFromDB() { string sql = "select * from YourAdRotatorTableName"; SqlDataAdapter da = new SqlDataAdapter(sql, ); DataTable dt = new DataTable(); da.Fill(dt); return dt; } and the addrotator Timer event protected void Timer1_Tick(object sender, EventArgs e) { AdRotator1.DataSource = FetchAdsFromDB(); AdRotator1.DataBind(); } good luck, and if you like it, dont forget to"mark as accepted answer"

HOW TO DISPLAY IMAGE FR DATABASE TO ADROTATE IN ASP.NET c#

Answers (3)