Exemplo n.º 1
0
 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);
 }
Exemplo n.º 2
0
        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);
        }