DatabaseDBCount Method (String, String, String)

Returns the number of items in the specified column and table using the SQL WHERE clause supplied. Note: For improved performance use DBExists(String, String) when possible.

Namespace: NetQuarry
Assembly: EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)

Syntax

Copy

public int DBCount(
	string column,
	string table,
	string where
)

Public Function DBCount ( 
	column As String,
	table As String,
	where As String
) As Integer

Parameters

column: Type: SystemString
The name of the column from which to retrieve the value.
table: Type: SystemString
The name of the table from which to retrieve the value.
where: Type: SystemString
Filter criteria for which records to retrieve.

Return Value

Type: Int32
The number of matching records.

Implements

IDatabaseDBCount(String, String, String)

Examples

Copy

// Lookup the first customer with a CompanyName that starts with Alfreds and print the value
object    val = db.DBLookup("CompanyName", "Customers", "CompanyName LIKE 'Alfreds%'");        
Console.WriteLine(val.ToString());

// Write the number of customers
Console.WriteLine(db.DBCount("*", "Customers", ""));

Reference

DatabaseAddLanguageSpecificTextSet("LST5C3E174B_0?cpp=::|nu=.");DBCount Method (String, String, String)

Parameters

Return Value

Implements

Reference

DatabaseDBCount Method (String, String, String)