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; } }
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(); } }
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); }
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 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); }