you can do the following:
on First Page(Login) :
you need to put your dropdown selectedValue in session to move it to the next page.
after successfull login: On second page you first need to get that values from session. and Then you the following...
<pre lang="cs">
string sessValue = Conver.ToString(Session["youSessionName"]);
youConectionName.Open();
SqlCommand cmd = new SqlCommand("Select * from DeptInfo where DeptCode='" + sessValue + "'", youConectionName);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
Salary.Text = rd["Salary"].ToString();
Telephone.Text =rd["TelephoneNo"].ToString();
Manager Name.Text=rd["ManagerName"].ToString();
}
else
{
//Code will reach here if no records found.
}
</pre>
you can call this on page load or on button click as you want...
This will definately help you....