Having done all this untyped and with a lot of typing in the past, I'm
trying to make efficient use of table adapters instead of data adapters. I
understand that it's just a wrapper. But what I don't understand is how
providing multiple fill methods gains me anything. For example, I want to
pull both the phone number and the fax number for a particular contact. The
value of both come from the PhoneNumber column in the PhoneNumbers table and
the select differs only in their phone type. So I set up two fill methods to
retrieve. However, clearly the datatable now contains ONLY the second fill.
I don't see how this gains anything in terms of usability -- I may as well
set up a second datatable in the dataset just for the fax numbers, and set
up a separate fill there.
this.phoneNumbersTableAdapter.FillOfficePhone(this.dsBrands.PhoneNumbers,
_intContactID);
if (dsBrands.PhoneNumbers.Rows.Count > 0)
{
dsBrands.PhoneNumbersRow rowPhone = dsBrands.PhoneNumbers[0];
if (!rowPhone.IsPhoneNumberNull())
{ txtPhone.Text = rowPhone.PhoneNumber; }
}
// this fill would now overwrite the contents of the PhoneNumbers datatable
this.phoneNumbersTableAdapter.FillFaxNumber(this.dsBrands.PhoneNumbers,
_intContactID);
...