Example #1
0
		private void LoadList()
		{	
			Variation clsVariation = new Variation();
			DataClass clsDataClass = new DataClass();

			string SortField = "VariationType";
			if (Request.QueryString["sortfield"]!=null)
			{	SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID);	}

            System.Data.SqlClient.SortOrder sortoption = System.Data.SqlClient.SortOrder.Ascending;
			if (Request.QueryString["sortoption"]!=null)
            { sortoption = (System.Data.SqlClient.SortOrder)Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }

			if (Request.QueryString["Search"]==null)
			{
				PageData.DataSource = clsVariation.ListAsDataTable(SortField, sortoption).DefaultView;
			}
			else
			{						
				string SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID);
				PageData.DataSource = clsDataClass.DataReaderToDataTable(clsVariation.Search(SearchKey, SortField, sortoption)).DefaultView;
			}

			clsVariation.CommitAndDispose();

			int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
			
			PageData.AllowPaging = true;
			PageData.PageSize = iPageSize;
			try
			{
				PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;				
				lstItem.DataSource = PageData;
				lstItem.DataBind();
			}
			catch
			{
				PageData.CurrentPageIndex = 1;
				lstItem.DataSource = PageData;
				lstItem.DataBind();
			}			
			
			cboCurrentPage.Items.Clear();
			for (int i=0; i < PageData.PageCount;i++)
			{
				int iValue = i + 1;
				cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
				if (PageData.CurrentPageIndex == i)
				{	cboCurrentPage.Items[i].Selected = true;}
				else
				{	cboCurrentPage.Items[i].Selected = false;}
			}
			lblDataCount.Text = " of " + " " + PageData.PageCount;
		}
        private void LoadVariation()
        {
            Variation clsVariation = new Variation();
            cboVariationType.DataTextField = "VariationType";
            cboVariationType.DataValueField = "VariationID";
            cboVariationType.DataSource = clsVariation.ListAsDataTable().DefaultView;
            cboVariationType.DataBind();
            cboVariationType.SelectedIndex = 0;

            clsVariation.CommitAndDispose();	
        }