User Guide

Using ADO.NET objects with Flash Remoting 153
Using ADO.NET objects with Flash Remoting
Flash Remoting provides a service adapter for binding ADO.NET data tables and data views to
the Flash Remoting custom server control. To bind data sets to the custom server control, you use
the control’s
DataSource property and DataBind method. In ActionScript, the results are
exposed as a RecordSet object.
The following C# example could be used in a code-behind file or in the ASPX page that contains
the Flash Remoting server control:
<%@ Page Language="c#" Debug="true" %>
<%@ Register TagPrefix="Macromedia" Namespace="FlashGateway"
Assembly="flashgateway" %>
<Macromedia:Flash id="Flash" Runat="Server" />
<%
// create a SQL connection object and open a connection
String source1 = "server=(local)\\NetSDK;" + "id=QSUser;pwd=QSPassword;" +
"database=Northwind";
sqlConnection = new SqlConnection(source1);
sqlConnection.Open();
// create the SQL statement
String selectCountry = "SELECT DISTINCT Country FROM Customers ORDER BY
Country ASC";
// query the database
SqlDataAdapter countryAdapter = new SqlDataAdapter(selectCountry,
sqlConnection);
// create a dataset object
DataSet countryData = new DataSet();
// fill the dataset with the query results
countryAdapter.Fill(countryData, "Customers");
// assign the dataset into the flash.datasource property
Flash.DataSource = countryData.Tables["Customers"];
// bind the datatable to the custom server control
Flash.DataBind();
// close the SQL connection
sqlConnection.Close();
%>
In the code, the countryData DataSet object is created from a SQL query to a database. Next,
the
countryData DataSet object is assigned into the Flash.DataSource property. Finally, the
DataSet object is bound to the Flash Remoting custom server control using the
Flash.DataBind() method.
Data tables are serialized by Flash Remoting to a record set in ActionScript. Data sets, which are
collections of data tables, are serialized by Flash Remoting to an associative array of record sets
back in ActionScript.