public virtual int FillBy(NorthwindDataSet.CustomersDataTable dataTable, string customer) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((customer == null)) {
         throw new System.ArgumentNullException("customer");
     }
     else {
         this.Adapter.SelectCommand.Parameters[0].Value = ((string)(customer));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(NorthwindDataSet.OrdersDataTable 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(NorthwindDataSet.SalesByCategoryDataTable dataTable, string CategoryName, string OrdYear) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((CategoryName == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(CategoryName));
     }
     if ((OrdYear == null)) {
         this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(OrdYear));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(NorthwindDataSet.Sales_by_YearDataTable dataTable, System.Nullable<System.DateTime> Beginning_Date, System.Nullable<System.DateTime> Ending_Date) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((Beginning_Date.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(Beginning_Date.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     if ((Ending_Date.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(Ending_Date.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(NorthwindDataSet.CustOrdersOrdersDataTable dataTable, string CustomerID) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((CustomerID == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(CustomerID));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(NorthwindDataSet.CustOrdersDetailDataTable dataTable, System.Nullable<int> OrderID) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((OrderID.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(OrderID.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;
 }
 public virtual int Fill(NorthwindDataSet.Products_Above_Average_PriceDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }