SQL Help

[jmcilhinney]

Depending on what you want to do, it is probably easier to load it into a data table and work with it that way.

var dt = new System.Data.DataTable();

dt.Load(dataReader);

foreach (var row in dt.Rows)
{
    var partnerName = row["partnername"].ToString();
    //... so on and so forth
}

I sure wish I'd thought of that three days ago. Oh, hang on... I did!