DBCommand stmt = conn.CreateCommand(); 
stmt.CommandText = "select t1a1, t1a2 from table1 "; 
DBRowReader rs = stmt.ExecuteReader();
printResultSet( rs );
rs.Close(); 
stmt.CommandText = "select t2a1 from table2 "; 
rs = stmt.ExecuteReader();
printResultSet( rs );
rs.Close();
stmt.Close();

public void prepare_for_download(
	DateTime last_download,
	String ml_username)
{
	DBCommand cstmt = conn.CreateCommand(); 
	cstmt.CommandText = "call myProc( ?,?,?,? )"; 
	cstmt.Prepare(); 

	DBParameter param = new DBParameter();
	param.DbType          = SQLType.SQL_CHAR;
	param.Value           = "10000";
	cstmt.Parameters.Add( param ); 
	param                 = new DBParameter();
	param.DbType          = SQLType.SQL_INTEGER;
	param.Value           = 20000;
	cstmt.Parameters.Add( param ); 
	param                 = new DBParameter();
	param.DbType          = SQLType.SQL_DECIMAL;
	param.Precision       = 5;
	param.Value           = new Decimal( 30000 );
	cstmt.Parameters.Add( param ); 
	param                 = new DBParameter();
	param.DbType          = SQLType.SQL_TIMESTAMP;
	param.Precision       = 19;
	param.Value           = last_download;
	cstmt.Parameters.Add( param ); 

	// Execute update
	DBRowReader rset = cstmt.ExecuteNonQuery();
	cstmt.Close();
}