Asp.net Session Variable from SQL DB
<p>I created a custom login page using Forms Authentication and using a sQL DB to store user data.  I am able to create a session variable from the username, but wondering if it is possible to pull a separate field and create a session variable based on that.  I would like the session variable to be based off a SalesNumber a 5 digit decimal field.  Please give me any comments or suggestions.</p>

<pre><code>cmd = new SqlCommand("Select pwd,SalesNumber from users where uname=@userName", conn);
cmd.Parameters.Add("@userName", System.Data.SqlDbType.VarChar, 25);
cmd.Parameters["@userName"].Value = userName;
Session["userName"] = userName;
</code></pre>

<p>Thanks....</p>
