ASP.NET

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="EventId"<br />
        DataSourceID="SqlDataSource1" SelectedIndex="1"><br />
        <Columns><br />
            <asp:CommandField ShowSelectButton="True" /><br />
            <asp:BoundField DataField="EventId" HeaderText="EventId" InsertVisible="False" ReadOnly="True"<br />
                SortExpression="EventId" /><br />
            <asp:BoundField DataField="EventName" HeaderText="EventName" SortExpression="EventName" /><br />
            <asp:BoundField DataField="EvenThun" HeaderText="EvenThun" SortExpression="EvenThun" /><br />
        </Columns><br />
    </asp:GridView><br />
               <br />
                 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:vpx_newConnectionString %>"<br />
        SelectCommand="SELECT * FROM [Events]"></asp:SqlDataSource> <br />
<br />
  Sub BindData()<br />
        'Read sample item info from XML document into a DataSet<br />
        Dim cnn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("vpx_newConnectionString").ToString)<br />
        cnn.Open()<br />
        Dim cmd As SqlDataAdapter = New SqlDataAdapter("select * from mediaphotos Where EventID =" & GridView1.SelectedValue, cnn)<br />
<br />
        Dim ds As New DataSet()<br />
        cmd.Fill(ds)<br />
<br />
        ' Populate the repeater control with the Items DataSet<br />
        Dim dsPaged As New PagedDataSource()<br />
        dsPaged.DataSource = ds.Tables(0).DefaultView<br />
        dsPaged.AllowPaging = True<br />
        dsPaged.PageSize = 5<br />
<br />
        dsPaged.CurrentPageIndex = CurrentPage<br />
<br />
        'Disable Prev or Next buttons if necessary<br />
        cmdPrev.Enabled = Not dsPaged.IsFirstPage<br />
        cmdNext.Enabled = Not dsPaged.IsLastPage<br />
<br />
        rptParts.DataSource = dsPaged<br />
        rptParts.DataBind()