<%@ Page Language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<%@ Register TagPrefix="FRDG" Namespace="FlashGateway"
Assembly="flashgateway" %>
<script runat="server" >
void Page_Load() {
SqlConnection myConnection;
SqlCommand myCommand;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
String sql = "SELECT ProductName,UnitPrice,QuantityPerUnit
FROM dbo.Products";
String conn = " Server=192.168.0.4;uid=frdg;pwd=mypwd;database=Northwind";
if(Flash.Params.Count > 0) {
sql += " WHERE ProductName Like '%" + Flash.Params[0].ToString()
+ "%'";
}
myConnection = new SqlConnection(conn);
myConnection.Open();
myCommand= new SqlCommand(sql, myConnection);
myDataAdapter = new SqlDataAdapter(myCommand);
myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet,"Products");
Flash.DataSource = myDataSet.Tables["Products"];
Flash.DataBind();
myConnection.Close();
}
</script>
<FRDG:Flash ID="Flash" Runat="Server" />