static public void PopulateByCommonSetting(ComboBox cbo, string groupID, bool fblank = false) { var cs = new CommonSetting(); var dtb = cs.SelectAllByGroupID(groupID); cbo.DataSource = null; cbo.ValueMember = "DetailID"; cbo.DisplayMember = "DetailDesc"; if (fblank) { dtb.Rows.Add("", ""); } dtb.DefaultView.Sort = "DetailID Asc"; cbo.DataSource = dtb; //if (fblank) //cbo.Items.Add(new ComboBoxItem("", "")); //foreach (DataRow row in dtb.Rows) //{ // cbo.Items.Add(new ComboBoxItem(row["DetailID"] + "", row["DetailDesc"] + "")); //} }
private void PopulateItemUnit() { var itemUnit = new CommonSetting(); var dtb = itemUnit.SelectAllByGroupID("StdItemUnit"); cboItemUnit.DisplayMember = "DetailDesc"; cboItemUnit.ValueMember = "DetailID"; cboItemUnit.DataSource = dtb; }
private void PopulateGrid() { grdChooseTransactionStatus.SuspendLayout(); grdChooseTransactionStatus.AutoGenerateColumns = false; var cs = new CommonSetting(); var dv = new DataView(cs.SelectAllByGroupID("STxnStatus")); dv.RowFilter = "DetailID in ('S','V')"; grdChooseTransactionStatus.DataSource = dv; grdChooseTransactionStatus.ResumeLayout(); }
static public string SelectOneByCommonSetting(string groupID) { var cs = new CommonSetting(); return(Common.ProcessNull.GetString(cs.SelectAllByGroupID(groupID).Rows[0]["DetailID"]) + ""); }