Flash AS3, ASP.NET and MSSQL connectivity

To connect your flash actionscript project to a database the easiest way is to use dynamically creating XML method.

With this code snippet you may load xml file into swf. If you implement MyDataXML.aspx as responsing XML file flash will accept it as an xml file.

var loader:URLLoader = new URLLoader();

loader.addEventListener(Event.COMPLETE, loadXML);

loader.load(new URLRequest(“ MyDataXML.aspx”));

function loadXML(e:Event):void
{
xml = new XML(e.target.data);
trace(xml);
}

To make an aspx file responsing XML file this code block you should write into page_load method.

System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; response.Buffer = true;

response.ClearContent();

response.ClearHeaders();

response.ContentType = "text/xml";

xmldata="xml comes here";

response.Write(xmldata);

response.End();

This query sample may help you getting your data from database. This is not obligated. Just select your data however you like.

select *
from chairsAndTable
for xml path ('yourTagName')

As an alternate to this query i have written a custom method that turns my DataSet to XML file then I can select all i want (also able to join tables or implement trees).

In my opinion, this is the easiest and flexible way to connect your flash to database. If you have any other ways please let me know about it. ;)

PS: Do not forget to add document properties as the first line into XML file.