I has a question i create a form using vb but i dun know how to write the code for the it. So all the data i fill in the form will show it the MS SQL. So what to write the code and anyone have a good tutorial for me to study??

My form is like this

Name:
Age:
Address:
Badge No:

Then the data will save inside the MS SQL.

Recommended Answers

All 2 Replies

Search for ADO Turorial VB6 on web or site. Also search this site for my handle (vb5prgrmr) and Data Form Wizard.

Good Luck

Better yet...

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 selecting your access database via browse button on screen 3.
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.