How do I set up a AdRotator Control with a SqlDataSource?

.aspx
 
<asp:Timer ID="uxTimer" Interval="1000" runat="server" />
            <asp:UpdatePanel ID="uxAdRotatorUpdatePanel" runat="server">
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="uxTimer" EventName="Tick" />
                </Triggers>
                <ContentTemplate>        
                    <asp:AdRotator ID="uxAnnouncementsAdRotator" runat="server" 
                                   DataSourceID="uxFrontPageSqlDataSource" />
                </ContentTemplate>
            </asp:UpdatePanel> 
 
<asp:SqlDataSource ID="uxFrontPageSqlDataSource" runat="server"
                   ConnectionString="<%$ ConnectionStrings:infonet %>"
                   SelectCommand="sp_GetFrontPageAnnouncements"
                   SelectCommandType="StoredProcedure" />
 
.cs
 
    protected void Tick(object sender, EventArgs e)
    {
        uxAdRotatorUpdatePanel.Update();
    }
 
stored proc
 
	SET NOCOUNT ON;
	SELECT AlternateTextField, NavigateUrlField, ImageUrlField
	FROM FrontPageAnnouncements 
	WHERE StartDate < getdate() AND EndDate > getdate() 
	ORDER BY OrderID;

Select allOpen in new window