See Also

SQLiteDataAdapter Members  | Devart.Data.SQLite Namespace  | SQLiteConnection Class  | SQLiteCommand Class

Language

Visual Basic

C#

Show All

See AlsoLanguagesDevart.Data.SQLiteSend comments on this topic.

SQLiteDataAdapter Class

Devart.Data.SQLite Namespace : SQLiteDataAdapter Class

Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQLite database.

For a list of all members of this type, see SQLiteDataAdapter members.

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DataAdapter
            System.Data.Common.DbDataAdapter
               Devart.Common.DbDataAdapter
                  Devart.Data.SQLite.SQLiteDataAdapter

Syntax

[Visual Basic]
Public Class SQLiteDataAdapter    Inherits DbDataAdapter
[C#]
public class SQLiteDataAdapter : DbDataAdapter

Remarks

The SQLiteDataAdapter serves as a bridge between a DataSet and database for retrieving and saving data. The SQLiteDataAdapter provides this bridge by using Fill to load data from the database into the DataSet, and using Update to send changes made in the DataSet back to the database.

SQLiteDataAdapter is used in conjunction with SQLiteConnection and SQLiteCommand to increase performance when connecting to a SQLite database.

The SQLiteDataAdapter also includes the SQLiteDataAdapter.SelectCommand, SQLiteDataAdapter.InsertCommand, SQLiteDataAdapter.DeleteCommand, SQLiteDataAdapter.UpdateCommand, and TableMappings properties to facilitate loading and updating of data.

Example

The following example demonstrates how to retrieve and manipulate data using SQLiteDataAdapter.

[C#] 

public void UseDataAdapter(SQLiteConnection sqConnection) 

  SQLiteDataAdapter myAdapter = new SQLiteDataAdapter("SELECT DeptNo, DName FROM Dept", sqConnection); 
  myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; 
  DataSet myDataSet = new DataSet(); 
  myAdapter.Fill(myDataSet,"Departments"); 
  object[] rowVals = new object[2]; 
  rowVals[0] = 40; 
  rowVals[1] = "Operations"; 
  myDataSet.Tables["Departments"].Rows.Add(rowVals); 
  myAdapter.InsertCommand = new SQLiteCommand("INSERT INTO Dept (DeptNo, DName) " + 
    "VALUES (:DeptNo, :DName)", sqConnection); 
  myAdapter.InsertCommand.Parameters.Add("DeptNo", SQLiteType.Int32, 0, "DeptNo"); 
  myAdapter.InsertCommand.Parameters.Add("DName", SQLiteType.Text, 15, "DName"); 
  myAdapter.Update(myDataSet,"Departments");  
  //Get all data from all tables within the dataset 
  foreach(DataTable myTable in myDataSet.Tables) 
  { 
    foreach(DataRow myRow in myTable.Rows) 
    { 
      foreach (DataColumn myColumn in myTable.Columns) 
      { 
        Console.Write(myRow[myColumn]+"\t"); 
      } 
      Console.WriteLine(); 
    } 
    Console.WriteLine(); 
  } 

[Visual Basic] 

Public Sub UseDataAdapter(ByVal sqConnection As SQLiteConnection)
  Dim myAdapter As SQLiteDataAdapter = New SQLiteDataAdapter("SELECT DeptNo, DName FROM Dept", sqConnection)
  myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
  Dim myDataSet As DataSet = New DataSet
  myAdapter.Fill(myDataSet, "Departments")
  Dim rowVals(1) As Object
  rowVals(0) = "40"
  rowVals(1) = "Operations"
  myDataSet.Tables("Departments").Rows.Add(rowVals)
  myAdapter.InsertCommand = New SQLiteCommand("INSERT INTO Dept (DeptNo, DName) " & _
      "VALUES (:DeptNo, :DName)", sqConnection)
  myAdapter.InsertCommand.Parameters.Add("DeptNo", SQLiteType.Int32, 0, "DeptNo")
  myAdapter.InsertCommand.Parameters.Add("DName", SQLiteType.Text, 15, "DName")
  myAdapter.Update(myDataSet, "Departments")
  Dim myTable As DataTable
  Dim myRow As DataRow
  Dim myColumn As DataColumn
  ' Get all data from all tables within the dataset
  For Each myTable In myDataSet.Tables
    For Each myRow In myTable.Rows
      For Each myColumn In myTable.Columns
        Console.Write(myRow(myColumn) & Chr(9))
      Next myColumn
      Console.WriteLine()
    Next myRow
    Console.WriteLine()
  Next myTable
End Sub

See Also

SQLiteDataAdapter Members  | Devart.Data.SQLite Namespace  | SQLiteConnection Class  | SQLiteCommand Class

 

 


© 2008 - 2014 Devart. All Rights Reserved.