public bool CheckRemoveMessage(DataSet ds, BasePopupFrm page, string item, bool isShowMsg) { if (DSUtil.GetResultSucceed(ds) == Definition.FAIL) { page.MsgClose(); if (isShowMsg && DSUtil.GetResultMsg(ds) != "") { MSGHandler.DisplayMessage(MSGType.Warning, "VMS_DELETE_FAIL_USEDATA", new string[] { item }, null); } return(false); } else { page.MsgClose(); if (isShowMsg) { MSGHandler.DisplayMessage(MSGType.Information, "VMS_DELETE_SUCCESS", null, null); } return(true); } }
public DataSet QueryConfigList() { DataSet ds = new DataSet(); try { //LinkedList lklist = new LinkedList(); //lklist.Add("FRAMEWORK_ID", sFrameworkID); //lklist.Add("MEMBER_ID", sMemberID); //ds = base.Query(SQL_QUERY_CONFIG_LIST, lklist); ds = base.Query(SQL_QUERY_CONFIG_LIST); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch (Exception ex) { } return(ds); }
// TODO : Added by Danny [2009.05.13] public bool CheckSaveMessage(DataSet ds, bool isShowMsg) { if (DSUtil.GetResultSucceed(ds) == Definition.FAIL) { if (isShowMsg && DSUtil.GetResultMsg(ds) != "") { MSGHandler.DisplayMessage(MSGType.Error, DSUtil.GetResultMsg(ds)); } else if (isShowMsg) { MSGHandler.DisplayMessage(MSGType.Warning, "GENERAL_SAVE_FAIL", null, null); } return(false); } else { if (isShowMsg) { MSGHandler.DisplayMessage(MSGType.Information, "GENERAL_SAVE_SUCCESS", null, null); } return(true); } }
public bool CheckSearchMessage(DataSet ds, BasePopupFrm page, bool isShowMsg) { if (DSUtil.GetResultSucceed(ds) == Definition.FAIL) { page.MsgClose(); if (isShowMsg && DSUtil.GetResultMsg(ds) != "") { MSGHandler.DisplayMessage(MSGType.Error, DSUtil.GetResultMsg(ds)); } return(false); } else { if (ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { page.MsgClose(); if (isShowMsg) { MSGHandler.DisplayMessage(MSGType.Information, "GENERAL_NO_DATA", null, null); } } return(true); } }
//SPC-629 public string PasteModel(LinkedList pasteModelList) { DataSet dsResult = _ws.ATTCopyModelInfo(pasteModelList.GetSerialData()); if (dsResult == null) { return(Definition.MSG_KEY_NO_PASTE_ITEM); } if (DSUtil.GetResultSucceed(dsResult) == 0) { return("FAIL"); } return("SUCCESS"); }
public DataSet QueryFrameWorkList() { DataSet ds = new DataSet(); try { ds = base.Query(SQL_QUERY_FRAMEWORK_LIST); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch { } return(ds); }
public DataSet QuerySubjectName() { DataSet ds = new DataSet(); try { ds = base.Query(SQL_QUERY_SUBJECT_NAME); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch (Exception ex) { } return(ds); }
public DataSet QueryViewEQPList(string sViewTableName) { DataSet ds = new DataSet(); try { string sSQL = string.Format(SQL_QUERY_VIEW_EQP_LIST, sViewTableName); ds = base.Query(sSQL); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch (Exception ex) { } return(ds); }
public DataSet QueryViewTableList() { DataSet ds = new DataSet(); try { LinkedList lklist = new LinkedList(); lklist.Add("PROPERTY_NAME", "TABLE"); //ds = base.Query(SQL_QUERY_VIEW_TABLE_LIST, lklist); ds = base.Query(SQL_QUERY_VIEW_TABLE_LIST, lklist); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch (Exception ex) { } return(ds); }
public DataSet QueryConfigPropertyList() { DataSet ds = new DataSet(); try { //LinkedList lklist = new LinkedList(); //lklist.Add("CONFIG_RAWID", CONFIG_RAWID); //ds = base.Query(SQL_QUERY_CONFIG_PROPERTY_LIST, lklist); ds = base.Query(SQL_QUERY_CONFIG_PROPERTY_LIST); if (DSUtil.GetResultSucceed(ds) == 0) { ds = new DataSet(); } } catch (Exception ex) { } return(ds); }
public DataSet CopyModelInfo(byte[] param) { DataSet dsReturn = null; try { spcModelData.ParentSQLHandler = this; LinkedList llstTotalConfigInfo = new LinkedList(); LinkedList llstParam = null; llstTotalConfigInfo.SetSerialData(param); ArrayList arrMainTargetRawid = new ArrayList(); ArrayList arrSubTargetRawid = new ArrayList(); base.BeginTrans(); for (int i = 0; i < llstTotalConfigInfo.Count; i++) { llstParam = (LinkedList)llstTotalConfigInfo[i]; string sUserID = llstParam[Definition.DynamicCondition_Condition_key.USER_ID].ToString(); string sourceConfigRawID = llstParam[Definition.COPY_MODEL.SOURCE_MODEL_CONFIG_RAWID].ToString(); string targetConfigRawID = llstParam[Definition.COPY_MODEL.TARGET_MODEL_CONFIG_RAWID].ToString(); string mainYN = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString(); if (mainYN == "Y") { arrMainTargetRawid.Add(targetConfigRawID); } else { arrSubTargetRawid.Add(targetConfigRawID); } bool hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString()); dsReturn = spcModelData.CopyModelInfo(llstParam); if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0) { this.RollBack(); return(dsReturn); } } //modified by enkim Gemini P3-3816 //string subConfigRawIDs = ""; //if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs) //{ // dsReturn = spcModelData.ModifySPCSubModelForCopy(llstParam, ref subConfigRawIDs); // if (subConfigRawIDs.Length > 0) // { // subConfigRawIDs = subConfigRawIDs.Substring(1); // } //} //modified end this.Commit(); if (arrMainTargetRawid.Count > 0) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, arrMainTargetRawid[0].ToString()); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "Y"); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); //수정했을 경우 Server로 변경에 대한 Inform을 준다. Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } if (arrSubTargetRawid.Count > 0) { string subConfigRawIDs = ""; for (int i = 0; i < arrSubTargetRawid.Count; i++) { subConfigRawIDs += ";" + arrSubTargetRawid[i].ToString(); } if (subConfigRawIDs.Length > 0) { subConfigRawIDs = subConfigRawIDs.Substring(1); LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, "N"); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); //수정했을 경우 Server로 변경에 대한 Inform을 준다. Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } } //modified by enkim Gemini P3-3816 //if (mainYN.Equals(Definition.VARIABLE_Y) && hasSubconfigs) //{ // llstCondition = new LinkedList(); // llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, subConfigRawIDs); // llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N); // llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update"); // //수정했을 경우 Server로 변경에 대한 Inform을 준다. // msgBussiness = new BISTel.eSPC.Business.Server.Interface.MsgInterfaceBusiness(); // msgBussiness.SetSPCModel(llstCondition.GetSerialData()); //} //modified end } catch (Exception ex) { BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); base.RollBack(); } finally { this.Close(); } return(dsReturn); }
public DataSet SaveSPCModelData(byte[] param) { string configRawID = ""; DataSet dsReturn = new DataSet(); bool _isGroup = false; string groupRawid = null; //SPC-1292, KBLEE, GroupRawId 정보 담는 변수 try { spcModelData.ParentSQLHandler = this; LinkedList llstParam = new LinkedList(); llstParam.SetSerialData(param); bool useComma = false; if (llstParam[Definition.VARIABLE_USE_COMMA] is bool) { useComma = (bool)llstParam[Definition.VARIABLE_USE_COMMA]; } string sUserID = llstParam[Definition.CONDITION_KEY_USER_ID].ToString(); BISTel.eSPC.Common.ConfigMode configMode = (BISTel.eSPC.Common.ConfigMode)llstParam[Definition.CONDITION_KEY_CONFIG_MODE]; DataTable dtModel = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_ATT_MST_SPC]; DataTable dtConfig = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONFIG_ATT_MST_SPC]; DataTable dtConfigOpt = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONFIG_OPT_ATT_MST_SPC]; DataTable dtContext = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_CONTEXT_ATT_MST_SPC]; DataTable dtRule = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_RULE_ATT_MST_SPC]; DataTable dtRuleOpt = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_RULE_OPT_ATT_MST_SPC]; DataTable dtAutoCalc = (DataTable)llstParam[BISTel.eSPC.Common.TABLE.MODEL_AUTOCALC_ATT_MST_SPC]; string _sMainYN = ""; string sConfigRawid = ""; string srefConfigRawid = ""; bool bOnlyMain = false; bool bOnlyMainGroup = false; if (llstParam[Definition.CONDITION_KEY_MAIN_YN] != null) { _sMainYN = llstParam[Definition.CONDITION_KEY_MAIN_YN].ToString(); } bool _hasSubconfigs = Convert.ToBoolean(llstParam[Definition.CONDITION_KEY_HAS_SUBCONFIG].ToString()); if (llstParam.Contains(BISTel.eSPC.Common.COLUMN.GROUP_YN)) { _isGroup = true; } if (llstParam.Contains(BISTel.eSPC.Common.COLUMN.GROUP_RAWID)) { groupRawid = llstParam[BISTel.eSPC.Common.COLUMN.GROUP_RAWID].ToString(); } base.BeginTrans(); switch (configMode) { case BISTel.eSPC.Common.ConfigMode.CREATE_MAIN: case BISTel.eSPC.Common.ConfigMode.SAVE_AS: dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma); break; case BISTel.eSPC.Common.ConfigMode.CREATE_SUB: dsReturn = spcModelData.CreateSPCModel(configMode, sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, ref srefConfigRawid, groupRawid, useComma); break; case BISTel.eSPC.Common.ConfigMode.MODIFY: case BISTel.eSPC.Common.ConfigMode.ROLLBACK: List <string> lstChangedMasterColList = (List <string>)llstParam["CHANGED_MASTER_COL_LIST"]; dsReturn = spcModelData.ModifySPCModel(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, lstChangedMasterColList, groupRawid, useComma); break; case BISTel.eSPC.Common.ConfigMode.DEFAULT: dsReturn = spcModelData.SaveDefaultConfig(sUserID, dtModel, dtConfig, dtConfigOpt, dtContext, dtRule, dtRuleOpt, dtAutoCalc, useComma); break; } if (base.ErrorMessage.Length > 0 || DSUtil.GetResultSucceed(dsReturn) == 0) { this.RollBack(); return(dsReturn); } if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) { configRawID = dtConfig.Rows[0][BISTel.eSPC.Common.COLUMN.RAWID].ToString(); } if ((configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs) { if (llstParam.Contains("ONLY_MAIN")) { if (llstParam["ONLY_MAIN"].ToString() == Definition.VARIABLE_Y) { bOnlyMain = true; } } if (llstParam.Contains("ONLY_MAIN_GROUP")) { if (llstParam["ONLY_MAIN_GROUP"].ToString() == Definition.VARIABLE_Y) { bOnlyMainGroup = true; } } if (!bOnlyMain) { dsReturn = spcModelData.ModifyATTSPCSubModel(configRawID, dtRule, dtRuleOpt, sUserID, ref sConfigRawid); if (sConfigRawid.Length > 0) { sConfigRawid = sConfigRawid.Substring(1); } } dsReturn = spcModelData.ModifyATTSPCSubModelContext(configRawID, dtContext, sUserID, bOnlyMainGroup, groupRawid); if (_isGroup) //기존 Sub 전체 삭제. { bool bResult = spcModelData.DeleteATTSPCModelConfig(sConfigRawid); if (!bResult) { base.RollBack(); } } } this.Commit(); // Increase version BISTel.eSPC.Data.Server.Common.CommonData commonData = new BISTel.eSPC.Data.Server.Common.CommonData(); switch (configMode) { case BISTel.eSPC.Common.ConfigMode.CREATE_MAIN: case BISTel.eSPC.Common.ConfigMode.SAVE_AS: case BISTel.eSPC.Common.ConfigMode.CREATE_SUB: this.BeginTrans(); foreach (string query in commonData.GetIncreaseATTVersionQuery(srefConfigRawid.ToString())) { this.Query(query); } this.Commit(); break; case BISTel.eSPC.Common.ConfigMode.MODIFY: case BISTel.eSPC.Common.ConfigMode.ROLLBACK: this.BeginTrans(); foreach (DataRow dr in dtConfig.Rows) { foreach (string query in commonData.GetIncreaseATTVersionQuery(dr[BISTel.eSPC.Common.COLUMN.RAWID].ToString())) { this.Query(query); } } if (!bOnlyMain && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs) { //modified by enkim 2012.05.18 SPC-739 //IncreaseVersionOfSubConfigs(sConfigRawid.Split(';')); //ATT// bool bResultTmp = spcModelData.IncreaseVersionOfSubConfigs(configRawID); /// ATT// //modified end SPC-739 } this.Commit(); break; } if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, configRawID); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, _sMainYN); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); //수정했을 경우 Server로 변경에 대한 Inform을 준다. Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } if ((configMode.Equals(BISTel.eSPC.Common.ConfigMode.MODIFY) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.ROLLBACK)) && _sMainYN.Equals(Definition.VARIABLE_Y) && _hasSubconfigs) { if (!_isGroup) { if (!bOnlyMain) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "update"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); //수정했을 경우 Server로 변경에 대한 Inform을 준다. Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } } else { if (!bOnlyMain) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, sConfigRawid); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "remove"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); //수정했을 경우 Server로 변경에 대한 Inform을 준다. Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } } } if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.CREATE_MAIN) || configMode.Equals(BISTel.eSPC.Common.ConfigMode.SAVE_AS)) { if (srefConfigRawid.Length > 0) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_Y); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } } if (configMode.Equals(BISTel.eSPC.Common.ConfigMode.CREATE_SUB)) { if (srefConfigRawid.Length > 0) { LinkedList llstCondition = new LinkedList(); llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, srefConfigRawid); llstCondition.Add(Definition.CONDITION_KEY_MAIN_YN, Definition.VARIABLE_N); llstCondition.Add(Definition.CONDITION_KEY_FUNCTION, "add"); llstCondition.Add(Definition.CONDITION_KEY_USER_ID, llstParam[BISTel.eSPC.Common.COLUMN.USER_ID].ToString()); Interface.MsgInterfaceBusiness msgBussiness = new BISTel.eSPC.Business.Server.ATT.Interface.MsgInterfaceBusiness(); msgBussiness.SetSPCModel(llstCondition.GetSerialData()); } } } catch (Exception ex) { BISTel.PeakPerformance.Client.CommonLibrary.LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); base.RollBack(); } finally { this.Close(); } return(dsReturn); }
public void BindToControl(Control control, DataSet ds, string sDisplayMember, string sValueMumber, bool bAll) { try { if (ds.Tables.Count > 0) { if (control is BISTel.PeakPerformance.Client.BISTelControl.BComboBox) { BISTel.PeakPerformance.Client.BISTelControl.BComboBox bComboBox = (BISTel.PeakPerformance.Client.BISTelControl.BComboBox)control; bComboBox.Items.Clear(); //if (bAll) // combo.Items.Add(Definition.VARIABLE_ALL); //ALL //else // combo.Items.Remove(Definition.VARIABLE_ALL); bComboBox.BeginUpdate(); if (sDisplayMember != "") bComboBox.DisplayMember = sDisplayMember; if (sValueMumber != "") bComboBox.ValueMember = sValueMumber; if (DSUtil.GetResultSucceed(ds) != 0) { bComboBox.DataSource = ds.Tables[0]; //for (int i = 0; i < ds.Tables[0].Rows.Count; i++) //{ // bComboBox.Items.Add(ds.Tables[0].Rows[i][0].ToString()); //} bComboBox.EndUpdate(); if (bComboBox.Items.Count > 0) { bComboBox.SelectedIndex = 0; } } else bComboBox.EndUpdate(); } else if (control is BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo) { BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo bCheckComboBox = (BISTel.PeakPerformance.Client.BISTelControl.BCheckCombo)control; bCheckComboBox.chkBox.Items.Clear(); bCheckComboBox.chkBox.BeginUpdate(); if (DSUtil.GetResultSucceed(ds) != 0) { ArrayList alItemList = new ArrayList(); string[] saItemList = new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { alItemList.Add(ds.Tables[0].Rows[i][sDisplayMember].ToString()); saItemList[i] = ds.Tables[0].Rows[i][sDisplayMember].ToString(); } if (sDisplayMember != "") bCheckComboBox.DisplayMember = sDisplayMember; if (sValueMumber != "") bCheckComboBox.ValueMember = sValueMumber; bCheckComboBox.DataSource = ds.Tables[0]; //string[] saItemList = (string[])alItemList.ToArray(typeof(string[])); //bCheckComboBox.AddItems(saItemList); bCheckComboBox.chkBox.EndUpdate(); bCheckComboBox.chkBox.SelectedIndex = 0; } else bCheckComboBox.chkBox.EndUpdate(); } else if (control is System.Windows.Forms.ListBox) { System.Windows.Forms.ListBox lstbox = (System.Windows.Forms.ListBox)control; lstbox.Items.Clear(); lstbox.BeginUpdate(); if (DSUtil.GetResultSucceed(ds) != 0) { ArrayList alItemList = new ArrayList(); string[] saItemList = new string[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { alItemList.Add(ds.Tables[0].Rows[i][sDisplayMember].ToString()); saItemList[i] = ds.Tables[0].Rows[i][sDisplayMember].ToString(); } ////string[] saItemList = (string[])alItemList.ToArray(typeof(string[])); //lstbox.Items.AddRange(saItemList); ////lstbox.DataSource = ds; if (sDisplayMember != "") lstbox.DisplayMember = sDisplayMember; if (sValueMumber != "") lstbox.ValueMember = sValueMumber; lstbox.DataSource = ds.Tables[0]; lstbox.EndUpdate(); } else lstbox.EndUpdate(); } } } catch (Exception ex) { throw ex; } }