public virtual int FillBySiteID(seriesCatalogDataSet.SeriesCatalogDataTable dataTable, global::System.Nullable<int> siteID) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((siteID.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[0].Value = ((int)(siteID.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(seriesCatalogDataSet.SeriesCatalogDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }