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; }