Before we get started download “One Headlight” by the Wallflowers. Yea its a bit old but still rocks!

Now that have some music jamming in the background lets get started.

We need an ASP.NET web service if you don’t already have one create it; if you do then great. This example code is in C# it can easily be done in VB as well.

1. Let’s add an import to the top

using System.Web.Mail;

So you gave up on trying to figure out how you can directly connect Flex to your database like with any server side language and decided to Google the answer. Well by now you probably figured out that your building a “client” application not a server side application.

So whats the best approach in achieving what you want? I have no clue, I do however have a solution that I put together using ASP.NET C#, Web Service, some duck tape and lot of Tylenol which makes getting at and querying your data just as easy as using SQL Manager which is actually a hell of a lot easier than querying your data with any server side code.