Joel,
>It looks like I am going to be forced to follow the crowd and go to Dot Net.
Who or what is forcing you?
>Please give me your thoughts, should I go to VB or C # ?
If you are serious about building an application with .NET, I highly recommend getting the Mere Mortals Framework for .NET from
www.oakleafsd.com and working through the tutorials in BOTH languages.
Kevin's docs take you through building your business objects, with examples in both languages, and then show you how to use them in both WinForms and WebForms apps.
You can mix and match the languages, building some things in VB and others in C#, and before long you'll be comfortable with both.
As others have said, the .NET framework is the thing -- language syntax is minor compared to learning the framework classes, and using Mere Mortals as the foundation of your app is a good way to learn just the essentials at first as you are getting your feet wet.
So, my suggestion is to buy the Mere Mortals product and build yourself a couple of "internal" projects to use in your own business -- perhaps .NET versions of something you already have. Do it with VFP tables and also with SQL Server (Mere Mortals can handle both). After a couple of weeks doing that, you'll be ready to take on some real work.
>Now the truth is I am going to keep using FoxPro as long as I can, and I will buy every version of FoxPro that comes out, but it looks like I need to learn another language too.
Unless your employer is forcing you to change languages, I see no reason to discard VFP anytime soon, but it's a wise step to always be learning something new to add to your toolset and increase your value to a prospective client or employer.
If I were a VFP-only developer and wanted to choose either SQL Server or .NET to learn right now, I'd pick SQL Server first, then start learning .NET later.