Esempio n. 1
0
        protected void bindLists()
        {
            try
            {
                pagingSource = new PagedDataSource();
                if (txtSearchListName.Text == "")
                {
                    AdvanceListMaster objListMaster = new AdvanceListMaster(ConnectionString);
                    dtLists = objListMaster.SelectAllAdvencedLists(ConnectionString, "CreatedDate", "Desc");
                    pagingSource.DataSource = dtLists.DefaultView;
                    pagingSource.AllowPaging = true;
                    pagingSource.PageSize = pSize;
                    pagingSource.CurrentPageIndex = (ViewState["IEPageNumber"] != null) ? (int)ViewState["IEPageNumber"] : 0;
                    ViewState["IEPageCount"] = pagingSource.PageCount;
                    pnlNavigation.Style.Add("display", "Block");
                }
                else
                {
                    SearchedListsDt = new DataTable();
                    SearchedListsDt = AdvanceListMaster.AdvanceSearchSelectLookup(ConnectionString, txtSearchListName.Text);
                    pagingSource.DataSource = SearchedListsDt.DefaultView;
                    if (SearchedListsDt.Rows.Count <= 1)
                    {
                        pnlNavigation.Style.Add("display", "none");
                    }
                    if (SearchedListsDt.Rows.Count == 0)
                    {
                        lblmsgnewlist.Text = "Records Not Found !";
                        lblmsgnewlistUp.Update();
                    }
                    else
                    {
                        lblmsgnewlist.Text = "Records Found " + SearchedListsDt.Rows.Count;
                        lblmsgnewlistUp.Update();
                    }
                    pagingSource.AllowPaging = true;
                    pagingSource.PageSize = pSize;
                    if (SearchedListsDt.Rows.Count < pSize)
                    {
                        pagingSource.CurrentPageIndex = 0;
                    }
                    else
                    {
                        pagingSource.CurrentPageIndex = (int)ViewState["IEPageNumber"];
                        ViewState["IEPageCount"] = pagingSource.PageCount;
                    }
                }
                if (pagingSource.IsFirstPage)
                {
                    lnkFirst.Visible = false;
                    lnkPrev.Visible = false;
                }
                else
                {
                    lnkFirst.Visible = true;
                    lnkPrev.Visible = true;
                }

                if (pagingSource.IsLastPage)
                {
                    lnkNext.Visible = false;
                    lnkLast.Visible = false;
                }
                else
                {
                    lnkNext.Visible = true;
                    lnkLast.Visible = true;
                }
                chkListNames.DataSource = pagingSource;
                chkListNames.DataTextField = "ListContacts";
                chkListNames.DataValueField = "ListMasterID";
                chkListNames.DataBind();
                upnlgrdList.Update();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 2
0
 protected void bindListNames()
 {
     AdvanceListMaster objListMaster = new AdvanceListMaster(ConnectionString);
     dtLists = objListMaster.SelectAllAdvencedLists(ConnectionString, "Listname", "ASC");
     if (dtLists.Rows.Count > 0)
     {
         chkListNames.DataSource = dtLists;
         chkListNames.DataTextField = "ListContacts";
         chkListNames.DataValueField = "ListMasterID";
         chkListNames.DataBind();
     }
 }