public void SearchAvailableProducts(int stateid, string productid, string productname) { client = new SQSAdminServiceClient(); client.Endpoint.Address = new System.ServiceModel.EndpointAddress(CommonVariables.WcfEndpoint); DataSet ds = client.SQSAdmin_StudioM_GetStudioMProduct(stateid, productid, productname); AvailableProduct.Clear(); foreach (DataRow dr in ds.Tables[0].Rows) { Product p = new Product(); p.ProductID = dr["productid"].ToString(); p.ProductName = dr["productname"].ToString(); //p.ProductDescription = dr["productdescription"].ToString(); bool exists = false; foreach (Product prod in SelectedProduct) { if (p.ProductID == prod.ProductID) { exists = true; break; } } if (!exists) { AvailableProduct.Add(p); } } }