Connect VB6 to MySQL and make a search form

Page 1 of 1

4 Replies - 774 Views - Last Post: 21 November 2012 - 11:48 PM Rate Topic: -----

#1 paolo1231  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 21-November 12

Connect VB6 to MySQL and make a search form

Posted 21 November 2012 - 06:36 AM

Good Day! I'm a beginner with VB6 and know my way around SQL Databases and queries.
What I would like to know is how to connect VB6 to and SQL Database in Wamp or in SQL Plus.

I'm need to make a simple form that requires you to input products (Product ID, Name, Category, Stocks available) and save them in a SQL database table. There are also buttons to Edit or Delete current products.

Another button is a search button that opens a new form with a search bar and a list below it to display the search criteria from the database.

Any help would be much appreciated! Thanks!

Is This A Good Question/Topic? 0
  • +

Replies To: Connect VB6 to MySQL and make a search form

#2 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 4965
  • View blog
  • Posts: 10,562
  • Joined: 02-June 10

Re: Connect VB6 to MySQL and make a search form

Posted 21 November 2012 - 08:28 AM

We have an on-going thread about whether or not VB6 is dead. So I'm inviting you to join it just because I'm curious why someone today starts to learn this. Why does a new coder learn VB6 when VB.NET or C# are available?

Please read: Is learning VB6 now a complete waste of time? (Yes)
Was This Post Helpful? 0
  • +
  • -

#3 paolo1231  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 21-November 12

Re: Connect VB6 to MySQL and make a search form

Posted 21 November 2012 - 08:37 AM

Well I'm still a student and there are folks who need help in VB6 so they ask me to make sample programs in which they will of course pay :)
Was This Post Helpful? 0
  • +
  • -

#4 tlhIn`toq  Icon User is offline

  • Please show what you have already tried when asking a question.
  • member icon

Reputation: 4965
  • View blog
  • Posts: 10,562
  • Joined: 02-June 10

Re: Connect VB6 to MySQL and make a search form

Posted 21 November 2012 - 08:51 AM

Ok - so you're aiming at customer need, so that makes sense.
Where are you that there are people looking to have new programs made in VB6?
Was This Post Helpful? 0
  • +
  • -

#5 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 562
  • View blog
  • Posts: 2,935
  • Joined: 19-May 09

Re: Connect VB6 to MySQL and make a search form

Posted 21 November 2012 - 11:48 PM

try googling "ado sqlplus" to start.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1