This method returns the entire result set as an arraylist


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

Syntax

Visual Basic (Declaration)
Public Function MVResultSetGetRows() As ArrayList
C#
public ArrayList MVResultSetGetRows()
C++
public:
 ArrayList MVResultSetGetRows() sealed 
J#
public ArrayList MVResultSetGetRows()
JScript
public  function MVResultSetGetRows() : ArrayList

Return Value

An arraylist containing the entire 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 myArray as arraylist
 returncode = mvsp.Connect("localhost",9000,"dm","")
 If returncode = True then
    returncode = mvsp.Logto("MVDEMO","")
    If returncode = True then
       mvsp.ExecuteQuery("QUERY", "CUSTOMERS", "", "", "CONTACTNAME CITY", "")
       myArray = mvsp.MVResultSetGetRows ' Copy the entire result set into myArray
    End if
 End if
 returncode = mvsp.CloseConnection()
 

See Also