naman kaushal

naman kaushal

  • NA
  • 10
  • 16k

Display label on Welcome page after login page .

Nov 30 2012 11:07 AM

Hi

 I have a login Page where i want the Faculty to login and on the next page which is "Welcome_Faculty" i want to display a label showing " Welcome Faculty_Name" from the below table in Sql server.The Table is shown below.

 Faculty_Name   UserName   Password

Elena Popel       epopel         popel

Raied Salman   rsalman       salman

Ravi Rathnam   rrathnam    rathnam

the code which i have for Login page is as follows

public partial class Faculty_Login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void BtnLogin_Click(object sender, EventArgs e)
    {
        string strcon = ConfigurationManager.ConnectionStrings["MyDatabaseConnection"].ConnectionString;

        SqlConnection con = new SqlConnection(strcon);

        SqlCommand com = new SqlCommand("CheckFaculty", con);

        com.CommandType = CommandType.StoredProcedure;

        SqlParameter p1 = new SqlParameter("username", TextBox1.Text);

        SqlParameter p2 = new SqlParameter("password", TextBox2.Text);

        com.Parameters.Add(p1);

        com.Parameters.Add(p2);
      
        con.Open();

        SqlDataReader rd = com.ExecuteReader();

        if (rd.HasRows)
        {

            rd.Read();           
            Session["username"]= TextBox1.Text;
            // Label5.Text = "Login successful.";
            Response.Redirect("Welcome_Faculty.aspx");
           
        }

        else
        {

            Label5.Text = "Invalid username or password.";

        }
      
    }
}

     The login page is Working perfect but when i go on the next page i want to display a label which picks the faculty_name from the above table corresponding to the username and password .How can i do that
       
    Can somebody help me with this?


Answers (7)