public virtual int FillByWhereClause(AccountDataset.AccountsDataTable dataTable, string whereClause, System.Data.OleDb.OleDbParameter[] parameters)
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
command.Connection = this.Connection;
command.CommandText = @"select * from
(Select ""C-"" & CustomerID as ID, ""Customer"" AS CustomerSupplierFlag,
CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, '' as HomePage, CreateID, CreateUser, ModifyID, ModifyUser
from Customers
Union
Select ""S-"" & SupplierID as ID, ""Supplier"" AS CustomerSupplierFlag,
CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage, CreateID, CreateUser, ModifyID, ModifyUser
FROM Suppliers) as a "
+ whereClause + ";";
command.CommandType = System.Data.CommandType.Text;
if (null != parameters)
{
command.Parameters.AddRange(parameters);
}
this.Adapter.SelectCommand = command;
if ((this.ClearBeforeFill == true))
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return(returnValue);
}
public virtual AccountDataset.AccountsDataTable GetDataBy(string ID) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((ID == null)) {
throw new global::System.ArgumentNullException("ID");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(ID));
}
AccountDataset.AccountsDataTable dataTable = new AccountDataset.AccountsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual AccountDataset.AccountsDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
AccountDataset.AccountsDataTable dataTable = new AccountDataset.AccountsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
