private void loadItemCodeList() { //get keyword from text box string keywords = cmbItemName.Text; //check if the keywords has value or not if (!string.IsNullOrEmpty(keywords)) { //show item code at itemcode combobox based on keywords DataTable dt = dalItem.Search(keywords); cmbItemCode.DataSource = dt; cmbItemCode.DisplayMember = "item_code"; cmbItemCode.ValueMember = "item_code"; } else { cmbItemCode.DataSource = null; } }
private bool IfProductsExists(String productCode) { DataTable dt; if (cmbCat.Text.Equals("Part")) { dt = dalItem.Search(productCode); } else { dt = dalMaterial.codeSearch(productCode); } if (dt.Rows.Count > 0) { return(true); } else { return(false); } }