Lets assume that on the front page of my club website I want to have an adrotator that rotates through the different pictures that appear in the Photos section.

From what I understand, the adrotator will get its information from either an xml file, or from a table that follows a particular schema.

I have created a table in my SQL Server database to hold the information, according to specifications, but do not know how to set the ImageUrl field, since the image is in the images table and not physically on the server's file system.

 Any suggestion will be appreciated!

I have solved the problem:

I created this table as my DataSource: Works well! Let me know if it helps you too!

Great!

It works!

WOW! I had forgotten that I had posted my solution.

I am glad it helped somebody else too!

Hi,

I hope you can help me im using the club starter kit which is working really good but i just need to add one little function to it.  The photo section you can use the next button or the previous button to see the images, i want to add another button so it will play all the images in that abum like a slide show, so you dont have to keep pressing the button, can anyone help me please...

Dips
 

Hi dips:

 By coincidence, yesterday I was afters something very similar to what you want, and I found this codeproject contribution, that does what you want:

 http://www.codeproject.com/aspnet/CatalogViewPhotoGallery.asp

dear DBS253

will you please post the complete solution how u have connected with front end asp.net

also will u pls post me the sample data thru select command as am struggling to insert data

just show me the data thru "select * from AdRotatorData"

thanx a lot

samir

<asp:SqlDataSource ID="SqlDataRotator" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"

SelectCommand="SELECT ImageUrl, NavigateUrl, AlternateText, Keyword, Impressions, Width, Height, imageid FROM vwAdRotatorData">

</asp:SqlDataSource>

dear dabas

thanx for your reply but with this table script am unable to understood the following as till now am managing with XML this adrotator but its very difficult to modify for new ads hence am trying to convert my project with database.

pls clear me the doubts for the following 3 lines

1) for ImageUrl and NavigateUrl what will be data type. Here your data type I have not understood

2) also have noticed that u have assigned one imageid and referring into ImageUrl n NavigateUrl.

Please help me the following 2

<ImageUrl>1.JPG</ImageUrl>

<NavigateUrl>http://www.microsoft.com</NavigateUrl>