public void ExecutePagingStoredProcedureCount()
{
DataTable table = null;
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.PagingDatabase database = new Framework.DataServices.PagingDatabase(
CommonDatabase.ConnectionName, CommonDatabase.ConnectionString, CommonDatabase.ProviderName);
int total = database.GetCount(StoredProcedureCount,
"Users",
"Children > 0",
0,
2,
false,
CommonDatabase.CurrentUser,
out errorNumber,
out errorDescription);
}
public void ExecutePagingStoredProcedureWithDefaultParameters()
{
DataTable table = null;
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.PagingDatabase database = new Framework.DataServices.PagingDatabase(
CommonDatabase.ConnectionName, CommonDatabase.ConnectionString, CommonDatabase.ProviderName);
table = database.GetPage(StoredProcedurePageWithDefaultParameters,
"ID, FirstName, BirthDate",
"Users",
"Children > 0",
"FirstName",
0,
2,
true,
CommonDatabase.CurrentUser,
out errorNumber,
out errorDescription);
}
