basmafia.blogg.se - Microsoft ado data control 6.0 download

separate file that describes data in an XML file.

like HTML, can have tags within others.

industry standard for transferring data.

data reader (if need high performance).

command object runs SQL or stored procedures in the database.

data "views" that allow data to be seen in different ways than it is stored in table(s).

constraints to manage additions/deletions from tables that are related to other tables.

SQLClient driver for SQL Server (Microsoft).

copy of data in memory, rather than connected to the database.

numerous objects with useful properties and methods.more powerful than DAO and previous ADO.can use ADO.NET with VB in code via object interface.ADO (ActiveX Data Object) interfaces to data store through OLEDB.data consumer = application that uses data.OLEDB "has nothing to do with Object Linking and Embedding" (Word, Excel).OLEDB "driver": database, email data, etc.data provider = gets data from data store.data store = "persistent" collection of data.data is accessed "in place" (no need to first move it into a database).e-mail, video, voice, images, web pages, etc., etc.accesses relational databases with ODBC.

includes "drivers" for Access, dBase, DB2, Excel, text, etc.

API = application programming interface.

API standard for using relational databases.

ADO.NET is part of Microsoft's universal data access strategy.

CIS 338: Using ADO (ActiveX Data Objects) Dr.