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

Posted on 2012-09-05
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
    LVL 48

    Assisted Solution

    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
    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

    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
    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    ASP.NET MVC site showing code blocks 3 46
    Richtextbox formatting 8 18
    PHP Word Writer 1 28
    .xltm file opens as .xlsx file 3 0
    Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
    A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
    In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
    This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now