[Last Call] Learn how to a build a cloud-first strategyRegister Now


use C# or VB for connecting to remote MySQL db with MS Word

Posted on 2012-09-05
Medium Priority
Last Modified: 2012-09-13

I don't know C# or VB well but I develop in PHP/MySQL. I'm about to embark on a project. My clients will be using I think MS Office (Word 2003) and I have to get their MS Word to connect to a remote MySQL db and get some data and run enter or display the data (based on specific criteria and loops) in MS Word to save them time on creating documents.

I'm wondering should I be learning/coding in C# or VB to do this. I have Office 2010 Pro at home.

If C# is the way to go then do I need or should I be purchasing the Visual Studio 2010 Pro with MSDN ($500) or should I just download this:

I find having a good debugger and good IDE is a must.

I also will be doing some programming with MS Access for another client.

I just want to go in the right direction. VB seems more procedural and C# OOP but I've only done some basic things in VB so I don't know the pros and cons of each.

Also, what's the difference between ASP.NET, .NET, Visual Basic.NET, Visual Basic Classic, C#?

Thanks for your feedback.
Question by:Victor Kimura
  • 2
  • 2
LVL 48

Assisted Solution

jpaulino earned 2000 total points
ID: 38371208
VB.NET a C# are identical and you can do the same with both (you can also convert from a language to the other with several tools).  ASP.NET is a framework for web development, using webforms or MVC, and you can use both languages for programming .

Visual Basic Classic is the old versions of VB (until version 6) and after this version it has migrated to .NET

Since you will develop some things in Office, you probably will work with VBA (Visual Basic for Application) and I think VB will be a good choice. If you learn one language it will be easy to work with the other one, because only syntax changes and most things are similar.

Author Comment

by:Victor Kimura
ID: 38374394
should I purchase Visual Studio Pro 2010 for my needs?

Is VBA Object Oriented? C# has namespaces and classes but from my limited understanding it seems like VBA isn't as high a language.

I'm worried about learning VBA when I should've learned C# for development because the syntax is different but if others think I should learn VBA rather than C# than I will.
LVL 48

Accepted Solution

jpaulino earned 2000 total points
ID: 38375135
If you will have to use MS Word to connect to a MySQL, then you should learn VBA because MS Word uses VBA for automation.

If you just need to get/set information from Word to MySQL, then you can and should use VB.NET or C# (they can do the same thing)

VB.NET and C# are Object Oriented (they have namespaces, classes, etc) , but not VBA, and VBA it's used for Office automation and not to develop applications.

Author Comment

by:Victor Kimura
ID: 38377392
Ok, thanks. That clarifies things. You think I should get the Visual Studio Pro 2010 $500 or just get the express edition of C# (I think it's free)?

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question