Member Avatar for samuel_1991
samuel_1991 0 Junior Poster in Training

Hi, I am currently doing an advanced search of a product.

It is such varies into 3 categories: Product Title / Description, Price and Product Specifications

I have called 3 datasets to check on each of these categories.

Now, for reason, when I merge these 3 dataset

dsPrice.Merge(dsKeyword)
        'Then Merge with specs 
        dsAll.Merge(dsPrice)

, I will get results that is in either one or 2 of them but not as across a whole where all 3 have a thing in common. How should I do it that to return a dataset that contains only data that are common to all 3 dataset? Thank you.

PS: For times when things are not applicable (E.g: User does not know the item's price and leaves it blank, it will check as a whole because I am afraid that a no search at all will result to a null dataset and crash.

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.