PagedDataSource pagedData = new PagedDataSource();
pagedData.DataSource = Controller.GetPicturesForEvent(this.PortalId, myUserID, myEventNumber);
pagedData.AllowPaging = true;
pagedData.PageSize = 16;
pagedData.CurrentPageIndex = current_page - 1;
rptItems.DataSource = pagedData;
rptItems.DataBind();

"rptItems" is my DataList (or GridView or DataGrid) This is my DAL+ Method:

static public List<PictureInfo> GetPicturesForEvent(int portalID, int userID, string album_name)
        {
            StringBuilder mySqlString = new StringBuilder();
            mySqlString.Append("SELECT FotoVisionDNN_Pictures.PhotoID, FotoVisionDNN_Pictures.PhotoName, FotoVisionDNN_Pictures.Title, FotoVisionDNN_Pictures.Keywords, ");
            mySqlString.Append("FotoVisionDNN_Pictures.Date, FotoVisionDNN_Pictures.Description, FotoVisionDNN_Pictures.Hashcode ");
            mySqlString.Append("FROM FotoVisionDNN_Albums INNER JOIN ");
            mySqlString.Append("FotoVisionDNN_Pictures ON FotoVisionDNN_Albums.AlbumID = FotoVisionDNN_Pictures.AlbumID ");
            mySqlString.Append("WHERE (FotoVisionDNN_Albums.PortalID = @PortalID) AND (FotoVisionDNN_Albums.UserID = @UserID) AND (FotoVisionDNN_Albums.AlbumName = @AlbumName)");

            SqlParameter prmPortalID = new SqlParameter("@PortalID", SqlDbType.Int, 4);
            SqlParameter prmUserID = new SqlParameter("@UserID", SqlDbType.Int, 4);
            SqlParameter prmAlbumName = new SqlParameter("@AlbumName", SqlDbType.NVarChar, 100);
            prmPortalID.Value = portalID;
            prmUserID.Value = userID;
            prmAlbumName.Value = album_name;

            List<PictureInfo> pictureInfolist = new List<PictureInfo>();
            using (IDataReader dr = DotNetNuke.Data.DataProvider.Instance().ExecuteSQL(mySqlString.ToString(), prmPortalID, prmUserID, prmAlbumName))
            {
                while (dr.Read())
                {
                    PictureInfo colPictureInfo = new PictureInfo();
                    colPictureInfo.PhotoID = Convert.ToInt32(dr["PhotoID"]);
                    colPictureInfo.PhotoName = String.Format(@"~/Portals/{0}/FotoVision/{1}/{2}/thumbnails/{3}", portalID, userID, album_name, Convert.ToString(dr["PhotoName"]));
                    colPictureInfo.Title = Convert.ToString(dr["Title"]);
                    colPictureInfo.Keywords = Convert.ToString(dr["Keywords"]);
                    colPictureInfo.PictureDate = Convert.ToDateTime(dr["Date"]);
                    colPictureInfo.Description = Convert.ToString(dr["Description"]);
                    colPictureInfo.Hashcode = Convert.ToString(dr["Hashcode"]);

                    pictureInfolist.Add(colPictureInfo);
                }
            }
            return pictureInfolist;
        }