I didn't get the question clearly without your code.I guess you are trying to do this:
Try this:
SqlDataReader dr;
cmd = new SqlCommand("select * from tbl_ins where empid='"+empid+"'", con);
dr = cmd.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
int empid = Convert.ToInt32( dr[0].ToString());
dr.close();
if(empid==1)
{
Response.Redirect("../Hr/EmployeeRegistration.aspx", false);
}
if(empid==2)
{
}
}
else
{
dr.Close();
}