dotConnect for SQLite Documentation
Devart.Common Namespace / SqlStatement Class
Members Example

On this page
    SqlStatement Class
    On this page
    Represents a single statement in a script.
    Syntax
    'Declaration
     
    Public Class SqlStatement 
    public class SqlStatement 
    Remarks

    Use SqlStatement to execute individual statements in a script. Each SqlStatement object contains SQL text and information about location of statement in the whole script.

    SqlStatement object can be obtained through DbScript.Statements collection. After originating ScriptText has been modified any obsolete SqlStatement objects can no longer be used.

    Example
    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()
    Inheritance Hierarchy

    System.Object
       Devart.Common.SqlStatement

    See Also