C#/SQL2005 Project

[Luke Davis]

I've been programming in C# for about 3 months now and I've completed a
previous project that worked a lot with data, so I know the basics.

This is what I need to do, try and see what you would do as an expert C#
programmer. I have to make a paired sales analysis which takes the same
home sold twice in a given time span and show how the price has changed to
show true market conditions.

Right now we have 120,000 rows of data that have basic home information like
so:

Table Name = Properties
Columns:
APN / Address / Bedrooms / Bathrooms / Selling Price / Zip Code / SQFT /
Selling Date / MLS Number

APN is unique to the property, but the MLS Number is unique to the database.
So if a house sells twice in the last year, it'll have two MLS Numbers, but
only one APN. I need to take all homes (APN's) that have sold more than
once (they appear twice in the database) and do some math and put it into a
GridView perhaps that looks like this:

Columns:
APN / Address / Date1 / Price$1 / Date2 / Price$2 / PriceChange$ /
TimeChange / ChangeOverTime

I need to take the address from the first entry in the database, then take
the date and price from the first entry, and the date and price from the
second entry, then do Price1 - Price2 and put that into PriceChange$, then
do the same for Date1 - Date2 for TimeChange, and finally do
(PriceChange/TimeChange) / Price1 and put that into ChangeOverTime. Then
there needs to be a column average for PriceChange$, TimeChange, and
ChangeOverTime, and they need to be loaded into variables that I can put
outside the gridview.

Alright, now I hope you might know why I came to the board for help. I'm
not really sure how to pull from different rows of a database and place them
into the same row of a table, gridview, etc.
--
Luke Davis, MCSE: Security
DEM Networks - Senior Systems Architect
7225 N First, Suite 105
Fresno, CA 93720
Office: 1 [phone]
Fax: [phone]
www.demnetworks.com