Home Notices Documents Classes Download Others Rice
Classes  >  command  >  Reader()
command class : Reader() method

Description

Executes the SQL statement.

Syntax

commandInstance.Reader()

Arguments

None.

Return value

ClassDescription
dbreaderThe result set.

Sample code

1:

connection cnn = new connection("Data Source=c:\somedirectory\somedatabase.sqlite3;Version=3;");

2:

cnn.Open();

3:

command cmm = new command("select * from sometable where id < 100;", cnn);

4:

dbreader dbr = cmm.Reader(); // Command execution. A multi-line result is returned.

5:

while(dbr.Read())

6:

... // Performs a some processing on each row of results.

7:

endwhile

8:

dbr.Release();

9:

cmm.Release();

10:

cnn.Close();

11:

cnn.Release();

Notes

Multi-line results are returned as dbreader class.

Links for reference

None.

Copyright © Rice All rights reserved.