how to store sql query result into session variable

Question

0.00/5 (No votes)

See more:

i have this query in sp

SQL

  SELECT [Login_Id]
    ,[User_Name]
    ,[Password]
    ,[Role_Id]
FROM [dbo].[Login]
Where [User_Name] =@User_Name
    and [Password] =@Password

now on i want to save User Id and Role Id into session variable on aspx page how can i do this?

Posted 8-Feb-14 3:50am

Muhamad Faizan Khan

Add a Solution

Comments

Dinesh.V.Kumar 8-Feb-14 9:57am

I am not exactly clear on what you want...but assuming that, on executing the SP you get the result in a data table. After this use the below code
Session["UserID"] = dataTable.Rows[0]["Login_ID"];
Session["RoleID"] = dataTable.Rows[0]["Role_ID"];

Regards

Muhamad Faizan Khan 8-Feb-14 10:48am

Thanks alot

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)

OriginalGriff · Answer 1 · 2014-02-08T04:06:00

Solution 1

If you don't know how to do something basic, then start with google. In this case it leads very quickly here: http://msdn.microsoft.com/en-us/library/ms178581.aspx[^] which explains the whole process.

Posted 8-Feb-14 4:06am

OriginalGriff

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2014-02-08T04:16:00

Solution 2

Execute this query with the help of ADO.NET objects.
With the help of these objects bind results to any variable or DataTable, then store in Session or directly store those values in Session.

You can easily get examples on how to deal with ADO.NET objects, execute queries and fetch the values.

Posted 8-Feb-14 4:16am

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