Login Prob... |
| shreya verma posted at 12-May-08 12:53 |
I want to open a Different page when user login and different page when officer logins. I did this but in both cases same page means EmployeeView page will opened, how to do it???
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
BindData();
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["ConStr"].ToString();
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("Usp_CheckLogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue( "@userid", txtUserID.Text);
cmd.Parameters.AddWithValue( "@password", txtPassword.Text);
cmd.Parameters.AddWithValue( "@role", DDRole12.SelectedValue);
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
if (DDRole12==User)
{
Response.Redirect( "EmployeeProfile.aspx?empid=" + txtUserID.Text);
}
else if (DDRole12!=User)
{
Response.Redirect( "EmployeeView.aspx?empid=" + txtUserID.Text);
}
else
{
Response.Write( "Your Login Unsuccessful");
}
sdr.Close();
con.Close();
}
}
private void BindData()
{
try
{
string constr = ConfigurationManager.ConnectionStrings["ConStr"].ToString();
SqlConnection con = new SqlConnection(constr);
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("Select distinct * from Login1", con);
sda.Fill(ds);
DDRole12.DataTextField = "Role";
DDRole12.DataValueField = "Role";
DDRole12.DataSource = ds;
DDRole12.DataBind();
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
} |
|