Yes, naturally, but how do I get JQuery to have the datasource as its input?


Paolo

-----Original Message-----
From: jquery-en@googlegroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of aschmid
Sent: Monday, December 08, 2008 12:43 PM
To: jQuery (English)
Subject: [jQuery] Re: SlideShow based on SQL Server


You could use the asp.net repeater and sqldatasource to create the
above div from an sql server

for ex

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="ds">
 <HeaderTemplate><div class="pics"></HeaderTemplate>
 <ItemTemplate><img src='<%# Eval("imgUrl")%>' width='<%# Eval
("imgWidth")%>' height='<%# Eval("imgHeight")%>' />
 <FooterTemplate></div></FooterTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="ds" runat="server" ConnectionString="<%$
ConnectionStrings:YourConnectionString %>"
 ProviderName="System.Data.SqlClient" SelectCommand="select * from
images" ></asp:SqlDataSource>

On Dec 8, 8:43 am, Paolo Pignatelli <[EMAIL PROTECTED]> wrote:
> Thank you very much, this looks like a great slide-show.
>
> I do not see, however, in the cycle plug-in how to get the images
generated
> come from a SQL Server.  All the examples seem to rely on the images being
> in a div explicitly.
>
> <div class="pics">
>     <img src="images/beach1.jpg" width="200" height="200" />
>     <img src="images/beach2.jpg" width="200" height="200" />
>     <img src="images/beach3.jpg" width="200" height="200" />
> </div>
>
> I would like that exact same information to come from a column in a SQL
> Server database (perhaps minus the width and height).  I am using Visual
> Studio 2008, and would be delighted if there were a way to use either Linq
> or any other Asp.Net technology to be able to feed the slideshow, or
jQuery
> in general.  
>
> Thank you again,
>
> Paolo  
>
> -----Original Message-----
> From: jquery-en@googlegroups.com [mailto:[EMAIL PROTECTED] On
>
> Behalf Of aschmid
> Sent: Sunday, December 07, 2008 12:34 PM
> To: jQuery (English)
> Subject: [jQuery] Re: SlideShow based on SQL Server
>
> Paolo,
>
> I personally use the cycle plugin for slideshows, and it's worked
> nicely so far.
>
> If you don't want to use a server side repeater to build your list of
> images and would prefer to do it client side, I would use a technique
> like the one in this article
>
> http://encosia.com/2008/06/26/use-jquery-and-aspnet-ajax-to-build-a-c...
> ide-repeater/
>
> Andrew
>
> On Dec 7, 9:32 am, PaoloTCS <[EMAIL PROTECTED]> wrote:
> > I am brand new to JQuery, but very excited over it.  I have looked at
> > s3Slider and similar packeges, but they all seem to get their images
> > statically, either by referencing a folder or by just referring to
> > them ("1.jpg, 2.jpg, .... ").   I have a database with image paths
> > (images/woof1.jpg), for example.  How do I use JQuery with an asp.net
> > technology, like Linq, or even a Web Service to be able to "feed" a
> > slideshow, or anything similar?
>
> > Thanks to all,
>
> > Paolo
>
>

Reply via email to