Do anyone know how to use the vb to retrieval data from MS SQL ?
Do anyone have a good tutorial about it can post it??
gingank 0 Junior Poster
manoshailu 12 Junior Poster
Hi,
Use the below link to know about the connectivity with database using VB,
http://www.vbcode.com/Asp/code.asp?lstCategory=Database
Shailaja :)
vb5prgrmr 143 Posting Virtuoso
Start new standard exe project
Goto vb's ide menu Add-Ins > select add-in manager.
Look for VB 6 Data Form Wizard, highlight > Look at frame in bottom right corner with caption Load Behavior > select Loaded/Unloaded so check mark displays in check box. > OK
VB IDE Menu Add-Ins > Data Form Wizard
Run through wizard (use ODBC DSN)
On next form enter the name of the form you want, the style, and the type. I would suggest to start off with the ADO Code unless this is the first time you have ever played with VB.
Actually I would suggest that you use each option with each type and save that as a test project for reference. Then you will have it for reference.
Good Luck
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.