Data retrieval from MS SQLwith ASP.NET 2.0

[Mzekeke]

Can somebody provide a simple example that gets data from MS SQL /MysQL with
ASP.NET 2.0 and displays it in Flash without using Flash Remoting. Where you
have a previous and next button to scroll through the data and displays it in
a textbox. I currently have the Foundation ASP.NET for Flash book and find the
examples not useful for me as they use webservices are bit too comprehensive
for me. On the Web most examples are for PHP/Flash or ASP/Flash and the only
ASP.NET example i found is for verifying a login.
Please help!

[Mzekeke]

Alright after exhaustively trying to get Flash/ASP.NET 2.0and MSSQL i almost
gave up until i ran across a tutorial at [url]www.flash-db.com[/url]. Though the code was
in ASP i managed to get it converted with assistance to ASP.NET C#.
The bproblem i now face is that although the ASPX page compiles(with no
errors) and displays the data from the database when i run the flash movie
It displays nothing. I assumed that i wouldn't have to change the Actionscript
file as i sawthat it's the same for ASP and PHP thus by extension thought it
should work fine also with ASP.net but it doesn't Anyway here's the code

Actionscript

//Create LoadVars object and load file
myData = new LoadVars()
//This is the line i changed to simply load the ASPX page
myData.load("Default.aspx")
myData.ref = this
//Fetch data
myData.onLoad = function(succes){
if(succes){
for(var i=0; i<this.cant; i++){
this.ref["Title_txt"+i].htmlText = ""+this["Title"+i]+""
this.ref["Comments_txt"+i].text = this["Comments"+i]
this.ref["holder_mc"+i].loadMovie(this["Image"+i])
}
} else trace("Error loading data")
}
stop()[/CODE]

And the ASPX code

   SqlConnection cn = new SqlConnection(@"Data
Source=LENOVO197\MSSMLBIZ;Initial Catalog=anastasio;Integrated Security=True");

SqlCommand cmd = new SqlCommand("SELECT Title, Comments, Image FROM
titles");
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
cn.Open();
SqlDataReader reader = cmd.ExecuteReader();


int cont = 0;
while (reader.Read())
{
Response.Write("Title" + cont.ToString() + "=" + reader["Title"]
+ "&" + "Comments" + cont + "=" + reader["Comments"]+ "&" +
"Image"
+ cont.ToString() + "=" + reader["Image"] + "&");
cont = cont + 1;
}
Response.Write("cont=" + cont.ToString());
cn.Close();
}
}

Please help