private void FillItemCode() { DrpItemDescription.Items.Clear(); // DDLMaterialCode.Items.Add("Select..."); if (drpItemCategory.Text == "Select..." && drpItemCode.Text == "Select..." || drpItemCode.Text == "") { strQuery = "select distinct(ItemId) as Product_Code,concat([ITEMID],' - ',Product_Name) as Product_Name from ax.INVENTTABLE where PRODUCT_GROUP ='POP' and BLOCK=0 order by Product_Name"; DrpItemDescription.Items.Clear(); DrpItemDescription.Items.Add("Select..."); baseObj.BindToDropDown(DrpItemDescription, strQuery, "Product_Name", "Product_Code"); DrpItemDescription.Focus(); } }
protected void drpItemCode_SelectedIndexChanged(object sender, EventArgs e) { strQuery = "Select distinct P.ITEMID+'-'+P.Product_Name as Name,P.ITEMID from ax.InventTable P where Product_Group='POP' AND P.BLOCK=0 and P.PRODUCT_SUBCATEGORY ='" + drpItemCode.SelectedItem.Value + "'"; //--AND SITE_CODE='657546'"; DrpItemDescription.DataSource = null; DrpItemDescription.Items.Clear(); //DDLMaterialCode.Items.Add("Select..."); baseObj.BindToDropDown(DrpItemDescription, strQuery, "Name", "ITEMID"); DrpItemDescription.Items.Add("Select..."); // txtAvailableQuantity.Text = string.Empty; txtRemark.Text = string.Empty; txtQTYPcs.Text = string.Empty; DrpItemDescription.Enabled = true; //DDLMaterialCode.SelectedIndex = 0; //DDLMaterialCode_SelectedIndexChanged(sender, e); DrpItemDescription.Focus(); if (DrpItemDescription.SelectedItem.Text != "Select...") { DrpItemDescription_SelectedIndexChanged(null, null); } }