ExecuteNext(IDataReader) Method
On this page
Executes the next statement from the script.
Syntax
Parameters
- reader
- DbDataReaderBase to store result set.
Return Value
true if there are more statements to execute; otherwise, false.
Example
This sample demonstrates how to execute script and retrieve information about how many records were affected by a statement. For statements that return a result set the first column is written to console.
|
|---|
string script =
@"CREATE TABLE DEPT (
DEPTNO INTEGER PRIMARY KEY,
DNAME VARCHAR(14),
LOC VARCHAR(13)
);"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
SQLiteConnection sqLiteConn = new SQLiteConnection(
"DataSource=mydatabase.db;");
SQLiteScript sqLiteScript = new SQLiteScript(script,sqLiteConn);
IDataReader sqLiteReader;
sqLiteConn.Open();
while (sqLiteScript.ExecuteNext(out sqLiteReader))
{
Console.WriteLine("Records affected " + sqLiteReader.RecordsAffected);
while (sqLiteReader.Read())
{
Console.WriteLine(sqLiteReader.GetString(0));
}
sqLiteReader.Close();
}
sqLiteConn.Close(); |
|
|---|
Dim script As String = _
@"CREATE TABLE DEPT (" & _
" DEPTNO INTEGER PRIMARY KEY," & _
" DNAME VARCHAR(14)," & _
" LOC VARCHAR(13)" & _
");" & _
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');" & _
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');" & _
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');" & _
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');" & _
"SELECT * FROM DEPT"
Dim sqLiteConn As SQLiteConnection = New SQLiteConnection( _
"DataSource=mydatabase.db;")
Dim sqLiteScript As SQLiteScript = New SQLiteScript(script, sqLiteConn)
Dim sqLiteReader As IDataReader
sqLiteConn.Open()
While (sqLiteScript.ExecuteNext(sqLiteReader))
Console.WriteLine("Records affected " & sqLiteReader.RecordsAffected)
While sqLiteReader.Read()
Console.WriteLine(sqLiteReader.GetString(0))
End While
sqLiteReader.Close()
End While
sqLiteConn.Close() |
See Also