Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » MobiLink - Server Administration » MobiLink Server APIs » Writing synchronization scripts in .NET » MobiLink server API for .NET reference

 

DBRowReader interface

Syntax
interface DBRowReader
Member of iAnywhere.MobiLink.Script
Remarks

Represents a set of rows being read from a database. Executing the method DBCommand.executeReader( ) creates a DBRowReader.

The following example is a C# code fragment. It calls a function with the rows in the result set represented by the given DBRowReader.

DBCommand stmt = conn.CreateCommand(); 
stmt.CommandText = "select intCol, strCol from table1 "; 
DBRowReader rset = stmt.ExecuteReader();
object[] values = rset.NextRow(); 
while( values != null ) {
handleRow( (int)values[0], (String)values[1] );
 values = rset.NextRow();
}
rset.Close();
stmt.Close();

NextRow method
Close method
ColumnNames property
ColumnTypes property