使用数据库制作图像幻灯片 [英] making an image slideshow using database

问题描述

大家好，

我需要使用数据库制作图片幻灯片

我有此表，该表将图像存储在数据库中

表[images]

标题
imagepath
imageurl

________________________

谢谢，
Ranya

hi all,

i need to make an image slideshow using database

i have this table which store images in database

table [ images]

title
imagepath
imageurl

________________________

thanks,
Ranya

推荐答案

使用Ajax工具套件控件执行此任务..

Hi,

Use Ajax Tool kit control for this task..

<div>
        <div>
             <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
             </asp:ToolkitScriptManager>
             <asp:Image ID="img1" runat="server"

             Height="400px" Width="400px"

             ImageUrl="~/Image/2Desert.jpg" />
        </div>
        <asp:SlideShowExtender ID="SlideShowExtender1" runat="server"

BehaviorID="SSBehaviorID"

            TargetControlID="img1"

            SlideShowServiceMethod="GetSlides"

            AutoPlay="true"

            ImageDescriptionLabelID="lblDesc"

            NextButtonID="btnNext"

            PreviousButtonID="btnPrev"

            PlayButtonID="btnPlay"

            PlayButtonText="Play"

            StopButtonText="Stop"

            Loop="true" >
        </asp:SlideShowExtender>
    </div>
    </td>
    </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td align="center" >
     <div>
            <asp:Label ID="lblDesc" runat="server" Text=""></asp:Label><br />
            <asp:Button ID="btnPrev" runat="server" Text="Previous" />
            <asp:Button ID="btnPlay" runat="server" Text="" />
            <asp:Button ID="btnNext" runat="server" Text="Next" />
        </div>
    </td>
    </tr>
    </table>
    </div>

***** C#代码

*****C# code

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    loadslide()

End Sub

Sub loadslide()

    con.ConnectionString = ConfigurationManager.ConnectionStrings("con").ConnectionString

    fselect = "select * from imgurl"

    sqlcmd = New SqlCommand(fselect, con)

    con.Open()

    sqladp = New SqlDataAdapter(sqlcmd)

    con.Close()

    dt1.Clear()

    sqladp.Fill(dt1)

End Sub

在这里，我使用datatable从数据库中添加了图像url.

幻灯片放映需要GetSlide方法提供的图像.添加

服务器端编码中的以下页面方法.

Here I added the images url form the database by using datatable.

Slide show require images it has supply from GetSlide method. Add

the below pagemethod in your serverside coding.

<system.web.services.webmethod(),>

       Public Shared Function GetSlides() As AjaxControlToolkit.Slide()

        Dim imgSlide As AjaxControlToolkit.Slide() = New AjaxControlToolkit.Slide(dt1.Rows.Count - 1) {}

        For i As Integer = 0 To dt1.Rows.Count - 1

            Dim dr As DataRow = dt1.Rows(i)

            imgSlide(i) = New AjaxControlToolkit.Slide(Replace(dr("ImageURL").ToString(), "~/", ""), "", "")

        Next

        Return (imgSlide)

    End Function

问候，

Sucharitha

我希望这对你很高兴

Regards,

Sucharitha

I hope this one hepfull to u

这篇关于使用数据库制作图像幻灯片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！