public virtual ValuesDataSet.DataValuesDataTable GetDataBySiteIdVariableIDBetweenDates(int SiteID, int VariableID, System.DateTime BeingDate, System.DateTime EndDate) { this.Adapter.SelectCommand = this.CommandCollection[3]; this.Adapter.SelectCommand.Parameters[0].Value = ((int)(SiteID)); this.Adapter.SelectCommand.Parameters[1].Value = ((int)(VariableID)); this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(BeingDate)); this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(EndDate)); ValuesDataSet.DataValuesDataTable dataTable = new ValuesDataSet.DataValuesDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual ValuesDataSet.DataValuesDataTable GetDataBySiteIDVariableID(int SiteID, int VariableID) { this.Adapter.SelectCommand = this.CommandCollection[2]; this.Adapter.SelectCommand.Parameters[0].Value = ((int)(SiteID)); this.Adapter.SelectCommand.Parameters[1].Value = ((int)(VariableID)); ValuesDataSet.DataValuesDataTable dataTable = new ValuesDataSet.DataValuesDataTable(); this.Adapter.Fill(dataTable); return dataTable; }