pass the database value usingsessionandredirecttoanotherpage

Question

startexec Table as follows;

QpName BthID
 
REO       718

batch table as follows;
 
Bthid Bthno Course  Attender

718    B84      REO     SJ
 
Design screen as follows;
 
Batch No textbox
Course Dropdownlist

i want to pass the Bth id value using session from startexec (table)
pass the Course value using session from Batch (table)

i have one button called Go. when i click that Go button it will redirect to another page.
 
for that how can i do using csharp?
 
please help me.
 
Regards,
 
Narasiman P.