How to get from loop Session on data reader?

[IT Genious]

Hi I am trying to send session on Loop and trying get . Can anyone please help me to do it?

SessionSend.aspx.cs
---------------------------

cmd.CommandText = "SELECT * FROM NewsEvents ORDER BY PostedDate DESC";
 while (dr.Read())
               {
                   Session["id"] = dr["NewsId"].ToString();
 
                Label1.Text += "<a href=DetailsView.aspx>Click Here for Details</a>";
}

SessionGet.aspx.cs
---------------------------

cmd.CommandText="SELECT * FROM NewsEvents WHERE NewsId=@Sessionid";
cmd.Parameters.AddWithValue("Sessionid", Session["id"].ToString());

In above code, I just only get same SessionId on every news headings, how do I get next row session id?

[Frinavale]

Store an array of the heading in session...or store the whole data table into session if you want to.

Right now you are overwriting the value at Session["id"] each loop iteration.

-Frinny

[IT Genious]

Thanks for your response,

Can you show me please how can I make array in this situation?

I would appreciate ur help