SqlStatementCollection Class
Represents collection of statements that constitute SQLite script.
This sample shows how to retrieve collection of statements that make up the script and execute them one by one.
|
|---|
string script =
"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);
SqlStatementCollection sqLiteColl = sqLiteScript.Statements;
IDataReader sqLiteReader;
sqLiteConn.Open();
foreach (SqlStatement sqLiteStatement in sqLiteColl)
{
Console.WriteLine(sqLiteStatement.Text);
try
{
sqLiteReader = sqLiteStatement.Execute();
Console.WriteLine(" Records affected " + sqLiteReader.RecordsAffected);
while (sqLiteReader.Read())
{
Console.WriteLine(sqLiteReader.GetString(0));
}
sqLiteReader.Close();
Console.WriteLine();
}
catch
{
Console.WriteLine(" Failed");
}
}
sqLiteConn.Close(); |
|
|---|
Dim script As String = _
"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 sqLiteColl As SqlStatementCollection = sqLiteScript.Statements
Dim sqLiteReader As IDataReader
sqLiteConn.Open()
For Each sqLiteStatement As SqlStatement In sqLiteColl
Console.WriteLine(sqLiteStatement.Text)
Try
sqLiteReader = sqLiteStatement.Execute()
Console.WriteLine(" Records affected " & sqLiteReader.RecordsAffected)
While sqLiteReader.Read()
Console.WriteLine(sqLiteReader.GetString(0))
End While
sqLiteReader.Close()
Console.WriteLine()
Catch ex As Exception
Console.WriteLine(" Failed")
End Try
Next sqLiteStatement
sqLiteConn.Close() |