[suburbancowboy]

I am having a problem pulling data into this foreach statement. the project builds like this with no errors however my calculation shows up as 0. there is data in that table but i seem to be missing something.

how can i use the tripsTableAdapter in the foreach statement? i am a newbie to this as well.
lines 8, 9, 12 seem to be where im missing something.

            this.settlementCurrentTableAdapter.Fill(this.myLeaseDataSet.SettlementCurrent, @todayIsDB);
            MyLeaseDataSet.SettlementCurrentRow settlementCurrent;
            settlementCurrent = myLeaseDataSet.SettlementCurrent.Last();

            var @settlementCurrentID = settlementCurrent.setID;

            this.tripsTableAdapter.FillByTripSetID(this.myLeaseDataSet.Trips, @settlementCurrentID);
            MyLeaseDataSet.TripsDataTable settlementTrips;
            settlementTrips = myLeaseDataSet.Trips;

            var totalLoadedMiles = 0;
            foreach (DataRow row in this.myLeaseDataSet.Trips.Rows)
            {

                totalLoadedMiles += int.Parse(row["tripLoadedMiles"].ToString());
            }
            
            labelWelcomeSetTotalMiles.Text = totalLoadedMiles.ToString();           

[Martyr2]

Well first of all, have you tried putting a break point on the foreach and stepping through it to see what "row" get set to and if "tripLoadedMiles" even has a legit value? If it doesn't, then you can break on line 8 and see if the tripsTableAdapter is holding the right values.

This is one of those problems where a simple debug session could tell you lots about what is going on.