login page

Hi,
 am create a  Login Page . then i want to check roleid in the  logintable.
my code is..
MySqlCommand cmd = new MySqlCommand("select * from login where empcode =@empcode and password=@password ", cn);
       


        cmd.Parameters.AddWithValue("@empcode", txtempcode.Text);
        cmd.Parameters.AddWithValue("@password", txtpass.Text);
       MySqlDataAdapter da = new MySqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);


        if (dt.Rows.Count > 0)
        {
            Response.Redirect("Home.aspx");
        }
        else
        {
            ClientScript.RegisterStartupScript(Page.GetType(), "validation", "");
        }
    }
roleid is 1,2,3
using this roleid only i want to login....