title: How Can I Fill Dataset with Values from 2 Tables with an Inner Join Query
body: <p>I have 2 tables 1Tbl_purchasemaster1 and 1Tbl_purchasesub1  and a query like: </p>
  
  <pre><code>SELECT  Tbl_PurchaseMaster.dtPurchaseDate,Tbl_PurchaseMaster.vaSupplierName,
      Tbl_PurchaseSub.vaItemCode,Tbl_PurchaseSub.intQuantity 
  FROM Tbl_PurchaseMaster 
  INNER JOIN Tbl_PurchaseSub 
  ON 
  dbo.Tbl_PurchaseMaster.intPurchaseMasterID = dbo.Tbl_PurchaseSub.intPurchaseMasterID 
  where dtPurchaseDate between  '" + dtfr + "'and'" + dtto 
      + "' dtfr=datefrom and dtto=dateto..
  </code></pre>
  
  <p>How can I fill these values into Dataset? After filling it, I want to show it in Crystal Reports. please help</p>