The first code example on this page shows how you can get a single abuse report from the system database based on its ID.
// Get abuse report as an info object by AbuseReportID
AbuseReportInfo ari = AbuseReportInfoProvider.GetAbuseReportInfo(1);
The following code example shows how you can get a DataSet with multiple abuse reports. As you can see, two overrides of the GetAbuseReports method are used here. The first one gets the abuse reports based on the WHERE condition and ordered by the ORDER BY part of the SQL query. The second one does the same, while it also selects only the particular columns and retrieves only top N records (based on the order specified by the second parameter).
// Set the WHERE condition
string where = "ReportStatus = 1";
// Set the ORDER BY clause
string orderBy = "ReportWhen DESC";
// Set the colums to select
string columns = "ReportID, ReportTitle, ReportURL, ReportComment, ReportStatus";
// Set the number of rows to select
int topN = 10;
// Get a DataSet of abuse report info objects according to the given parameters
DataSet ds = AbuseReportInfoProvider.GetAbuseReports(where, orderBy);
DataSet ds2 = AbuseReportInfoProvider.GetAbuseReports(where, orderBy, columns, topN);