CDATA ADO Connection with Crystal Reports not showing data

Question

I have VS2015 solution with Crystal Reports and CData Ado.net connection for the dataset. I have followed the instructions but my crystal report has three tables with two linked tables. The report fires and works with just the primary table but when i add the additional two tables the report does not work any more. I have tried inner join and left outer join on the crystal reports.

My code looks like this:

{
                SmartsheetDataAdapter dataAdapter = new SmartsheetDataAdapter(
                "SELECT * FROM Sheet_TempOrders", connection);
                DataSet set = new DataSet("_set");
                DataTable table = set.Tables.Add("_table");
                dataAdapter.Fill(table);
                report.SetDataSource(table);

                SmartsheetDataAdapter dataAdapter1 = new SmartsheetDataAdapter(
                "SELECT * FROM Sheet_Suppliers", connection);
                DataSet set1 = new DataSet("_set1");
                DataTable table1 = set1.Tables.Add("_table1");
                dataAdapter.Fill(table1);
                report.SetDataSource(table1);

                SmartsheetDataAdapter dataAdapter2 = new SmartsheetDataAdapter(
                "SELECT * FROM Sheet_Project", connection);
                DataSet set2 = new DataSet("_set2");
                DataTable table2 = set2.Tables.Add("_table2");
                dataAdapter.Fill(table2);
                report.SetDataSource(table2);

            }

TempOrders is the primary table. Any ideas on this?