anyone can help with data navigation in vb and ms sql 2000?
techz_boy 0 Newbie Poster
Alvein 2 Junior Poster
Exactly, what have you done and what do you plan to do?
We could write a whole book about "data navigation"....
techz_boy 0 Newbie Poster
i mean how to connect, add, update, delete data from vb
can u give me the e-book or other source about that?
Comatose 290 Taboo Programmer Team Colleague
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 0 Newbie Poster
yeah i've visit that sites. but i'm still confuse with the db.i use ms sql 2000
Alvein 2 Junior Poster
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 3 Posting Whiz in Training
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.