ADO.NET issues

[fkheng]

In order for me to work with data components or other ado.net related code, wat references are necessary for me to proceed with the coding?

[PlausiblyDamp]

System.Data.dll

[APaule]

plus:

System.Data.OleDb

System.Data.SqlClient

depending on whether you'r connecting to SQL Server or something else.

[PlausiblyDamp]

The namespaces System.Data.OleDB and System.Data.SqlClient are part of the physical file System.Data.Dll

[fkheng]

i see...

i did add a reference for System.Data.Dll

 

but my OleDb syntax were still underlined in blue

so i just typed Imports System.Data.OleDb and it worked...

 

i tot as long as i added the System.Data reference it should have covered the OleDb references as well, shouldn't it?

[PlausiblyDamp]

It would have added the reference to the project but you would still have to specify the full class name (including namespace)

 

so the OleDBConnection is really System.Data.OleDB.OleDBConnection

 

Imports System.Data.OleDb is just a shorthand way of accessing those classes.

[fkheng]

i see

so though i've added the reference System.Data

i still have to im port System.Data.OleDb eh?

 

wat if i just type Imports System.Data

would that suffice? or must i still specify System.Data.OleDb just becoz i'm using the OleDb data provider?

[APaule]

You have to import it.

And if you import only System.Data you will have to do more typing.

Better you also import System.Data.OleDb (or SqlClient)

[fkheng]

another question

each time after using a data adapter to fill in a data set, they always have something which has a .setdatabinding, something like that, wat is the name of the object which does this operation? and wat's the purpose?

[APaule]

This is for binding data to controls.

For more information browse the objectcatalog and display help for the control.databindings.