title: merging two datasets and display in one gridview
body: <p>I have two seperate databases from which I want to retrieve data and display in one grid view. The difficult I have is that I have a product key only in the table from the one database and the same set of product keys agains the actual products products in the other database and now I want to display the product data in one grid view....if this makes sense.</p>
  
  <p>How can I do this, merge the data and display the product data agains the keys in the one grid.</p>
  
  <pre><code>string connString = "Data Source=.\\SQLEXPRESS;Initial Catalog=LRVWebsite;user ID=sa;password=lrmg;";
  SqlConnection sqlCon;
  OleDbConnection conn;
  
  DataSet setOleDb;
  DataSet dsSql;
  private void bindData()
  {
      try
      {
          conn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;
                                  Data Source =" + Server.MapPath("App_Data\\LR Product Database 2000.mdb"));
          conn.Open();
  
          setOleDb = new DataSet();
          OleDbDataAdapter dbaOle = new OleDbDataAdapter("SELECT * FROM tblProducts", conn);
  
          dbaOle.Fill(setOleDb);
          sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["LRVWebsite"].ToString());
          sqlCon.Open();
          dsSql = new DataSet();
  
          SqlDataAdapter dba = new SqlDataAdapter(@"SELECT C.CustomerFirstName,C.CustomerLastName, C.CustomerCompany,C.CustomerPosition,C.CustomerCountry,C.CustomerProvince,C.CustomerContact,CP.ActionDate,CP.ProductCode,CP.CustomerEmail FROM tblCustomers C INNER JOIN tblCustomerProducts CP ON C.CustomerEmail = CP.CustomerEmail ORDER BY ActionDate DESC", connString);
          //@"SELECT C.CustomerFirstName,C.CustomerLastName,C.CustomerCompany,C.CustomerPosition,C.CustomerCountry,C.CustomerProvince,C.CustomerContact,CP.ActionDate,CP.ProductCode,CP.CustomerEmail FROM tblCustomers C INNER JOIN tblCustomerProducts CP ON C.CustomerEmail = CP.CustomerEmail ORDER BY ActionDate DESC", connString);
          dba.Fill(dsSql);
  
          dsSql.Merge(setOleDb);
  
          GridView1.DataSource = dsSql;
          GridView1.DataBind();
  
  
          sqlCon.Close();
  </code></pre>
  
  <p>This is what I have tried.Now, how can I get the product key to correlate with the actual product in the other table which contains the same product key?</p>