AdRotator Problem

[MC]

I have coded an AdRotator to use a Database for it's data source. If I
use a SqlDataSource control it functions as expected, however if I
manually retreive the data using an OleDBDataReader It always omits the
first item in the result set? Code for each solution as below.

The reason I'm don't want to use the Declarative solution is that I
intend to Create a custom control that inherits from AdRotator and I
would then need to retrieve the Advert set programtically.

Regards
MC

------------------- Solution 1 - Declarative -------------------

<asp:Content ID="Content2" ContentPlaceHol derID="cphMainS ite"
Runat="Server">
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:AdsDatabase %>"
ProviderName="< %$ ConnectionStrin gs:AdsDatabase. ProviderName %>"
SelectCommand=" SELECT CompanyName AS ImageUrl, CompanyName AS
AlternateText, URL AS NavigateUrl, Impressions, Clicks FROM Sponsors
WHERE BannerAdvert=Tr ue" />
<asp:AdRotato r ID="AdRotator1 " runat="server"
DataSourceID="S qlDataSource1" />
</asp:Content>

------------------- Solution 2 - OleDBReader -------------------

<script runat="server">
protected void Page_Load(objec t sender, EventArgs e)
{
using (System.Data.Ol eDb.OleDbConnec tion conn = new
System.Data.Ole Db.OleDbConnect ion(Configurati onManager.Conne ctionStrings["AdsDatabas e"].ConnectionStri ng))
{
conn.Open();
using (System.Data.Ol eDb.OleDbComman d comm = new
System.Data.Ole Db.OleDbCommand ("SELECT CompanyName AS ImageUrl,
CompanyName AS AlternateText, URL AS NavigateUrl, Impressions, Clicks
FROM Sponsors WHERE BannerAdvert=Tr ue", conn))
{
AdRotator1.Data Source = comm.ExecuteRea der();
AdRotator1.Data Bind();
}
}
}
</script>
<asp:Content ID="Content2" ContentPlaceHol derID="cphMainS ite"
Runat="Server">
<asp:AdRotato r ID="AdRotator1 " runat="server" />
</asp:Content>