Hi all... I am using northwind database

Question

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....

Prabhu Raja · Answer

Hi Ali you need solution for Back-end or Front-end ? Give some code from your program

Mahesh Chand · Answer

Good points Sam. Ali Your signatures are too distracting. May be you want to make them simpler.

Sam Hobbs · Answer

Have you looked at the articles in this web site? 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.