I want to show a record from database in textboxes

See more:

LINQ

i am working in ASP.net with linq and C# and SQL server database
i have three tables s_reg,s_log,s_prof
from which i want to get the data from s_reg and s_prof table
s_reg have reg_id,s_prof have stud_id as primary key and s_prof have reg_id as foreign key
i want to show some fields from s_reg and some from s_prof


thanks in advance

What I have tried:

protected void Page_Load(object sender, EventArgs e)
    {
        s_prof prof = new s_prof();
        s_reg reg = new s_reg();
        s_log slog = new s_log();
        studentDataContext db = new studentDataContext();
        if (Session["usernm"] == null)
        {
            Console.WriteLine("ERRORRRRR");
        }
        else
        {
            var log = (from s in db.s_profs
                   join m in db.s_regs on s.reg_id equals m.reg_id
                   where m.susnm == Convert.ToString(Session["usernm"])
                   select new { s.stdname, s.stdcity, s.stdmob,s.stdemail,m.smobile});

           
            TextBox1.Text = prof.stdname;
            TextBox2.Text = prof.stdcity;
            TextBox3.Text = prof.stdmob;
            TextBox4.Text = prof.stdemail;
            TextBox5.Text = reg.smobile;
        }
        
    }
}