从数据库中幻灯片显示多个图像 [英] Slideshow multiple images from database
问题描述
我想使用slideshowextender控件从数据库中幻灯片显示四张图片。我是初学者,不知道如何开始。请告诉我如何实现这个。
谢谢。
I want to slideshow of four images from database using slideshowextender control. I am beginner and don't know how to begin with. Please tell me how can I implement this.
Thanks.
推荐答案
在这里你去
ASP.NET AJAX SlideShow Extender - 一些常见技巧和窍门 [ ^ ]
<asp:ScriptManager ID="ScriptManger1" runat="Server">
</asp:ScriptManager>
<div>
<asp:Timer runat="server" Interval="10000" ID="SlideShowTimer" OnTick="SlideShowTimer_Tick" />
<asp:UpdatePanel runat="server" ID="SlideShow" UpdateMode="Conditional">
<ContentTemplate>
<asp:Image runat="Server" ID="SlideShowImage1" ImageUrl="" Width="100%" Height="150px" />
<asp:AdRotator ID="AdRotator1" runat="Server" />
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="SlideShowTimer" EventName="Tick" />
</Triggers>
</asp:UpdatePanel>
<asp:UpdatePanelAnimationExtender ID="UPextender" runat="server" TargetControlID="SlideShow"
BehaviorID="animation" >
<Animations>
<OnUpdating>
<%-- It should take 1/2 of a second to fade out --%>
<FadeOut Duration=".5" Fps="20" minimumOpacity=".1" />
</OnUpdating>
<OnUpdated>
<%-- It should take 1 and 1/2 of a second to fade back in --%>
<FadeIn Duration="1.5" Fps="20" minimumOpacity=".1" />
</OnUpdated>
</Animations>
</asp:UpdatePanelAnimationExtender>
</div>
C#代码
//导入以下命名空间
使用System.Data;
使用System.Data.SqlClient;
protected void Page_Load(object sender,EventArgs e)
{
if(!IsPostBack)
{
AdRotator1.DataSource = FetchAdsFromDB();
AdRotator1.DataBind();
}
}
protected void SlideShowTimer_Tick(对象发送者,EventArgs e)
{
AdRotator1.DataSource = FetchAdsFromDB();
AdRotator1.DataBind();
}
私人数据表FetchAdsFromDB()
{
数据表DT =新数据表();
SqlDataAdapter的DA =新的SqlDataAdapter(选择AlternateText ,ImageUrl,NavigateUrl,来自imageadrotator的印象,con);
da.Fill(dt);
return dt;
// ImageUrl必须[需要来自db的图像位置]
}
}
C# code
//import following namespaces
using System.Data;
using System.Data.SqlClient;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
AdRotator1.DataSource = FetchAdsFromDB();
AdRotator1.DataBind();
}
}
protected void SlideShowTimer_Tick(object sender, EventArgs e)
{
AdRotator1.DataSource = FetchAdsFromDB();
AdRotator1.DataBind();
}
private DataTable FetchAdsFromDB()
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select AlternateText,ImageUrl,NavigateUrl,Impressions from imageadrotator", con);
da.Fill(dt);
return dt;
//ImageUrl must be needed[image location from db]
}
}
>
这篇关于从数据库中幻灯片显示多个图像的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!