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.