I think that my (alck of) .net skills are the problem.
this code is fine...
<code>
<%@ Page language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Register TagPrefix="MM" Namespace="FlashGateway" Assembly="flashgateway"
%>
<script langauge="C#" runat="server">
void Page_Load(Object sender, EventArgs e){
// build a connection string
string cnnString = "Provider=SQLOLEDB.1;Data Source=xyz ; Initial
Catalog=xyz;User ID=xyz;Password=xyz; Network Library =dbmssocn";
// connect to the server
OleDbConnection sqlCnn = new OleDbConnection(cnnString);
string sqlQuery="SELECT * FROM TABLE'";
OleDbDataAdapter sqlData = new OleDbDataAdapter(sqlQuery,sqlCnn);
// fill the DataSet
DataSet myDataSet = new DataSet();
sqlData.Fill(myDataSet,"productList");
// set the dataSource property to the resulting table
myFlash.DataSource = myDataSet.Tables[0];
// bind the data to the Flash Control
myFlash.DataBind();
}
</script>
<MM:Flash id='myFlash' runat=server/>
</code>
when i try to adapt to use sp with the following...
<code>
<%@ Page language="C#"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Register TagPrefix="MM" Namespace="FlashGateway" Assembly="flashgateway"
%>
<script langauge="VB" runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs)
// build a connection string
Set objConnection = Server.CreateObject("ADODB.Connection")
Set objCommand = Server.CreateObject("ADODB.Command")
Set objRecordset = Server.CreateObject("ADODB.Recordset")
with objCommand
.ActiveConnection = "Provider=SQLOLEDB.1;Data Source=xyz ; Initial
Catalog=xyz;User ID=xyz;Password=xyz; Network Library =dbmssocn";
.CommandText = "spgetstarfromtable"
.CommandType = 4
.Parameters.refresh()
.Parameters("@paramID").value = "star"
.Execute
end with
objRecordset.Cursorlocation = 3
objRecordset.Open objCommand, , 3
myFlash.Result = objRecordset.RecordCount
myFlash.DataBind()
end sub
</script>
<MM:Flash id='myFlash' runat=server/>
</code>
this is currently where I am at, if anyone can hint me in the right direct
then I am all ears!
--
Gavin Lilley.
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
