I added a new query to a table adapter in a DataSet. This query adds another field to the query whcih is a sum from another table. Here is the full query:

SELECT (SELECT COUNT(donationID) AS Expr1 FROM Donations AS da WHERE (dn.donorID = donorID)) AS Count, Solicitor, address1, address2, city, companyName, country, donorID, email, first, last, phoneHome, phoneMobile, phoneWork, state, webURL, zip, (select sum(amount) from Donations as dna where dna.donorID = dn.donorID) as SumDonations 
FROM Donors AS dn order by last

The new field is represented in the last part of the query:

(select sum(amount) from Donations as dna where dna.donorID = dn.donorID) as SumDonations

I can preview the data in the xsd but the last field "SumDonations" is not showing up as a field I can add to my gridview. I rebuilt the website but no luck. What am I missing?