See my old code... |
| shreya verma replied to Vasanthakumar D at 12-May-08 01:08 |
See as i have this, in my dropdown control i have user login and officer login when user login i want to open Employee profile page and in officer login i wanna open Employee view page.
m posting you a code which opens a page employeeprofile page in both cases
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())
{
Response.Redirect( "EmployeeProfile.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);
}
} |
|