Control Name&Purpose
Eight data controls are available for Windows forms
DataSet
This control is used in conjunction with the other data controls, storing the results that are returned by commands and the DataAdapters. Unlike the recordset from ADO and DAO, the DataSet actually brings back a hierarchical view of the data. Using properties and collections in the DataSet object, you can get all the way down to individual tables, rows, and columns.
OleDbDataAdapter
This control stores and manages the commands you want to use against an OleDb provider such as Jet, Oracle, or SQL Server. The commands for selecting, updating, inserting, and deleting records can be used. The Connection against which to use the commands is also tracked.
OleDbConnection
This control maintains connection information for an OleDb provider. This control is used with the OleDbDataAdapter.
OleDbCommand
Similar to the ADO command object, this control allows you to execute SQL statements or stored procedures to either run bulk operations or return data.
SqlDataAdapter
This control is the same as the OleDbDataAdapter except that it is for use only against SQL Server stores.
SqlConnection
This control is the same as the OleDbConnection except that it is for use only against SQL Server stores.
SqlCommand
This control is the same as the OleDbCommand except that it is for use only against SQL Server stores.
DataView
This control creates multiple views of the same table. This includes looking at data in various states such as deleted, changed, or sorted differently
No comments:
Post a Comment