public virtual ItemsDataSet.ItemsDataTable GetData(System.Nullable <short> memberId) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((memberId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((short)(memberId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } ItemsDataSet.ItemsDataTable dataTable = new ItemsDataSet.ItemsDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(ItemsDataSet.ItemsDataTable dataTable, System.Nullable <short> memberId) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((memberId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((short)(memberId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value; } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return(returnValue); }