Represents an in-memory cache of data with connected model support.
This sample shows how to use DbDataSet. The routine accepts DbDataSet-compatible object and connection string. After
Devart.Data.SQLite.SQLiteDataTables were created and populated, they were added to DataTableCollection of DbDataSet, and DataRelation was created to link tables.
|
|---|
pubic void FillDataSet(DbDataSet dataSet, string connStr) {
// retrieving data from DEPT table
SQLiteDataTable dept = new SQLiteDataTable("select * from dept", connStr);
dept.FetchAll = true;
dept.Active = true;
// retrieving data from EMP table
SQLiteDataTable emp = new SQLiteDataTable("select * from emp", connStr);
emp.FetchAll = true;
emp.Active = true;
// adding data tables to SQLiteDataSet
dataSet.Tables.Add(dept);
dataSet.Tables.Add(emp);
// linking tables to allow navigation from parent table rows
// to corresponding child table rows
DataColumn parentColumn = dataSet.Tables["DEPT"].Columns["DEPTNO"];
DataColumn childColumn = dataSet.Tables["EMP"].Columns["DEPTNO"];
DataRelation relation = new System.Data.DataRelation("DeptsEmps",
parentColumn, childColumn);
dataSet.Relations.Add(relation);
} |
|
|---|
Public Sub FillDataSet(ByRef dataSet As DbDataSet, ByVal connStr As String)
' retrieving data from DEPT table
Dim dept As New SQLiteDataTable("select * from dept", connStr)
dept.FetchAll = True
dept.Active = True
' retrieving data from EMP table
Dim emp As New SQLiteDataTable("select * from emp", connStr)
emp.FetchAll = True
emp.Active = True
' adding data tables to SQLiteDataSet
dataSet.Tables.Add(dept)
dataSet.Tables.Add(emp)
' linking tables to allow navigation from parent table rows
' to corresponding child table rows
Dim parentColumn As DataColumn = dataSet.Tables("DEPT").Columns("DEPTNO")
Dim childColumn As DataColumn = dataSet.Tables("EMP").Columns("DEPTNO")
Dim relation As New System.Data.DataRelation("DeptsEmps", parentColumn, childColumn)
dataSet.Relations.Add(relation)
End Sub |
