.net多語言和資料集內多資料表的處理(3) (轉)

  好了，我們知道了需求，然後該怎麼做呢？看下面的程式碼：   在從資料庫獲取資料時： public AddressData GetAddress(string languageCode)   {   AddressData ds = new AddressData();     DataAdapter DARegion = new SqlDataAdapter(AddressSQL.strGetRegion,SQLConfig.DataBaseConnection);   DARegion.Fill(ds.Region);     SqlDataAdapter DACountry = new SqlDataAdapter(AddressSQL.strGetCountry,SQLConfig.DataBaseConnection);   DACountry.Fill(ds.Country);     SqlDataAdapter DAProvince = new SqlDataAdapter(AddressSQL.strGetProvince,SQLConfig.DataBaseConnection);   DAProvince.Fill(ds.Province);     SqlDataAdapter DACity = new SqlDataAdapter(AddressSQL.strGetCity,SQLConfig.DataBaseConnection);   DACity.Fill(ds.City);     SqlDataAdapter DAPort = new SqlDataAdapter(AddressSQL.strGetPort,SQLConfig.DataBaseConnection);   DAPort.Fill(ds.Port);     RegionTypeData regionTypeDS =  GetRegionType(languageCode);     foreach ( AddressData.RegionRow region in ds.Region)   {   if (!region.IsNameGuidNull())   {   region.Name = DisplayString.GetDisplay(region.NameGuid,languageCode,vDisplayTable);   }   if (regionTypeDS.RegionType.FindByRegionTypeID(region.RegionTypeID) != null)   {   region.RegionTypeName = regionTypeDS.RegionType.FindByRegionTypeID(region.RegionTypeID).Abbr;   }   }     foreach ( AddressData.CountryRow country in ds.Country)   {   if (!country.IsNameGuidNull())   {   country.Name = DBDisplayString.GetDisplay(country.NameGuid,languageCode,vDisplayTable);   }   }     foreach (AddressData.ProvinceRow province in ds.Province)   {   if (!province.IsNameGuidNull())   {   province.Name = DBDisplayString.GetDisplay(province.NameGuid,languageCode,vDisplayTable);   }   }     foreach (AddressData.CityRow city in ds.City)   {   if (!city.IsNameGuidNull())   {   city.Name = DBDisplayString.GetDisplay(city.NameGuid, languageCode,vDisplayTable);   }   }     foreach (AddressData.PortRow port in ds.Port)   {   if (!port.IsNameGuidNull())   {   port.Name = DBDisplayString.GetDisplay(port.NameGuid,languageCode,vDisplayTable);   }   }     return ds;