Represents an in-memory cache of data with support for Oracle-specific features.
This sample shows the use of untyped OracleDataSet with comprehensive
OracleDataTables. You can do the same operations in design time by drag&drop-ing OracleDataSet from Toolbox to Form Designer and editting it via
DataSet Manager and
DataSet Editor. Otherwise, you can always generate typed OracleDataSet using
DataSet Wizard.
|
|---|
static OracleDataSet GetDataSet(string connStr) {
// retrieving data from DEPT table
OracleDataTable dept = new OracleDataTable("select * from dept", connStr);
dept.FetchAll = true;
dept.Active = true;
// retrieving data from EMP table
OracleDataTable emp = new OracleDataTable("select * from emp", connStr);
emp.FetchAll = true;
emp.Active = true;
// adding data tables to OracleDataSet
OracleDataSet dataSet = new OracleDataSet();
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);
return dataSet;
} |
|
|---|
Public Function GetDataSet(ByVal connStr As String) As OracleDataSet
' retrieving data from DEPT table
Dim dept As New OracleDataTable("select * from dept", connStr)
dept.FetchAll = True
dept.Active = True
' retrieving data from EMP table
Dim emp As New OracleDataTable("select * from emp", connStr)
emp.FetchAll = True
emp.Active = True
' adding data tables to OracleDataSet
Dim dataSet As New OracleDataSet()
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)
Return dataSet
End Function |
