public void LoadCtls()
{
string strSQL = "SELECT * FROM LK_BoardType WHERE BoardCategory = 1 ORDER BY iValue";
IDBManager dbManager = new DBManager(DataProvider.SqlServer);
dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString;
DataSet dsItems = new DataSet();
try
{
dbManager.Open();
dsItems = dbManager.ExecuteDataSet(CommandType.Text, strSQL);
cboBoardType.Items.Clear();
cboBoardType.DataSource = dsItems;
cboBoardType.DataMember = dsItems.Tables[0].ToString();
cboBoardType.DataTextField = "BoardType";
cboBoardType.DataValueField = "iValue";
cboBoardType.DataBind();
cboBoardType.Items.Add("Pick one");
cboBoardType.ClearSelection();
cboBoardType.SelectedIndex = cboBoardType.Items.Count - 1;
}
catch (Exception ex)
{
ErrorLog.ErrorRoutine(false, "AddAlert:LoadCtls:Error:" + ex.Message);
}
finally
{
dbManager.Close();
dbManager.Dispose();
}
}
public void SetSelectionsInPlaceholder(Option baseOption, System.Web.UI.WebControls.PlaceHolder ph, Catalog.OptionSelectionList selections)
{
if (ph == null)
{
return;
}
if (selections == null)
{
return;
}
OptionSelection val = selections.FindByOptionId(baseOption.Bvin);
if (val == null)
{
return;
}
System.Web.UI.WebControls.DropDownList ddl = (System.Web.UI.WebControls.DropDownList)ph.FindControl("opt" + baseOption.Bvin.Replace("-", ""));
if (ddl != null)
{
if (ddl.Items.FindByValue(val.SelectionData) != null)
{
ddl.ClearSelection();
ddl.Items.FindByValue(val.SelectionData).Selected = true;
}
}
}
public static void CarregaTextValueDdl(System.Web.UI.WebControls.DropDownList _Ddl, string _DataTextField, string _DataValueField)
{
_Ddl.DataTextField = _DataTextField;
_Ddl.DataValueField = _DataValueField;
_Ddl.Items.Clear();
_Ddl.SelectedIndex = -1;
_Ddl.SelectedValue = null;
_Ddl.ClearSelection();
}
/// <summary>
/// Sets a Selected Item of a DropDownlist Server Control according to value
/// </summary>
/// <param name="ddl"></param>
/// <param name="selectedValue"></param>
public static void SetSelectedItem(this System.Web.UI.WebControls.DropDownList ddl, String selectedValue)
{
if (ddl != null && ddl.Items.Count > 0)
{
ddl.ClearSelection();
foreach (System.Web.UI.WebControls.ListItem item in ddl.Items)
{
if (String.Compare(item.Value, selectedValue, true) == 0)
{
item.Selected = true;
break;
}
}
}
}
private void SetListToValue(System.Web.UI.WebControls.DropDownList l, string value)
{
if (l == null)
{
return;
}
if (l.Items.Count < 1)
{
return;
}
if (l.Items.FindByValue(value) != null)
{
l.ClearSelection();
l.Items.FindByValue(value).Selected = true;
}
}
public static void SelectItem(this System.Web.UI.WebControls.DropDownList drp, string selectedValue, DropDownListSelectionType type)
{
drp.ClearSelection();
System.Web.UI.WebControls.ListItem li;
if (type == DropDownListSelectionType.ByValue)
{
li = drp.Items.FindByValue(selectedValue.Trim());
}
else
{
li = drp.Items.FindByText(selectedValue.Trim());
}
if (li != null)
{
li.Selected = true;
}
}
