在服务器建立test.aspx内容:
<%@ Page language="c#" CodeFile="test.aspx.cs" AutoEventWireup="false" Inherits="test" %> test.aspx.cs 内容: public partial class test : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // 在此处定义dataset 并且访问数据库。 DataSet ds = new DataSet(); ds = //访问数据库的function(); // 在此处把dataset转换成xml发送回去。 Response.Write( ds.GetXml()); } } Flash 端: 新建ActionScript 3.0 的Flash。 windows--->components-->DataGird 托拽到界面中。 命名为:aDg 在第一帧action中 写下以下代码 import fl.controls.dataGridClasses.DataGridColumn; import fl.data.DataProvider; import flash.net.*; import flash.display.*; import flash.display.Sprite; import flash.net.URLRequest; import flash.net.URLVariables; import flash.net.sendToURL; import flash.external.ExternalInterface; import flash.xml.XMLDocument; import flash.xml.XMLNode; import flash.xml.XMLNodeType; var loader:URLLoader = new URLLoader(); var URLpreFix:String="http://itd-cecilia/website/test.aspx"; //http://itd-cecilia/website/test.aspx为服务器地址 getresult1(); function getresult1(){ var url:String=URLpreFix; var request:URLRequest=new URLRequest(url); trace("sendToURL); var loader:URLLoader = new URLLoader(); loader.dataFormat=URLLoader DataFormat.TEXT; configureListeners(loader); loader.load(request); stop(); } function configureListeners(dispatcher:IEventDispatcher):void { dispatcher.addEventListener(Event.COMPLETE, completeHandler); dispatcher.addEventListener(Event.OPEN, openHandler); dispatcher.addEventListener(ProgressEvent.PROGRESS, progressHandler); dispatcher.addEventListener(SecurityErrorEvent.SECURITY_ERROR, securityErrorHandler); dispatcher.addEventListener(HTTPStatusEvent.HTTP_STATUS, httpStatusHandler); dispatcher.addEventListener(IOErrorEvent.IO_ERROR, ioErrorHandler); } function completeHandler(event:Event):void { var loader:URLLoader=URLLoader(event.target); trace("completeHandler: " + loader.data); var teamXML:XML = new XML(loader.data); var RoomIDCol:DataGridColumn=new DataGridColumn("RoomID"); RoomIDCol.headerText="ID"; RoomIDCol.width=20; var RoomNameCol:DataGridColumn=new DataGridColumn("RoomName"); RoomNameCol.headerText="Name"; RoomNameCol.width=30; var RoomDecCol:DataGridColumn=new DataGridColumn("RoomDescription"); RoomDecCol.headerText="Dec"; RoomDecCol.width=30; var RoomLocatCol:DataGridColumn=new DataGridColumn("RoomLocation"); RoomLocatCol.headerText="Locat"; RoomLocatCol.width=30; var RoomoffCol:DataGridColumn=new DataGridColumn("Office"); RoomoffCol.headerText="Office"; RoomoffCol.width=30; var RoomRemarkCol:DataGridColumn=new DataGridColumn("Remark"); RoomRemarkCol.headerText="Remark"; RoomRemarkCol.width=30; var RoomCbCol:DataGridColumn=new DataGridColumn("CreatedBy"); RoomCbCol.headerText="CreatedBy"; RoomCbCol.width=30; var RoomDCCol:DataGridColumn=new DataGridColumn("DateCreated"); RoomDCCol.headerText="DateCreated"; RoomDCCol.width=30; var myDP:DataProvider=new DataProvider(teamXML); aDg.columns=[RoomIDCol,RoomNameCol,RoomDecCol,RoomLocatCol,RoomoffCol,RoomRemarkCol,RoomCbCol,RoomDCCol]; aDg.width=700; aDg.dataProvider=myDP; aDg.rowCount=aDg.length; } function openHandler(event:Event):void { trace("openHandler: " + event); } function progressHandler(event:ProgressEvent):void { trace("progressHandler loaded:" + event.bytesLoaded + " total: " + event.bytesTotal); } function securityErrorHandler(event:SecurityErrorEvent):void { trace("securityErrorHandler: " + event); } function httpStatusHandler(event:HTTPStatusEvent):void { trace("httpStatusHandler: " + event); } function ioErrorHandler(event:IOErrorEvent):void { trace("ioErrorHandler: " + event); } |