populate value in control from the session

See more:

C#2.0

C#

Hi Can Some one tell me how to populate the value from a session to the controls in a page.I have the values stored in a database..I created a connection to db and the filled the values in the session..Now I wanna populate the value to the control..I have done this peice of code..but this doesnt seems to be working

//connect to database for UserSetting stable
    SqlConncetion conn = new SqlConncetion(@"Server=localhost;      Database=LCLDatabase_DEV; Integrated Security=True);

//Create DataAdapter Object
SqlDataAdapter  adapter = new SqlDataAdapter  ("Select id,valueFrom user where UserName="Samantha",conn);

//Create a Dataset 
DataSet ds=new DataSet();

//Fill dataset using the query defined for DataAdapter

adapter.Fill(this.ds,"user );

foreach(DataRow row in ds.Tables["user "].Rows)
{
    Session["id"]=value;

}

Above I have stored the value in a session from db now I wanna populate it back to control when the user samantha logsin

   foreach(controls ctrl in page. controls)
{
    if(Session[ctrl.ID]!=null)
    ctrl.value= Session[ctrl.ID].value

}

can someone tell me how to proceed further??