Click here to Skip to main content
Click here to Skip to main content
Go to top

Visual Studio 2005 MFC + mysql Step by Step

, 19 Sep 2013
Rate this:
Please Sign up or sign in to vote.
Visual Studio 2005 + MySQL Steps (MFC)
  1. Install Visual Studio 2005
  2. Download mysql community MSI installer
  3. Install mysql
  4. Uninstall mysql connector from control panel
  5. Download and install .NET connector 6.4.6 msi installer
    (** Important: Choose .NET connector according to Visual Studio version)
  6. Create table in MySQL
  7. Open VS2005
  8. New project and click view->other windows->server explorer
  9. Right click dataconnections->add connections (on the right top of window)
  10. Click change
  11. Select mysql database from data source and click ok
  12. server name: localhost
    username: root
    password: (whatever password you set or leave it blank)
    database name: (select from drop down)
  13. Click test connections (should display successful)
  14. Click ok
  15. Double click localhost, tables (on the right top of window)
  16. Right click table name->new query->add->close
  17. Select all except *(All Columns)
  18. Right click column->change type->insert values
  19. Enter some values similar to your table data
  20. Right click column->execute SQL
  21. Open mysql and check in your table. Values should be updated.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

AshwinK4
Software Developer (Junior) Self employed
India India
No Biography provided

Comments and Discussions

 
GeneralMy vote of 1 Pinmvp Akhil Mittal 4-Sep-14 2:28 
GeneralMy vote of 3 PinmemberMuhsinEmre18-Sep-13 3:36 
GeneralMy vote of 2 PinmemberGregoryW8-Sep-13 3:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 19 Sep 2013
Article Copyright 2013 by AshwinK4
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid