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

Hi,

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:
http://www.microsoft.com/visualstudio/en-us/products/2010-editions/visual-csharp-express

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.
Victor KimuraSEO, Web DeveloperAsked:
Who is Participating?
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
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.
0
 
Jorge PaulinoConnect With a Mentor IT Pro/DeveloperCommented:
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.
0
 
Victor KimuraSEO, Web DeveloperAuthor Commented:
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.
0
 
Victor KimuraSEO, Web DeveloperAuthor Commented:
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)?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.