private void txtSupplierSearch_KeyUp(object sender, KeyEventArgs e) { currentProdId = Convert.ToInt32(lstProducts.SelectedValue); List <ProductSupplier> listps = ProductSupplierDB.SearchAllSuppliersForSelectedProduct(currentProdId, txtSupplierSearch.Text); var relatedSupplierName = from relatedSupplier in listps select new { Supplierid = relatedSupplier.SupplierID, SupplierName = relatedSupplier.SupplierName }; lstSuppliers.SelectedIndexChanged -= lstSuppliers_SelectedIndexChanged; lstSuppliers.DataSource = relatedSupplierName.ToList(); lstSuppliers.ValueMember = "Supplierid"; lstSuppliers.DisplayMember = "SupplierName"; lstSuppliers.SelectedIndex = -1; lstSuppliers.SelectedIndexChanged += lstSuppliers_SelectedIndexChanged; }
private void txtSupplierSearch_KeyUp(object sender, KeyEventArgs e) { currentProdId = Convert.ToInt32(lstProducts.SelectedValue); //Suppliers = SupplierDB.GetAllsuppliers(); List <ProductSupplier> listps = ProductSupplierDB.SearchAllSuppliersForSelectedProduct(currentProdId, txtSupplierSearch.Text); // var relatedSupplierName = from allsupplier in Suppliers//get each row in sUppliers TABle // where (from c in listps select c.SupplierID).Contains(allsupplier.SupplierId)// current row from currentPS doesnt included same // select new { Supplierid = allsupplier.SupplierId, SupplierName = allsupplier.SupName }; var relatedSupplierName = from relatedSupplier in listps select new { Supplierid = relatedSupplier.SupplierID, SupplierName = relatedSupplier.SupplierName }; lstSuppliers.SelectedIndexChanged -= lstSuppliers_SelectedIndexChanged; lstSuppliers.DataSource = relatedSupplierName.ToList(); lstSuppliers.ValueMember = "Supplierid"; lstSuppliers.DisplayMember = "SupplierName"; lstSuppliers.SelectedIndex = -1; lstSuppliers.SelectedIndexChanged += lstSuppliers_SelectedIndexChanged; }