SQL Help

[wakawaka]

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
}