private void GetDDLBMSDetails() { try { DropDownFill DdlFilling = new DropDownFill(); SYS_BMSBLogic = new SYS_BMS_BLogic(); DataSet dsselectBMS = new DataSet(); dsselectBMS = SYS_BMSBLogic.BAL_SYS_BMS_SelectAll(); if (dsselectBMS.Tables.Count > ((int)EnumFile.AssignValue.Zero)) { if (dsselectBMS.Tables[0].Rows.Count > 0) { ddlBoardMediumStandard.Items.Clear(); ddlBoardMediumStandard.Items.Insert(0, "-- Select --"); ddlBoardMediumStandard.Items[0].Value = "0"; ddlBoardMediumStandard.DataSource = dsselectBMS.Tables[0]; ddlBoardMediumStandard.DataTextField = "BMS"; ddlBoardMediumStandard.DataValueField = "BMSID"; ddlBoardMediumStandard.DataBind(); } else { ddlBoardMediumStandard.Items.Clear(); ddlBoardMediumStandard.DataBind(); ddlBoardMediumStandard.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlBoardMediumStandard.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); } } } catch (Exception ex) { } }
/// <summary> /// Method will be used to bind bms to drop down. /// </summary> protected void getBMS() { try { DataSet dsBMS = new DataSet(); dsBMS = BAL_SYS_BMS.BAL_SYS_BMS_SelectAll(); if (dsBMS.Tables[0].Rows.Count > 0 && dsBMS.Tables[0] != null) { DDF.BindDropDownByTable(ddlBMS, dsBMS.Tables[0], "BMS", "BMSID"); ddlBMS.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlBMS.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); ddlBMS.Enabled = true; DDF.BindDropDownByTable(ddlBMSEdit, dsBMS.Tables[0], "BMS", "BMSID"); ddlBMSEdit.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlBMSEdit.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); ddlBMSEdit.Enabled = true; DDF.BindDropDownByTable(ddlBMSSearch, dsBMS.Tables[0], "BMS", "BMSID"); ddlBMSSearch.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlBMSSearch.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); ddlBMSSearch.Enabled = true; } } catch (Exception ex) { WebMsg.Show(ex.Message); } }
protected void GetBMS() { DropDownFill DdlFilling = new DropDownFill(); DataSet dsBMS = new DataSet(); dsBMS = BSysBMS.BAL_SYS_BMS_SelectAll(); if (dsBMS.Tables[0].Rows.Count > 0) { DdlFilling.BindDropDownByTable(ddlBMS, dsBMS.Tables[0], "BMS", "BMSID"); ddlBMS.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), "-- Select --"); ddlBMS.Items[0].Value = Convert.ToString((int)EnumFile.AssignValue.Zero); ddlBMS.Enabled = true; } }
protected static string[] GetBMS() { List <string> bmsList = new List <string>(); SYS_BMS_BLogic BSysBMS = new SYS_BMS_BLogic(); DataSet dsBMS = new DataSet(); try { dsBMS = BSysBMS.BAL_SYS_BMS_SelectAll(); foreach (DataRow dr in dsBMS.Tables[0].Rows) { bmsList.Add(dr["BMS"].ToString()); } } catch (Exception ex) { WebMsg.Show(ex.Message); } return(bmsList.ToArray()); }