Ejemplo n.º 1
0
    protected void SuperForm1_DataBound(object sender, EventArgs e)
    {
        if (SuperForm1.CurrentMode == DetailsViewMode.Edit)
        {
            string shipCountry = DataBinder.Eval(SuperForm1.DataItem, "ShipCountry").ToString();
            string continentId = "0";

            OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("../App_Data/continent.mdb"));
            myConn.Open();

            OleDbCommand myComm = new OleDbCommand("SELECT ContinentID FROM Country WHERE CountryName = @CountryName", myConn);
            myComm.Parameters.Add("@CountryName", OleDbType.VarChar).Value = shipCountry;

            OleDbDataReader myReader = myComm.ExecuteReader();
            if (myReader.Read())
            {
                continentId = myReader[0].ToString();
            }

            myConn.Close();


            Obout.ComboBox.ComboBox shipCountryCombo = ((Obout.ComboBox.ComboBox)((DetailsViewRow)SuperForm1.Rows[2]).FindControl("ShipCountry"));
            shipCountryCombo.Details[0].SelectedValue = shipCountry;
            shipCountryCombo.SelectedValue            = continentId;
        }
    }
Ejemplo n.º 2
0
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();

            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox1 = new Obout.ComboBox.ComboBox();
            Obout.ComboBox.ComboBox comboBox2 = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox1);

            comboBox1.ID             = "ShipCountry";
            comboBox1.DataSourceID   = "ContinentsDataSource";
            comboBox1.AutoClose      = false;
            comboBox1.Width          = Unit.Percentage(100);
            comboBox1.MenuWidth      = Unit.Pixel(150);
            comboBox1.Height         = Unit.Pixel(150);
            comboBox1.DataValueField = "ContinentID";
            comboBox1.DataTextField  = "ContinentName";
            comboBox1.EmptyText      = "Select a country ...";
            comboBox1.HeaderTemplate = new HeaderTemplate("CONTINENTS");

            comboBox2.ID                 = "CountriesCombo";
            comboBox2.DataSourceID       = "CountriesDataSource";
            comboBox2.LoadingItems      += CountriesCombo_LoadingItems;
            comboBox2.Width              = Unit.Pixel(150);
            comboBox2.Height             = Unit.Pixel(150);
            comboBox2.DataValueField     = "CountryName";
            comboBox2.DataTextField      = "CountryName";
            comboBox2.EnableLoadOnDemand = true;
            comboBox2.HeaderTemplate     = new HeaderTemplate("COUNTRIES");

            comboBox1.Details.Add(comboBox2);
        }
        public void DataBindTemplate(object sender, EventArgs e)
        {
            PlaceHolder    templatePlaceHolder = sender as PlaceHolder;
            DetailsViewRow row  = templatePlaceHolder.Parent.Parent as DetailsViewRow;
            SuperForm      form = row.Parent.Parent as SuperForm;

            Obout.ComboBox.ComboBox comboBox = templatePlaceHolder.Controls[0] as Obout.ComboBox.ComboBox;

            comboBox.SelectedValue = DataBinder.Eval(form.DataItem, "ShipCountry").ToString();
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        ComboBox1                      = new Obout.ComboBox.ComboBox();
        ComboBox1.ID                   = "ComboBox1";
        ComboBox1.Width                = Unit.Pixel(275);
        ComboBox1.Height               = Unit.Pixel(200);
        ComboBox1.AutoPostBack         = true;
        ComboBox1.DataSourceID         = "sds1";
        ComboBox1.DataTextField        = "CompanyName";
        ComboBox1.DataValueField       = "CustomerID";
        ComboBox1.AppendDataBoundItems = false;

        ComboBox1.SelectedIndexChanged += ComboBox1_OnSelectedIndexChanged;

        ComboBox1Container.Controls.Add(ComboBox1);

        ComboBox2                      = new Obout.ComboBox.ComboBox();
        ComboBox2.ID                   = "ComboBox2";
        ComboBox2.Width                = Unit.Pixel(200);
        ComboBox2.Height               = Unit.Pixel(200);
        ComboBox2.AutoPostBack         = true;
        ComboBox2.Enabled              = false;
        ComboBox2.DataSourceID         = "sds2";
        ComboBox2.DataTextField        = "OrderID";
        ComboBox2.DataValueField       = "OrderID";
        ComboBox2.AppendDataBoundItems = false;

        ComboBox2.SelectedIndexChanged += ComboBox2_OnSelectedIndexChanged;

        ComboBox2Container.Controls.Add(ComboBox2);

        ComboBox3                      = new Obout.ComboBox.ComboBox();
        ComboBox3.ID                   = "ComboBox3";
        ComboBox3.Width                = Unit.Pixel(200);
        ComboBox3.Height               = Unit.Pixel(200);
        ComboBox3.Enabled              = false;
        ComboBox3.DataSourceID         = "sds3";
        ComboBox3.DataTextField        = "CompanyName";
        ComboBox3.DataValueField       = "SupplierID";
        ComboBox2.AppendDataBoundItems = false;

        ComboBox3Container.Controls.Add(ComboBox3);

        if (!IsPostBack)
        {
            ConfigureHeaderTemplates();
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        ComboBox1 = new Obout.ComboBox.ComboBox();
        ComboBox1.ID = "ComboBox1";
        ComboBox1.Width = Unit.Pixel(275);
        ComboBox1.Height = Unit.Pixel(200);
        ComboBox1.AutoPostBack = true;
        ComboBox1.DataSourceID = "sds1";
        ComboBox1.DataTextField = "CompanyName";
        ComboBox1.DataValueField = "CustomerID";
        ComboBox1.AppendDataBoundItems = false;

        ComboBox1.SelectedIndexChanged += ComboBox1_OnSelectedIndexChanged;

        ComboBox1Container.Controls.Add(ComboBox1);

        ComboBox2 = new Obout.ComboBox.ComboBox();
        ComboBox2.ID = "ComboBox2";
        ComboBox2.Width = Unit.Pixel(200);
        ComboBox2.Height = Unit.Pixel(200);
        ComboBox2.AutoPostBack = true;
        ComboBox2.Enabled = false;
        ComboBox2.DataSourceID = "sds2";
        ComboBox2.DataTextField = "OrderID";
        ComboBox2.DataValueField = "OrderID";
        ComboBox2.AppendDataBoundItems = false;

        ComboBox2.SelectedIndexChanged += ComboBox2_OnSelectedIndexChanged;

        ComboBox2Container.Controls.Add(ComboBox2);

        ComboBox3 = new Obout.ComboBox.ComboBox();
        ComboBox3.ID = "ComboBox3";
        ComboBox3.Width = Unit.Pixel(200);
        ComboBox3.Height = Unit.Pixel(200);
        ComboBox3.Enabled = false;
        ComboBox3.DataSourceID = "sds3";
        ComboBox3.DataTextField = "CompanyName";
        ComboBox3.DataValueField = "SupplierID";
        ComboBox2.AppendDataBoundItems = false;

        ComboBox3Container.Controls.Add(ComboBox3);

        if (!IsPostBack)
        {
            ConfigureHeaderTemplates();
        }
    }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();

            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.ID                   = "ShipCity";
            comboBox.DataSourceID         = "SqlDataSource3";
            comboBox.Width                = Unit.Percentage(100);
            comboBox.Height               = Unit.Pixel(150);
            comboBox.DataValueField       = "ShipCity";
            comboBox.DataTextField        = "ShipCity";
            comboBox.AppendDataBoundItems = false;
        }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();

            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.LoadingItems      += ShipCountry_LoadingItems;
            comboBox.ID                 = "ShipCountry";
            comboBox.Height             = Unit.Pixel(150);
            comboBox.Width              = Unit.Percentage(100);
            comboBox.DataValueField     = "ShipCountry";
            comboBox.DataTextField      = "ShipCountry";
            comboBox.EnableLoadOnDemand = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();

            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.ID                    = "ShipCountry";
            comboBox.DataSourceID          = "SqlDataSource2";
            comboBox.Width                 = Unit.Percentage(100);
            comboBox.Height                = Unit.Pixel(150);
            comboBox.DataValueField        = "ShipCountry";
            comboBox.DataTextField         = "ShipCountry";
            comboBox.SelectedIndexChanged += ShipCountry_SelectedIndexChanged;
            comboBox.AutoPostBack          = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
Ejemplo n.º 9
0
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();

            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.ID             = "CountryIds";
            comboBox.DataSourceID   = "SqlDataSource2";
            comboBox.Width          = Unit.Percentage(100);
            comboBox.Height         = Unit.Pixel(150);
            comboBox.DataValueField = "CountryID";
            comboBox.DataTextField  = "CountryName";
            comboBox.SelectionMode  = ListSelectionMode.Multiple;
            comboBox.AutoPostBack   = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
    protected string GetSelectedCountries()
    {
        Obout.ComboBox.ComboBox CountryIds = (Obout.ComboBox.ComboBox)((DetailsViewRow)SuperForm1.Rows[3]).FindControl("CountryIds");

        string selectedCountryIds = "";

        foreach (ComboBoxItem item in CountryIds.Items)
        {
            if (item.Selected == true)
            {
                if (selectedCountryIds != "")
                {
                    selectedCountryIds += ",";
                }

                selectedCountryIds += item.Value;
            }
        }

        return(selectedCountryIds);
    }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();
            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.LoadingItems += ShipCountry_LoadingItems;
            comboBox.ID = "ShipCountry";
            comboBox.Height = Unit.Pixel(150);
            comboBox.Width = Unit.Percentage(100);
            comboBox.DataValueField = "ShipCountry";
            comboBox.DataTextField = "ShipCountry";            
            comboBox.EnableLoadOnDemand = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();
            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox1 = new Obout.ComboBox.ComboBox();
            Obout.ComboBox.ComboBox comboBox2 = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox1);

            comboBox1.ID = "ShipCountry";
            comboBox1.DataSourceID = "ContinentsDataSource";
            comboBox1.AutoClose = false;
            comboBox1.Width = Unit.Percentage(100);
            comboBox1.MenuWidth= Unit.Pixel(150);
            comboBox1.Height = Unit.Pixel(150);
            comboBox1.DataValueField = "ContinentID";
            comboBox1.DataTextField = "ContinentName";
            comboBox1.EmptyText = "Select a country ...";
            comboBox1.HeaderTemplate = new HeaderTemplate("CONTINENTS");
            
            comboBox2.ID = "CountriesCombo";
            comboBox2.DataSourceID = "CountriesDataSource";
            comboBox2.LoadingItems += CountriesCombo_LoadingItems;
            comboBox2.Width= Unit.Pixel(150);
            comboBox2.Height = Unit.Pixel(150);
            comboBox2.DataValueField = "CountryName";
            comboBox2.DataTextField = "CountryName";
            comboBox2.EnableLoadOnDemand = true;
            comboBox2.HeaderTemplate = new HeaderTemplate("COUNTRIES");

            comboBox1.Details.Add(comboBox2);
        }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();
            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.ID = "CountryIds";
            comboBox.DataSourceID = "SqlDataSource2";
            comboBox.Width = Unit.Percentage(100);
            comboBox.Height = Unit.Pixel(150);
            comboBox.DataValueField = "CountryID";
            comboBox.DataTextField = "CountryName";
            comboBox.SelectionMode = ListSelectionMode.Multiple;
            comboBox.AutoPostBack = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
        public void InstantiateIn(Control container)
        {
            PlaceHolder templatePlaceHolder = new PlaceHolder();
            container.Controls.Add(templatePlaceHolder);

            Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
            templatePlaceHolder.Controls.Add(comboBox);

            comboBox.ID = "ShipCountry";
            comboBox.DataSourceID = "SqlDataSource2";
            comboBox.Width = Unit.Percentage(100);
            comboBox.Height = Unit.Pixel(150);
            comboBox.DataValueField = "ShipCountry";
            comboBox.DataTextField = "ShipCountry";
            comboBox.SelectedIndexChanged += ShipCountry_SelectedIndexChanged;
            comboBox.AutoPostBack = true;

            templatePlaceHolder.DataBinding += new EventHandler(DataBindTemplate);
        }
            public void InstantiateIn(Control container)
            {
                PlaceHolder templatePlaceHolder = new PlaceHolder();
                container.Controls.Add(templatePlaceHolder);

                Obout.ComboBox.ComboBox comboBox = new Obout.ComboBox.ComboBox();
                templatePlaceHolder.Controls.Add(comboBox);

                comboBox.ID = "ShipCity";
                comboBox.DataSourceID = "SqlDataSource3";
                comboBox.Width = Unit.Percentage(100);
                comboBox.Height = Unit.Pixel(150);
                comboBox.DataValueField = "ShipCity";
                comboBox.DataTextField = "ShipCity";
                comboBox.AppendDataBoundItems = false;
            }