08-08-2012, 04:57 PM
ADO DATA CONTROL
13792_ADO DATA CONTROL.ppt (Size: 674.5 KB / Downloads: 32)
ADO CONTROL
ActiveX Data Objects enables us to write an application to access and manipulate data in a database server through an OLE DB data provider.
Universal Data Access(UDA) is an overall data access strategy from Microsoft.
Universal Data Access(UDA) means accessing different kinds of data using OLE DB as a data provider and ActiveX Data Objects (ADO) as the data access technology.
OLE DB
OLE DB is the underlying system service that a programmer using ADO is actually using.
OLE DB is a set of interfaces that provide applications with uniform access to data stored in diverse information sources or data sources
OLE DB is suitable for relational and non relational data sources.
Accessing Database using ADO DC
Goto Project menu and select Components.
Add two new controls:
Microsoft ADO Data Control (OLE DB)
Microsoft Flex Grid Control 6.O
Place ADO Control on the form.
Right Click this control and select ADODC properties.
Property Pages for the ADODC control will show up.
Under General Tab, select source of connection as Use Connection String and click on Build button.
Specifying the Record Source
In the Property Pages , choose Record Source Tab.
Specify the Record Source by first selecting the command type as 2-adCmdTable and then by selecting the desired data table from the database.