How to use session value in SQL query?

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

i have a master page in master page have a login and logout session this session named is session["user"] .

i want to use session["user"] in query for a label message print.

What I have tried:

SqlCommand cmd = new SqlCommand("select id_users from users where usermail=@user ", con);
        cmd.Parameters.AddWithValue("@user",Session["user"]);

Posted 10-Jan-17 11:15am

Member 12677198

Updated 17-Jan-17 17:38pm

v3

Add a Solution

Comments

[no name] 10-Jan-17 20:47pm

And? Do you have an actual question?

Afzaal Ahmad Zeeshan 11-Jan-17 9:36am

~~Never mind~~.

Richard Deeming 11-Jan-17 12:11pm

What's wrong with the code you posted? Do you get an error?

Maciej Los 12-Jan-17 3:02am

Can you be more specific than that: "i want to use session["user"] in query for a label message print."? Your code is irrelevant to your question.

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)

Member 11471318 · Answer 1 · 2017-01-11T01:21:00

Solution 1

try this

int userID = Convert.ToInt32(HttpContext.Current.Session["UserID"]);

Posted 11-Jan-17 1:21am

Member 11471318

Comments

Afzaal Ahmad Zeeshan 11-Jan-17 9:35am

~~Never mind~~.

Richard Deeming 11-Jan-17 12:09pm

Where?

Maybe I'm going blind, but I've looked at all revisions of the question, and I can't see any mention of jQuery.

Afzaal Ahmad Zeeshan 11-Jan-17 12:10pm

I mistook SQL query for jQuery. -_- Sorry.

Richard Deeming 11-Jan-17 12:11pm

Easily done. :)

Member 12677198 11-Jan-17 11:24am

i improved my question please read it again

Vincent Maverick Durano 12-Jan-17 22:30pm

what do you want to print in the label? Please be more specific.

Ramesh Kumar Barik · Answer 2 · 2017-01-17T17:38:00

After logging to the application if you store user info in the session variable like Session["User"] = "UserName" then you can access this session variable through out the page.
So if you want to print in user information in the page then you can use this syntax.

lblID.text= Convert.Tostring(Session["User"]);

If You want to pass to the sql server as per your example.

SqlCommand cmd = new SqlCommand("select id_users from users where usermail=@user ", con);
cmd.Parameters.AddWithValue("@user",Convert.Tostring(Session["User"]));