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

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

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

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

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.

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.

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....erForSQLServer for a connection strings for SQL Server.