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

Gai Ben Ben

17y6.3k.NET

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#

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gai Ben Ben17y ago
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 Billa17y ago
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 Bar17y ago

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"