Only last record loads(ASP.NET)/Forwardbackward functionality

programming
1

I have managed to get flash(AS2) to read data that is being published via ASP.NET 2.0(C#) and MSSQL2005. The problem I have run into is that in my current db I have 4 records which all ouptut properly in the ASPx page but when loaded in flash the last record appears first. Additionally i have hit a brickwall when trying to add functionality to the forward and back button to move through the records.I have attached the files.The project is actually me converting an old tutorial located at[COLOR=#336699]http://www.15seconds.com/Issue/010605.htm[/COLOR]. Their AS code is inside each movie clips where else mine i placed on a frame for easier code management.
The aspx code


[SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Collections.Generic;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Linq;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Web;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Web.UI;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Web.UI.WebControls;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Data.SqlClient;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]using[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] System.Data;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]public[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]partial[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]class[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]_Default[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] : System.Web.UI.[/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]Page[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] 
{
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]protected[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]void[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] Page_Load([/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]object[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] sender, [/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]EventArgs[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] e)
{
[/SIZE][SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]//string Name = string.Empty;
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]//string Telephone = string.Empty;
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]// string City = string.Empty;
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008000][SIZE=2][COLOR=#008000]//string Notes = string.Empty;
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]SqlConnection[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] cn = [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]SqlConnection[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]([/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]@"Data Source=XPDEV\SQLEXPRESS;Initial Catalog=Addressbook;Integrated Security=True"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]);
[/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]SqlCommand[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] cmd = [/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]SqlCommand[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]([/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Select * from Contacts"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]);
cmd.CommandType = [/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]CommandType[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2].Text;
cmd.Connection = cn;
cn.Open();
[/SIZE][SIZE=2][COLOR=#2b91af][SIZE=2][COLOR=#2b91af]SqlDataReader[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] reader = cmd.ExecuteReader();
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]int[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] Record = 0;
[/SIZE][SIZE=2][COLOR=#0000ff][SIZE=2][COLOR=#0000ff]while[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] (reader.Read())
{
Response.Write([/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Name"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + reader[[/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Name"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]]+[/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"&"
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]+ [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Telephone"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + reader[[/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Telephone"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"&"
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]+ [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"City"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + reader[[/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"City"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"&"
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]+ [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Notes"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + reader[[/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"Notes"[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]] + [/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"&"
[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2]
);
Record = Record + 1;
}
Response.Write([/SIZE][SIZE=2][COLOR=#a31515][SIZE=2][COLOR=#a31515]"TotalRecords="[/COLOR][/SIZE][/COLOR][/SIZE][SIZE=2] + Record.ToString());
reader.Close();
cn.Close();
}

}
[/SIZE]

AS2 code


var send_lv:LoadVars = new LoadVars();
send_lv.onLoad = function(success:Boolean):Void {
 name_txt.text=send_lv.Name;
  telephone_txt.text=send_lv.Telephone;
  city_txt.text=send_lv.City;
  notes_txt.text=send_lv.Notes;
 }
 send_lv.sendAndLoad("getdetails.aspx", send_lv, "GET");
 
 back_btn.onRelease=function()
{
 //Code to navigate through records bacward
}
forward_btn.onRelease=function()
{
 //Code to navigate through records forward
}