Partial preview of the text
Download Understanding DataAdapters and DataSets in ADO.NET and more Quizzes Introduction to Business Management in PDF only on Docsity!
DataAdapter provides the bridge between
the DataSet object and the data source
TERM 2
DataAdapter creates
a
DEFINITION 2
Connection to the database
TERM 3
DataAdapter builds a
DEFINITION 3
Command object
TERM 4
DataAdapter retrieves
DEFINITION 4
database records
TERM 5
DataAdapter populates results into a
DEFINITION 5
dataset or a datatable
DataAdapter properties
SelectCommand, insertcommand,
updatecommand,deletecommand
TERM 7
SelectCommand
DEFINITION 7
command objects that get or set an SQL statement used to
query records in a database
TERM 8
InsertCommand
DEFINITION 8
command objects that get or set an SQL statement used to
insert records in a database
TERM 9
UpdateCommand
DEFINITION 9
command objects that get or set an SQL statement used to
update records in a database
TERM 10
DeleteCommand
DEFINITION 10
command objects that get or set an SQL statement used to
delete records in a database
Craete SQL string
Dim mySql As String = "SELECT * FROM Categories"
TERM 17
Create DataAdapter
DEFINITION 17
Dim myDataAdapter As New OleDbDataAdapter(mySql,
myConnectionString)
TERM 18
DataSet retrieves
DEFINITION 18
relational data and stores in memory
TERM 19
DataSet
DEFINITION 19
a disconnected in-memory database
TERM 20
DataSet holds
DEFINITION 20
one or more dataTable objects
DataSet holds modifications to
data
TERM 22
DataSet defines
DEFINITION 22
relationships among data tables
TERM 23
DataSet uses ______ to communicate with the
database
DEFINITION 23
DataAdapter
TERM 24
When to use dataSet
DEFINITION 24
navigate between multiple discrete tables of
resultsmanipulate data from multiple sourcesreuse the same
set of rows to achieve a performance gain by caching
themperform a large amount of eoperations against each
rommanipulate data using XML operations
TERM 25
DataSet property
DEFINITION 25
Tables
DataTable may specify
constraints primary key foriegn key to ensure data integrity
TERM 32
DataTable properties
DEFINITION 32
columns, rows, PrimaryKey, TableName
TERM 33
Columns
DEFINITION 33
a collection of DataColumn objects
TERM 34
Rows
DEFINITION 34
a collection of DataRow objects
TERM 35
PrimaryKey
DEFINITION 35
gets or sets an array of columns that function as teh primary
key
TableName
the name of the DataTable
TERM 37
DataTable methods
DEFINITION 37
clear and NewRow
TERM 38
Clear
DEFINITION 38
remove all records in DataTable(the corresponding database
records are intact)
TERM 39
NewRow
DEFINITION 39
creates a new DataRow object for the DataTable
TERM 40
DataRow contains
DEFINITION 40
actual attribute values
delete
flags theDataRow object as deleted the row state property
becomes deleted
TERM 47
beginEdit
DEFINITION 47
begins editing mode
TERM 48
CancelEdit
DEFINITION 48
cancels the current edit and changes
TERM 49
EndEdit
DEFINITION 49
ends the current edit and saves changes
TERM 50
Create a dataSet
DEFINITION 50
DataSet does not belong to the OlwDb namespace. There is
no OleDb prefix for DataSetDim northwindDataSet as New
DataSet()
Create a DataTable object using the fill
method
myDataAdapter.Fill(northwindDataSet,"Categories")
TERM 52
Read and process records in the DataTable
DEFINITION 52
Declare a DataRow variable Dim aDataRow As DataRow
'Data processing against the result set For Each aDataRow In
northwindDataSet.Tables("Categories").Rows If
aDataRow("CategoryName").ToString() = "Produce" Then
MsgBox(aDataRow("Description").ToString()) End If
TERM 53
Steps to accessing data using dataSet
DEFINITION 53
1) Create a connection string 2) Create a SQL statement
string 3) Create a DataAdapter instance 4) Create a DataSet
instance 5) The DataAdapter creates a DataTable and fills the
DataSet 6) Declare a DataRow variable 7) Data operations
against each DataRow of the results
TERM 54
CommandBuilder
DEFINITION 54
Before you call the Update method, you must set values for
the InsertCommand, UpdateCommand, and DeleteCommand
properties of the DataAdapter
TERM 55
CommandBuilder
DEFINITION 55
The OleDbCommandBuilder object automatically generates
the three updating commands (if the value of
SelectCommand present)
BindingNavigator can be found under
the data category in the toolBox window
TERM 62
BindingNavigator.BindingSource Create a
bindingSource object
DEFINITION 62
Dim suppliersBindingSource As New BindingSource
TERM 63
Specify the DataSource of the BindingSource
object
DEFINITION 63
suppliersBindingSource.DataSource =
myDataSet.Tables("Suppliers")
TERM 64
Specify the bindingSource for the
BindingNavigator
DEFINITION 64
suppliersBIndingNavigator.BindingSource =
suppliersBindingSource
TERM 65
Binding Data to control a control can be
DEFINITION 65
bound to a data column of a DataTable so that it can
automatically display teh specified column valu for the
current record
