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; }