private void LoadOptions() { DataClass clsDataClass = new DataClass(); lblProductSubGroupID.Text = Common.Decrypt((string)Request.QueryString["subgroupid"],Session.SessionID); lblProductSubGroupVariationID.Text = Common.Decrypt(Request.QueryString["id"],Session.SessionID); Variation clsVariation = new Variation(); string VariationType = clsVariation.Details( Convert.ToInt32(lblProductSubGroupVariationID.Text)).VariationType; clsVariation.CommitAndDispose(); ProductSubGroupVariations clsProductSubGroupVariation = new ProductSubGroupVariations(); cboVariationType.DataTextField = "VariationType"; cboVariationType.DataValueField = "VariationID"; cboVariationType.DataSource = clsDataClass.DataReaderToDataTable(clsProductSubGroupVariation.AvailableVariations(Convert.ToInt32(lblProductSubGroupID.Text),"VariationType",SortOption.Ascending)).DefaultView; cboVariationType.DataBind(); cboVariationType.Items.Add(new ListItem(VariationType, lblProductSubGroupVariationID.Text)); cboVariationType.SelectedIndex = cboVariationType.Items.Count - 1; clsProductSubGroupVariation.CommitAndDispose(); }