This method returns the total number of rows in the result set


Namespace: rocketsoftware.MVSP
Assembly: RocketMVSP (in RocketMVSP.dll)

Syntax

Visual Basic (Declaration)
Public Function MVResultSetGetRowCount() As Integer
C#
public int MVResultSetGetRowCount()
C++
public:
 int MVResultSetGetRowCount() sealed 
J#
public int MVResultSetGetRowCount()
JScript
public  function MVResultSetGetRowCount() : int

Return Value

An integer containing the number of rows in the result set

Remarks



Example connects and executes a query to retrieve contactname and city from the CUSTOMERS file and gets the total row count.

 Copy Code
 Dim returncode as boolean
 Dim mvsp as new rocketsoftware.MVSP.Pick
 Dim rowcount as integer
 returncode = mvsp.Connect("localhost",9000,"dm","")
 If returncode = True then
    returncode = mvsp.Logto("MVDEMO","")
    If returncode = True then
       mvsp.ExecuteQuery("QUERY", "CUSTOMERS", "", "", "CONTACTNAME CITY", "")
       rowcount = mvsp.MVResultSetGetRowCount
       Msgbox("Total row count is: " & rowcount)
    End if
 End if
 returncode = mvsp.CloseConnection()
 

See Also