command class : Reader() method
Description
Executes the SQL statement.
Syntax
instance.Reader()
Arguments
None.
Return value
Class | Description |
dbreader | The 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. Returns multi-line results. |
5: | while(dbr.Read()) |
6: | ... // Execute something for each row of the result. |
7: | endwhile |
8: | dbr.Release(); |
9: | cmm.Release(); |
10: | cnn.Close(); |
11: | cnn.Release(); |
Notes
None.
Links for reference
None.