This content has been marked as final. Show 3 replies
The most important thing to realize about Flex and it's ability to connect to a database is that i cannot!
There is nothing in Flex that knows anything about .Net or vice versa!
Absolutely, Flex can talk to old simple ASP pages. It's entirely upto the ASP page to figure out about how it wants to connect to a database. Once it has retrieved that data from database, all it has to do is to write it to the Response object as, let's say, XML or JSON or what have you.
Once you have this page and you hit it in the browser and see the appropriate response, you're ready to call it from Flex. In flex you'll use HTTPService class and listen for result and fault events. One you've recieived the data its upto you to display it whichever way you like.
Yes, of course, you can use the same HTTPService in Flash CS3 to connect to the same page, listen for same result and falut event and get the data.
Thanks for your reply. I have another quick question...In terms of the result set, is there a way to pass them from the ASP page rather than creating/converting to XML?
Unfortunately, the answer is no! Just like you can't show your result set on an HTML page without iterating it, getting it's properties -- rows and columns -- and converting them them to HTML text for browser to show; there is no way for Flex to understand semantics of a result set.
Your best bet could be a third party library that quickly converts a result set into more portable XML or CSV or JSON.