get data using sessions by calling record id

See more:

ASP.NET

Hai all,i write this code use verification againest database

            cmd.CommandText = "SP_user_verifi";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Name", nameforlogin.Text);
            cmd.Parameters.AddWithValue("@Password", pwdforlogin.Text);


            SqlDataAdapter da = new SqlDataAdapter();
            DataSet ds = new DataSet();
            da.SelectCommand = cmd;
            da.Fill(ds);


            if (ds != null && ds.Tables.Count > 0)
            {
                string status = ds.Tables[0].Rows[0][0].ToString();
                if (status == "yes")
               
                //    Session["nameforlogin"] = ds.Tables[1].Rows[0]["Name"].ToString();
                //    Session["pwdforlogin"] = ds.Tables[1].Rows[0]["Password"].ToString();



                Session["name"]          =  nameforlogin.Text;
                Session["password"]      = pwdforlogin.Text;
                Response.Redirect("home.aspx");

                }
                else
                {
                    Response.Redirect("somepage.aspx");


and this is for getting user record by his name


            if (Session["name"] != null)
            {

                string name = Session["Name"].ToString();
                SqlConnection conn = new SqlConnection("Data Source=USER-PC\\ADITYA;Initial Catalog=holder;Persist Security Info=True;User ID=sa;Password=123");
                conn.Open();

                SqlCommand cmd = new SqlCommand("select * from tb_userlogin where Name =@Name", conn);
                cmd.Parameters.AddWithValue("@Name", name);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                da.Fill(dt);
            }
            else
            {
                Response.Redirect("test1.aspx");

            }

now i need to get the record using user's id,how can i get this

Thanks and Regards