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;
}
