how to display firstname and last name using label

Question

0.00/5 (No votes)

See more:

Hi friends,

am working on asp.net c#, Sqlserver 2005.

i want to display Firstname and last name of user using label

----------

I have login page, in this i have username and password to login,

on welcome page i have label to display login username.

for example my login username is rahman

and in my database i have my First name as Mohammed and Last name as Rahman

now after login i want to display in welcome page as
Welcome Mr. Mohammed Rahman (FirstName and LastName)

Please help thanks.

Posted 10-Jun-13 21:47pm

Ubaid ur Rahman IT

Add a Solution

2 solutions

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)

Thanks7872 · Accepted Answer · 2013-06-10T21:56:00

Solution 1

I assume you are a beginner. Going to suggest you simplest way so you can get idea how to deal with this type of stuffs.

C#

SqlConnection conn = new SqlConnection();
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring name"].ConnectionString;
conn.Open();
SqlCommand cmd = new SqlCommand("select query for firstname lastname",conn);//advised to use parameterized query
SqlDataReader dr = cmd.ExecuteReader();
if(dr.read)
{
    yourlabel.text="Welcome, Mr." + dr.GetString(0)+" "+ dr.GetString(1);//0 would give you firstname,1 will provide lastname.
}

Posted 10-Jun-13 21:56pm

Thanks7872

Updated 10-Jun-13 22:36pm

v2

Comments

Ubaid ur Rahman IT 11-Jun-13 4:13am

its working fine, but i dont need this welcome mr in this code

yourlabel.text="Welcome, Mr." + dr.GetString(0)+" "+ dr.GetString(1);

can you please take out welcome mr and display first name and last name from this code.

thanks.

Ubaid ur Rahman IT 11-Jun-13 5:02am

ya it shows error after removing welcome ... this is my code.

yourlabel.text= + dr.GetString(0)+" "+ dr.GetString(1);

can you please check this ? if its wrong please help me. am fresher.

Thanks7872 11-Jun-13 5:04am

yourlabel.text= dr.GetString(0)+" "+ dr.GetString(1); + is also highlighted in above updated answer.Try this,it will definitely work.

Abhinav S · Accepted Answer · 2013-06-10T22:11:00

Solution 2

You can store firstname and lastname (after login) in your session.
This can then be accessed on any page you want.

Remember to clear your session once the user logs out.

Posted 10-Jun-13 22:11pm

Abhinav S

Comments

Ubaid ur Rahman IT 11-Jun-13 4:27am

can you please hlep me ...

its working fine, but i dont need this welcome mr in this code

yourlabel.text="Welcome, Mr." + dr.GetString(0)+" "+ dr.GetString(1);

can you please take out welcome mr and display first name and last name from this code.

thanks.

Abhinav S 11-Jun-13 4:34am

I really thing you should try this own your own. Hint - use the string operation subString.
You could infact also use Replace.