How can I return a single value from an SqlDataReader?
<p>I forget to return  value in single tier application.</p>

<pre><code>public  int Studentid()
    {
        try
        {
            SqlConnection con = new SqlConnection(connectionStr);
            SqlCommand cmd = new SqlCommand("SELECT s_id FROM student where name = + ('" + Request.QueryString.ToString() + "')", con);
            con.Open();
            SqlDataReader dr = null;
            con.Open();
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                //Want help herr how i return value
            }

            con.Close();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
</code></pre>
