Hi all... I am using northwind database..... I am working on Orders table.... I want to get the Customer of the year for each year.... by customer of the year I mean customer who placed top no of orders each year.... an I want to get this data for all years......
I have tried alot... please help me how to get this done....
thanks in advance....
Loading
Prabhu RajaPosted Sep 9, 2011, 11:08 PM
Mahesh ChandPosted Sep 9, 2011, 10:48 PM
Ali, Your signatures are too distracting. May be you want to make them simpler.
Sam HobbsPosted Sep 9, 2011, 2:29 PM
What type of application (WPF, Windows Forms or something else) did you create?
How are you going to access the database? Assuming you will use ADO .Net, you can create a data source which will create a typed dataset, called a TableAdapter. Or you can use an Entity. Or you can write all the ADO .Net code yourself using SqlConnection and related classes.