VB and MS-sql 2000 data navigation

[techz_boy]

anyone can help with data navigation in vb and ms sql 2000?

[Alvein]

Exactly, what have you done and what do you plan to do?

We could write a whole book about "data navigation"....

[techz_boy]

i mean how to connect, add, update, delete data from vb
can u give me the e-book or other source about that?

[Comatose]

Have you looked at this tutorial http://www.timesheetsmts.com/adotutorial.htm? I realize it's for access, but I'm pretty sure that the OO of it allows for interfacing of any database system, but I could be wrong.

[techz_boy]

yeah i've visit that sites. but i'm still confuse with the db.i use ms sql 2000

[Alvein]

yeah i've visit that sites. but i'm still confuse with the db.i use ms sql 2000

I think you said (in a previous thread) you had no problem with the MSSQL connection string. With ADO, the database access is pretty standard, unless you plan to do something advanced or too specific for a given engine.

PM sent.

[mnemtsas]

As Alvein said all you need to do with that tutorial is change the connection string to get it to work with SQL Server. Look here: http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer for a connection strings for SQL Server.