How fetch SQL Data compare with ASP.Net Label

Question

4.00/5 (1 vote)

See more:

I have a Asp.Net Label CurrentUser.Label.
I have to show the SQL table that have the same value in SQL table Cell
A table contain username, name, mobile, email, phone.
In Asp.net i have a Label that contain Log In Username which user has log on the site.
How can i show the current user Name, Username, Phone, Mobile, Email on asp Page?

Posted 12-Jun-14 1:24am

ashvin.saini

Add a Solution

Comments

ZurdoDev 12-Jun-14 7:26am

Where are you stuck? Use the SqlConnection and SqlCommand classes and the SqlDataReader to get the data from the database and then set the values.

ashvin.saini 21-Jun-14 3:11am

It just print first row from sql table.

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-06-12T04:30:00

Solution 1

Use ADO.NET classes to connect, create command and operate on data.

If the UserName is Unique in your Database, then you should query your Database with the following SQL query...

SQL

SELECT * FROM yourTableName WHERE UserName = @UserName

You need to pass parameter @UserName with Value as the Label Text.

Before all this, search how to work with ADO.NET and how to pass parameters for a query. You will get many examples on Google.

Posted 12-Jun-14 4:30am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

ashvin.saini 21-Jun-14 3:12am

Yes but it is not working.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 21-Jun-14 11:47am

I am not sure what you have tried. Can you please show me the code snippet?