session in c# and ASP.net
<p>I've been trying to pass the course_code session value as a parameter but it gives nothing - the page just appears to be blank.  I've tried to print the session course_code to check whether it was saved correctly and it was printed correctly. </p>

<p>Also, I'm sure that the SQL stored procedure is written correctly as i've tested it many times and it gives a correct output each time. Can anyone help me?</p>

<pre><code>String ConnStr2 = ConfigurationManager.ConnectionStrings["MyRuMoR"].ToString();
SqlConnection conn2 = new SqlConnection(ConnStr2);
conn2.Open();
SqlCommand cmd2 = new SqlCommand("PollsQ", conn2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@code", (string)Session["course_code"]);
SqlDataReader rdr2 = cmd2.ExecuteReader();
</code></pre>
