[RESOLVED] Group sum from Db
Afternoon,
I'm sure there must be a way to do this but my database skills through C# aren't particular great so hoping someone can help with where I need to start looking.
I have a database which is used to record sales orders from multiple agents. Several Products can be of the same type. What I need to do is find a way of selecting just the products sold by an agent (which I can determine), grouped by Product and for a given sales date and getting the group value for each product.
I have attached a pic of the basic layout of my data to hopefully explain it a bit better.
Basically I just need to know, say, what Jack sold for a given date as a total for each product so I would end up with a total for Ink, Labels, etc.
Once I've retrieved that information I would then like to store it somewhere, perhaps in TextBoxes.
This solution is to replace my current method of using GridViews to store the information and filter and group it out and then populate TextBoxes with a grouping event as I believe it will give less overhead to my project and simplify things.
Many thanks in advanced!
Reply With Quote