public virtual int FillByName(FullDataSet.ProductDataTable dataTable, string name) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((name == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(FullDataSet.SubstanceDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(FullDataSet.ProductDataTable dataTable, System.Nullable<bool> isnds) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((isnds.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((bool)(isnds.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;
 }