Display rdlc report with more than one dataset -c#

Question

I have a desktop app (winforms) with an embedded Local Database SQL CE .

I have 2 tables in my database: Customers and Orders.

In Customers table I have : customerID , customerName.

In Orders table I have : CustomerID , OrderID, OrderName.

I want to display a report with : CustomerID , CustomerName , OrderName.

How can I get the value for customerName that matches the customerID in ordersTable.

Any help would be appriciated.

EdwardB EdwardB · Accepted Answer · 2014-08-10T11:55:12

SELECT Customers.CustomerID, Customers.CustomersName, Orders.OrderName
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID=Orders.CustomerID;