public virtual int Fill(siteInfoDataSet.SpatialReferencesDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBySiteCode(siteInfoDataSet.sitesDataTable dataTable, string SiteCode) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((SiteCode == null)) {
         throw new global::System.ArgumentNullException("SiteCode");
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(SiteCode));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBySiteID(siteInfoDataSet.sitesDataTable dataTable, int siteID) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(siteID));
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByBox(siteInfoDataSet.sitesDataTable dataTable, double SOUTH, double NORTH, double WEST, double EAST) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     this.Adapter.SelectCommand.Parameters[0].Value = ((double)(SOUTH));
     this.Adapter.SelectCommand.Parameters[1].Value = ((double)(NORTH));
     this.Adapter.SelectCommand.Parameters[2].Value = ((double)(WEST));
     this.Adapter.SelectCommand.Parameters[3].Value = ((double)(EAST));
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }