Hello fellow experts,
This is one problem I'm trying to solve to help my brother, but I'm out of ideas since I'm new to C#. He is trying to learn something and I'm trying to help him but with not much luck for now. I can only apply logic from another languages but obviously that's not enough.
We are talking about famous Northwind database in SQL server.
Here is the thing, in one form there is one combobox with the list of last names from table Employees and two date fields where you can select date range.
He wants to create Report, not Crystal one. In report he wants to display:
To sum it all, he wants to display every single order which is associated with selected employee and within selected date range.
What he managed to do is to create dataset with these tables and associated relations: Orders, Customers, Products and Order Details.
Initially, I thought it is possible to create dataset and fill it with data from SQL query which would get all required data. However, while I browsed through examples on the internet I realized he needs to use foreach loops and that is the point where Im stumped.
Im sure that some of you find this easy, but since this is not my area of expertise I am not able to help my brother which is beginner in C#.
I hope that someone will be able to help us here.
Thanks in advance for any help.