how we show the name of login person on welcome page?

Question

0.00/5 (No votes)

See more:

hi Sir,

I want that as user login the name of that user so on the top as:"Welcome username".
How will i do it?
Thank You.

Posted 21-Apr-11 21:31pm

SURBHI TYAGI

Add a Solution

5 solutions

Solution 1

Put a Lable control on the page (which may be invisible initially). On successful log in, get the name of the user from the database and assign it to the label's text. Where's the problem?

Posted 21-Apr-11 21:39pm

Ankur^\m/

v2

Solution 4

Use asp loginview

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.loginview.aspx[^]

http://codeidol.com/asp/essential-asp.net/Security/The-LoginView-and-Other-Controls/[^]

Posted 21-Apr-11 22:19pm

Sreejith Gopinathan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pratik Bhesaniya · Accepted Answer · 2011-04-21T21:52:00

Write below line on your .aspx page :

<asp:Label ID="lblUserName" runat="server" Text="Welcome"></asp:Label>

And write Code in .cs Page :

First Execute query which will check your login and will return you a username of Authorized user and just apply this username to below line,

lblUserName.Text = lblUserName.Text + " " + username;

I hope it will help you.

ngthtra · Accepted Answer · 2011-04-21T21:59:00

in SQL command you check if user name and pass are valid, get Full name of user and save to variable(using query)and if you want only display username without Fullname, you also save this username that user login and then set it to a label or any control which you like. I have some code line to you reference:

// connection string
string fullname, nhom,sex;
string strketnoi = "SELECT UserName,UserID,Pass,USERS.Type,EmpName,Sex FROM USERS,Employee WHERE UserID=EmpID";
SqlCommand sqlcmd = new SqlCommand(strketnoi,sqlconn);
sqlconn.Open();
SqlDataReader sqlread = sqlcmd.ExecuteReader();
while (sqlread.Read())
{
    username = sqlread.GetString(0);
    pass = sqlread.GetString(2);
    if (username.Trim() == txtusername.Text.Trim())
    {
        if (pass.Trim() == txtpass.Text.Trim())
        {
            EmpID = sqlread.GetInt32(1);
            type = sqlread.GetString(3);
            tenEmp = sqlread.GetString(4);
            sex = sqlread.GetString(5);
           // Save info of user to sessions to use to other purpose
            Session["empid"] = EmpID.ToString();
            Session["hoten"] = tenEmp.Trim();
            Session["role"] = type.Trim();
            Session["Sex"] = sex.Trim();
            sqlconn.Close();
            Response.Redirect("Home.aspx");
        }
    }
}
sqlconn.Close();
 fullname=tenEmp ;
lbHello.Visible = true;
lbName.Visible = true;
if (sex.Trim() == "B")
{
    lbHello.Text = "Hello Mr ";
}
else
{
    lbHello.Text =  Hello Ms;
}
lbName.Text = fullname;

leonidasvijay · Accepted Answer · 2011-04-21T23:04:00

When u authenticate a user using login form,then store its name in the session.
Once the session started,u can retrieve its value anywhere until it closes.

XML

<table >
           <tr>
               <td>
                               Email Address</td>
           </tr>
           <tr>
               <td>
                               <asp:TextBox ID="textemail" runat="server" Width="300px"></asp:TextBox>
                           </td>
           </tr>
           <tr>
               <td>
                               &nbsp;</td>
           </tr>
           <tr>
               <td>
                               Password</td>
           </tr>
           <tr>
               <td>
                               <asp:TextBox ID="textpass" runat="server" Width="300px"
                       TextMode="Password"></asp:TextBox>
                           </td>
           </tr>
           <tr>
               <td>

                   &nbsp;</td>
           </tr>
           <tr>
               <td>

                   <asp:Button ID="buttonlogin" runat="server" Text="Login"
                       onclick="buttonlogin_Click" />

               </td>
           </tr>
           <tr>
               <td>

                   &nbsp;</td>
           </tr>
           </table>

C#

class page
{
SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;
protected void Page_Load()
{
 con = new SqlConnection("data source=servername;initial catalog=databasename;integrated security=true");
                con.Open();
}


protected void buttonlogin_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            
                

                cmd = new SqlCommand("select email,password from login where email=@email and 
password=@password" , con);
cmd.Parameters.AddWithValues("@email",textemail.Text);
cmd.Parameters.AddWithValues("@email",textpass.Text);
                dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                       Session["name"]=dr.GetString(0);
                       Response.Redirect("userprofile.aspx");
                    }
                    dr.Close();
                }
}
}
}

and when you redirected to the new userprofile page.Add a label on that page and write this code at page_load

label1.text=Session[name].ToString();

OKK

how we show the name of login person on welcome page?

5 solutions

Solution 2

Solution 3

Solution 5

Solution 1

Solution 4

Add your solution here

Preview 0