コード例 #1
0
    private string Generate_Pagination_Links(int TotalPages)
    {
        StringBuilder str        = new StringBuilder();
        int           firstbound = 0;
        int           lastbound  = 0;
        string        ToolTip    = "";


        ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(TotalPages, this.PageNumber);

        if (arr.Count > 0)
        {
            int i = 0;
            for (i = 0; i <= arr.Count - 1; i++)
            {
                firstbound = ((int.Parse(arr[i].ToString()) - 1) * this.PageSize) + 1;
                lastbound  = firstbound + this.PageSize - 1;
                if (lastbound > this.TotalRecords)
                {
                    lastbound = this.TotalRecords;
                }
                ToolTip = showing + " " + firstbound + " - " + lastbound + " " + records + " " + Resources.vsk.of + " " + this.TotalRecords + " " + records;
                string _css = "";
                if (arr[i].ToString() == this.PageNumber.ToString())
                {
                    _css = " class=\"active\"";
                }
                str.Append("<li" + _css + "><a id=\"pg_" + arr[i].ToString() + "\" href=\"#\" class=\"pagination-css\" title=\"" + ToolTip + "\">" + arr[i].ToString() + "</a></li>\n");
            }
        }

        return(str.ToString());
    }
コード例 #2
0
    public static string Ajax_Pagination_V2(int total_records, int pagesize, int selectedpage)
    {
        StringBuilder str         = new StringBuilder();
        int           total_pages = (int)Math.Ceiling((double)total_records / pagesize);

        if (total_pages <= 1)
        {
            return("");
        }
        str.Append("<div class=\"pagination\">\n");
        ArrayList arr  = Pagination_Process.Return_Pagination_Link(total_pages, 7, selectedpage);
        int       i    = 0;
        string    _css = "";

        for (i = 0; i <= arr.Count - 1; i++)
        {
            if (Convert.ToInt32(arr[i]) == selectedpage)
            {
                _css = " class=\"active\"";
            }
            else
            {
                _css = "";
            }

            str.Append("<li" + _css + "><a href=\"#\" id=\"apg_" + arr[i].ToString() + "\" class=\"apagination-css\">" + arr[i].ToString() + "</a>");
        }
        str.Append("</div>\n");
        return(str.ToString());
    }
コード例 #3
0
    // Pagination Script version 3.0, support VSK 5.3 listing (SQL SERVER 2005, MySQL compatible)
    // Compatible with both MySQL / SQL SERVER.
    // Support Advance Pagination
    public static void Process_Pagination_v3(Repeater _rept, HyperLink _prev, HyperLink _next, int _size, int _pagenumber, int _totalrecords)
    {
        // MySQL Compatible
        int total_pages = (int)Math.Ceiling((double)_totalrecords / _size);

        if (total_pages > 1)
        {
            // Previous Link Scripting
            if (_pagenumber > 1)
            {
                _prev.Visible = true;
                int firstbound = (((_pagenumber - 1) - 1) * _size) + 1;
                if (firstbound < 0)
                {
                    firstbound = 1;
                }
                int lastbound = firstbound + _size - 1;
                _prev.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
            }
            else
            {
                _prev.Visible = false;
            }
            // Next Link Scripting
            if (_pagenumber < total_pages)
            {
                _next.Visible = true;
                int firstbound = (((_pagenumber + 1) - 1) * _size) + 1;
                int lastbound  = firstbound + _size - 1;
                if (lastbound > _totalrecords)
                {
                    lastbound = _totalrecords;
                }
                _next.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
            }
            else
            {
                _next.Visible = false;
            }

            // main pagination links
            ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(total_pages, _pagenumber);
            _rept.Visible    = true;
            _rept.DataSource = arr;
            _rept.DataBind();
        }
        else
        {
            _rept.Visible = false;
            _next.Visible = false;
            _prev.Visible = false;
        }
    }
コード例 #4
0
    // Fetch all video comments
    public static List <Comment_Struct> Fetch_Comments(long id, int type, int PageNumber, int PageSize)
    {
        SqlConnection con = new SqlConnection(Config.ConnectionString);

        con.Open();
        System.Collections.Generic.List <Comment_Struct> items = new System.Collections.Generic.List <Comment_Struct>();
        Comment_Struct str_ct = default(Comment_Struct);
        //// generate query
        StringBuilder str   = new StringBuilder();
        StringBuilder query = new StringBuilder();

        query.Append("commentid,username,_comment,videoid,added_date,points from comments WHERE VideoID=" + id + " AND type=" + type + " AND isenabled=1 AND isApproved=1");
        // implement paging script for differnt data sources.
        switch (Site_Settings.Pagination_Type)
        {
        case 0:
            // SQL SERVER 2005 or Later Supported Query
            str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), "commentid DESC", PageNumber, PageSize));
            break;

        case 1:
            // MySQL Supported Query
            string mysql_query = "SELECT " + query.ToString() + " ORDER BY commentid DESC";
            str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, PageSize));
            break;

        case 2:
            // SQL SERVER 2000 Supported Query
            string normal_query = "SELECT " + query.ToString() + " ORDER BY commentid DESC";
            str.Append(normal_query);
            break;
        }
        SqlCommand    cmd    = new SqlCommand(str.ToString(), con);
        SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

        while (reader.Read())
        {
            str_ct            = new Comment_Struct();
            str_ct.CommentID  = (long)reader["CommentID"];
            str_ct.UserName   = reader["username"].ToString();
            str_ct.Added_Date = (DateTime)reader["added_date"];
            str_ct.Comment    = reader["_comment"].ToString();
            str_ct.VideoID    = Convert.ToInt64(reader["videoid"]);
            str_ct.Points     = (int)reader["points"];
            items.Add(str_ct);
        }
        reader.Close();
        con.Close();
        return(items);
    }
コード例 #5
0
    private void BindList()
    {
        int    pagesize = Convert.ToInt32(drp_pagesize.SelectedValue);
        string search   = "";

        if (txt_search.Text != "")
        {
            search = txt_search.Text;
        }

        //if (this.TotalRecords == 0)
        this.TotalRecords = CommentsBLL.Count_Comments(search, this.UserName, drp_type.SelectedValue, Convert.ToInt32(drp_isenable.SelectedValue), Convert.ToInt32(drp_approve.SelectedValue), Convert.ToInt32(drp_filter.SelectedValue));

        if (this.TotalRecords == 0)
        {
            // no record exist
            pnl_main.Visible      = false;
            pnl_norecord.Visible  = true;
            lbl_records.InnerHtml = "<h4>0 records found</h4>";
            return;
        }

        List <Comment_Struct> list = CommentsBLL.Load_Comments(search, this.UserName, drp_type.SelectedValue, Convert.ToInt32(drp_isenable.SelectedValue), Convert.ToInt32(drp_approve.SelectedValue), Convert.ToInt32(drp_filter.SelectedValue), drp_order.SelectedValue, this.PageNumber, pagesize);

        if (list.Count > 0)
        {
            ViewState["script_value"] = "";
            //int count = int.Parse(list.Count.ToString());
            if (this.TotalRecords > 1)
            {
                lbl_records.InnerHtml = "<h4>" + this.TotalRecords + " records found</h4>";
            }
            else
            {
                lbl_records.InnerHtml = this.TotalRecords + " record found";
            }
            // setup pagination
            Pagination_Process.Process_Pagination(MyList, rptPages, lnk_Prev, lnk_Next, pagesize, this.PageNumber, list, this.TotalRecords);

            pnl_main.Visible     = true;
            pnl_norecord.Visible = false;
        }
        else
        {
            pnl_main.Visible      = false;
            pnl_norecord.Visible  = true;
            lbl_records.InnerHtml = "<h4>0 records found</h4>";
        }
    }
コード例 #6
0
    private void BindList()
    {
        DataSet ds = AdsBLL.Load_Ads(int.Parse(drp_sorttype.SelectedValue));

        if (ds.Tables[0].Rows.Count > 0)
        {
            Pagination_Process.Process_Pagination(MyList, rptPages, lnk_Prev, lnk_Next, 40, this.PageNumber, ds.Tables[0].DefaultView);
            pnl_main.Visible     = true;
            pnl_norecord.Visible = false;
        }
        else
        {
            pnl_main.Visible     = false;
            pnl_norecord.Visible = true;
        }
    }
コード例 #7
0
    private string Generate_Pagination_Links(int TotalPages, string _rooturl)
    {
        StringBuilder str = new StringBuilder();
        int firstbound = 0;
        int lastbound = 0;
        string ToolTip = "";


        ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(TotalPages, this.PageNumber);
        if (arr.Count > 0)
        {
            int i = 0;
            string LinkURL = "";
            string Item = "";
            for (i = 0; i <= arr.Count - 1; i++)
            {
                Item = arr[i].ToString();
                firstbound = ((int.Parse(Item) - 1) * this.PageSize) + 1;
                lastbound = firstbound + this.PageSize - 1;
                if (lastbound > this.TotalRecords)
                    lastbound = this.TotalRecords;
                ToolTip = showing + " " + firstbound + " - " + lastbound + " " + records + " " + Resources.vsk.of + " " + this.TotalRecords + " " + records;
                // url settings
                // normal search
                if (Item == "1")
                {
                    if (this.isFilter) // videos/MostViewed/ThisWeek.aspx
                        LinkURL = Config.GetUrl() + "" + this.Filter_Default_Url;
                    else // videos/MostViewed.aspx
                        LinkURL = Config.GetUrl() + "" + this.Default_Url;
                }
                else
                {
                    if (this.isFilter) // videos/MostViewed/232/ThisWeek.aspx
                        LinkURL = Config.GetUrl() + "" + UtilityBLL.Add_PageNumber(this.Filter_Pagination_Url, Item);
                    else // videos/232/MostViewed.aspx
                        LinkURL = Config.GetUrl() + "" + UtilityBLL.Add_PageNumber(this.Pagination_Url, Item);
                }
                string _css = "";
                if (arr[i].ToString() == this.PageNumber.ToString())
                    _css = "class=\"active\"";
                str.Append("<li " + _css + "><a href=\"" + LinkURL + "\" title=\"" + ToolTip + "\">" + arr[i].ToString() + "</a></li>\n");
            }
        }

        return str.ToString();
    }
コード例 #8
0
    //// Load Administrators
    private void BindList()
    {
        DataSet ds = ErrorLgBLL.Load_Log();

        if (ds.Tables[0].Rows.Count > 0)
        {
            Pagination_Process.Process_Pagination(MyList, rptPages, lnk_Prev, lnk_Next, 20, this.PageNumber, ds.Tables[0].DefaultView);
            //Process_Pagination(ds);
            pnl_main.Visible     = true;
            pnl_norecord.Visible = false;
        }
        else
        {
            pnl_main.Visible     = false;
            pnl_norecord.Visible = true;
        }
    }
コード例 #9
0
    private void BindList()
    {
        string search = "all";

        if (txt_search.Text != "")
        {
            search = txt_search.Text;
        }
        this.TotalRecords = members.Count_Members(search, drp_gender.SelectedValue, "0", drp_countries.SelectedValue, drp_isenabled.SelectedValue, drp_type.SelectedValue, Convert.ToInt32(drp_filter.SelectedValue));
        // no record found
        if (this.TotalRecords == 0)
        {
            pnl_main.Visible     = false;
            pnl_norecord.Visible = true;
            lbl_records.Text     = "0 records found";
            return;
        }

        List <Member_Struct> _lst = members.Load_Members(search, drp_gender.SelectedValue, "0", drp_countries.SelectedValue, drp_isenabled.SelectedValue, drp_type.SelectedValue, Convert.ToInt32(drp_filter.SelectedValue), ViewState["order"].ToString(), ViewState["direction"].ToString(), this.PageNumber, this.PageSize);

        if (_lst.Count > 0)
        {
            if (this.TotalRecords > 0)
            {
                lbl_records.Text = _lst.Count + " records found";
            }
            else
            {
                lbl_records.Text = _lst.Count + " record found";
            }

            Pagination_Process.Process_Pagination(MyList, rptPages, lnk_Prev, lnk_Next, this.PageSize, this.PageNumber, _lst);
            pnl_main.Visible     = true;
            pnl_norecord.Visible = false;
        }
        else
        {
            pnl_main.Visible     = false;
            pnl_norecord.Visible = true;
            lbl_records.Text     = "0 records found";
        }
    }
コード例 #10
0
    // Load photos in admin section
    public static List <Comment_Struct> Load_Comments(string search, string username, string type, int isEnabled, int isApproved, int filteroption, string order, int PageNumber, int PageSize)
    {
        SqlConnection con = new SqlConnection(Config.ConnectionString);

        if (con.State != ConnectionState.Open)
        {
            con.Open();
        }
        List <Comment_Struct> _items = new List <Comment_Struct>();
        Comment_Struct        _item;

        // Query Building
        StringBuilder str   = new StringBuilder();
        StringBuilder query = new StringBuilder();
        string        logic = CommentsBLL.Return_Comment_Admin_Logic(search, username, type, isEnabled, isApproved, filteroption);

        query.Append("commentid,videoid,username,_comment,added_date,isenabled,type,points,isapproved,replyid,profileid FROM comments" + logic);
        // implement paging script for differnt data sources.
        switch (Site_Settings.Pagination_Type)
        {
        case 0:
            // SQL SERVER 2005 or Later Supported Query
            str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), order, PageNumber, PageSize));
            break;

        case 1:
            // MySQL Supported Query
            string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + order;
            str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, PageSize));
            break;

        case 2:
            // SQL SERVER 2000 Supported Query
            string normal_query = "SELECT " + query.ToString() + " ORDER BY " + order;
            str.Append(normal_query);
            break;
        }
        // execute sql query
        SqlCommand video_cmd = new SqlCommand(str.ToString(), con);

        video_cmd.Parameters.Add(new SqlParameter("@search", search));
        video_cmd.Parameters.Add(new SqlParameter("@username", username));
        video_cmd.Parameters.Add(new SqlParameter("@type", type));
        video_cmd.Parameters.Add(new SqlParameter("@isenabled", isEnabled));
        video_cmd.Parameters.Add(new SqlParameter("@isapproved", isApproved));
        SqlDataReader reader = video_cmd.ExecuteReader(CommandBehavior.CloseConnection);

        while (reader.Read())
        {
            _item            = new Comment_Struct();
            _item.CommentID  = (long)reader["commentid"];
            _item.Comment    = reader["_comment"].ToString();
            _item.UserName   = reader["username"].ToString();
            _item.VideoID    = (long)reader["videoid"];
            _item.isEnabled  = Convert.ToInt32(reader["isenabled"]);
            _item.isApproved = Convert.ToInt32(reader["isapproved"]);
            _item.Type       = Convert.ToInt32(reader["type"]);
            _item.ReplyID    = (long)reader["replyid"];
            _item.Points     = Convert.ToInt32(reader["points"]);
            _item.Added_Date = (DateTime)reader["added_date"];
            _item.ProfileID  = reader["profileid"].ToString();
            _items.Add(_item);
        }
        reader.Close();
        con.Close(); con.Dispose();

        return(_items);
    }
コード例 #11
0
    // Fetch Comments With User Profile Picture
    public static List <Comment_Struct> Fetch_Comments_V2(long id, string profileid, int type, int PageNumber, int PageSize, string Order, bool ShowAuthoImage)
    {
        SqlConnection con = new SqlConnection(Config.ConnectionString);

        con.Open();
        System.Collections.Generic.List <Comment_Struct> items = new System.Collections.Generic.List <Comment_Struct>();
        Comment_Struct str_ct = default(Comment_Struct);
        //// generate query
        StringBuilder str   = new StringBuilder();
        StringBuilder query = new StringBuilder();
        //// generate query
        string _filter = "";

        if (profileid != "")
        {
            _filter = "c.profileid=@profileid"; //_filter = "c.profileid=" + profileid.Replace("'","");
        }
        else
        {
            _filter = "c.videoid=@id";                                                               // _filter = "c.videoid=" + id;
        }
        query.Append("c.commentid,c.username,c._comment,c.videoid,c.added_date,c.points,c.replyid"); // remove ,
        if (ShowAuthoImage)
        {
            query.Append(",u.picturename"); // remove,
        }
        query.Append(" FROM comments c ");  // WHERE p.videoid=555 ORDER BY level;
        if (ShowAuthoImage)
        {
            query.Append("inner join users as u on u.username=c.username ");
        }
        query.Append(" WHERE " + _filter + " AND c.type=@type AND c.isenabled=1  AND c.isApproved=1");

        // implement paging script for differnt data sources.
        switch (Site_Settings.Pagination_Type)
        {
        case 0:
            // SQL SERVER 2005 or Later Supported Query
            str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), Order, PageNumber, PageSize));
            break;

        case 1:
            // MySQL Supported Query
            string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + Order;
            str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, PageSize));
            break;

        case 2:
            // SQL SERVER 2000 Supported Query
            string normal_query = "SELECT " + query.ToString() + " ORDER BY " + Order;
            str.Append(normal_query);
            break;
        }
        SqlParameter profileparam   = new SqlParameter("@profileid", profileid);
        SqlParameter contentidparam = new SqlParameter("@id", id);
        SqlParameter typeparam      = new SqlParameter("@type", type);

        SqlCommand cmd = new SqlCommand(str.ToString(), con);

        cmd.Parameters.Add(profileparam);
        cmd.Parameters.Add(contentidparam);
        cmd.Parameters.Add(typeparam);
        SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

        while (reader.Read())
        {
            str_ct            = new Comment_Struct();
            str_ct.CommentID  = (long)reader["CommentID"];
            str_ct.UserName   = reader["username"].ToString();
            str_ct.Added_Date = (DateTime)reader["added_date"];
            str_ct.Comment    = reader["_comment"].ToString();
            str_ct.VideoID    = Convert.ToInt64(reader["videoid"]);
            str_ct.Points     = (int)reader["points"];
            str_ct.ReplyID    = Convert.ToInt64(reader["replyid"]);
            if (ShowAuthoImage)
            {
                str_ct.PictureName = reader["picturename"].ToString();
            }
            items.Add(str_ct);
        }
        reader.Close();
        con.Close();
        return(items);
    }
コード例 #12
0
    // The following function load specific number of records without any pagination. e.g Fetching top 8 recently added photos
    // Non Cache Version
    public static List <UserActivity_Struct> Fetch_Activities(string term, string UserName, int Month, int Year, string order, int records, int datefilter, int PageNumber)
    {
        SqlConnection con = new SqlConnection(Config.ConnectionString);

        if (con.State != ConnectionState.Open)
        {
            con.Open();
        }
        List <UserActivity_Struct> _items = new List <UserActivity_Struct>();
        UserActivity_Struct        _item;

        // generate sql query
        string        logic = ActivityBLL.Process_Activity_V3_Logic(term, UserName, Month, Year, datefilter);
        StringBuilder str   = new StringBuilder();
        StringBuilder query = new StringBuilder();

        query.Append("u.picturename,p.activityid,p.username,p.poster_username,p.activity,p.title,p.added_date,p.liked,p.disliked,u.picturename,p.comments FROM useractivities as p Inner join users as u on u.username=p.poster_username " + logic);

        switch (Site_Settings.Pagination_Type)
        {
        case 0:
            // SQL SERVER 2005 or Later Supported Query
            str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), order, PageNumber, records));
            break;

        case 1:
            // MySQL Supported Query
            string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + order;
            str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, records));
            break;

        case 2:
            // SQL SERVER 2000 Supported Query
            string normal_query = "SELECT " + query.ToString() + " ORDER BY " + order;
            str.Append(normal_query);
            break;
        }
        // execute sql query
        SqlCommand cmd = new SqlCommand(str.ToString(), con);

        cmd.Parameters.Add(new SqlParameter("@username", UserName));
        SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

        while (reader.Read())
        {
            _item            = new UserActivity_Struct();
            _item.ActivityID = (long)reader["activityid"];

            _item.UserName       = reader["username"].ToString();
            _item.Title          = reader["title"].ToString();
            _item.Activity       = reader["activity"].ToString();
            _item.Added_Date     = (DateTime)reader["added_date"];
            _item.Liked          = Convert.ToInt32(reader["liked"]);
            _item.Disliked       = Convert.ToInt32(reader["disliked"]);
            _item.Comments       = Convert.ToInt32(reader["comments"]);
            _item.PictureName    = reader["picturename"].ToString();
            _item.PosterUserName = reader["poster_username"].ToString();
            _items.Add(_item);
        }
        reader.Close();
        con.Close(); con.Dispose();

        return(_items);
    }
コード例 #13
0
    // Process Pagination ver 2.0 // Compatible with Hyperlinks
    // Compatible with both MySQL / SQL SERVER.
    // Support Advance Pagination
    public static void Process_Pagination_v2(DataList _list, Repeater _rept, HyperLink _prev, HyperLink _next, int _size, int _pagenumber, IEnumerable _source, int _totalrecords)
    {
        if (Site_Settings.Pagination_Type == 1)
        {
            // MySQL Compatible
            int total_pages = (int)Math.Ceiling((double)_totalrecords / _size);
            if (total_pages > 1)
            {
                // Previous Link Scripting
                if (_pagenumber > 1)
                {
                    _prev.Visible = true;
                    int firstbound = (((_pagenumber - 1) - 1) * _size) + 1;
                    if (firstbound < 0)
                    {
                        firstbound = 1;
                    }
                    int lastbound = firstbound + _size - 1;
                    _prev.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
                }
                else
                {
                    _prev.Visible = false;
                }
                // Next Link Scripting
                if (_pagenumber < total_pages)
                {
                    _next.Visible = true;
                    int firstbound = (((_pagenumber + 1) - 1) * _size) + 1;
                    int lastbound  = firstbound + _size - 1;
                    if (lastbound > _totalrecords)
                    {
                        lastbound = _totalrecords;
                    }
                    _next.ToolTip = "Showing " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
                }
                else
                {
                    _next.Visible = false;
                }

                // main pagination links
                ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(total_pages, _pagenumber);
                _rept.Visible    = true;
                _rept.DataSource = arr;
                _rept.DataBind();
            }
            else
            {
                _rept.Visible = false;
                _next.Visible = false;
                _prev.Visible = false;
            }

            _list.DataSource = _source;
            _list.DataBind();
        }
        else
        {
            // SQL SERVER Compatible
            PagedDataSource objPds = new PagedDataSource();
            objPds.DataSource  = _source;
            objPds.AllowPaging = true;

            objPds.PageSize         = _size;
            objPds.CurrentPageIndex = (_pagenumber - 1);

            if (!objPds.IsFirstPage)
            {
                _prev.Visible = true;
                int firstbound = (((_pagenumber - 1) - 1) * _size) + 1;
                if (firstbound < 0)
                {
                    firstbound = 1;
                }

                int lastbound = firstbound + _size - 1;

                _prev.ToolTip = "Showing previous " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
            }
            else
            {
                _prev.Visible = false;
            }
            if (!objPds.IsLastPage)
            {
                int firstbound = (((_pagenumber + 1) - 1) * _size) + 1;
                int lastbound  = firstbound + _size - 1;
                if (lastbound > _totalrecords)
                {
                    lastbound = _totalrecords;
                }

                _next.ToolTip = "Showing next " + firstbound + " - " + lastbound + " records of " + _totalrecords + " records";
                _next.Visible = true;
            }
            else
            {
                _next.Visible = false;
            }

            ArrayList arr = Pagination_Process.Return_Pagination_Link_v2(objPds.PageCount, _pagenumber);
            if (objPds.PageCount > 1)
            {
                _rept.Visible    = true;
                _rept.DataSource = arr;
                _rept.DataBind();
            }
            else
            {
                _rept.Visible = false;
            }

            _list.DataSource = objPds;
            _list.DataBind();
        }
    }