Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ado in vb.net

Status
Not open for further replies.

AOLBoy

IS-IT--Management
May 7, 2002
68
GB
I am new to vb.net and trying to connect a datagrid to an Access database via ODBC.

In VB6 I used an ADO data control and set the properties to use my ODBC and then set the recordsource with an SQL string. I then linked the datagrid to this ADO Control. This involved no direct coding.

I can't seem to work out how to achieve this in VB.net. Can anybody help me, or is vb.net a whole new ball-game?

 
Check out this FAQ: faq796-3820

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!
 

In .NET, System.Data and System.Data.Oledb namespaces contains all the functionality of pre-.NET ADO. Check these namespaces and you will get almost everything you need for your database application.

You can use Dataset, BindingSource and DataNavigator controls (from toolbox in Visual Studio 2005) to get all (and more) functionality of ADO Data Control of VB6.

Hope it helps.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top