How to store multiple value in session

Question

0.00/5 (No votes)

See more:

i am creating an application in which i retrive data from database. i am store data in session variable and display a data but session display only one record. but in database contains 10 record . i want session should display 10 record.

C#

protected void Page_Load(object sender, EventArgs e)
   {
       SqlConnection con = new SqlConnection("Data Source=Aarambh;Initial Catalog=rebuild_technology;Integrated Security=True");
       SqlCommand cmd = new SqlCommand("select * from content_managment ", con);
       DataSet ds = new DataSet("temp");
       SqlDataAdapter ad = new SqlDataAdapter();

       ad.SelectCommand = cmd;
       ad.Fill(ds);
      // DataRow dr = ds.Tables[0].Rows[0];
       Session["divhtml_heading1"] = ds.Tables[0].Rows[0];
      // Session["divhtml_heading2"] = dr["divhtml_content"].ToString();

   }

Posted 15-Jun-12 19:38pm

Manohar Khillare

Add a Solution

4 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)

Prosan · Answer 1 · 2012-06-15T19:59:00

Solution 2

you can store whole datatable in session and when you getting data then cast session in datatable. like that

C#

Session["SessionName"] = dt; // dt is data table

// get data like this

DataTable Dtbl= (DataTable)Session["SessionName"];

Posted 15-Jun-12 19:59pm

Prosan

Comments

VJ Reddy 16-Jun-12 2:02am

Good answer. 5!

Sandeep Mewara · Answer 2 · 2012-06-15T20:03:00

Solution 4

Session["divhtml_heading1"] = ds.Tables[0].Rows[0];
You stored one Row value in session and so you just get back one!

Do:

C#

Session["divhtml_heading1"] = ds.Tables[0];
// Later to retrieve it
DataTable dt = (DataTable)Session["divhtml_heading1"];

Refer:
MSDN: ASP.NET Session State Overview[^]

Posted 15-Jun-12 20:03pm

Sandeep Mewara

Comments

VJ Reddy 16-Jun-12 2:04am

Good answer. 5!

Sandeep Mewara 16-Jun-12 4:43am

Thanks VJ.

Yatin chauhan · Answer 3 · 2012-06-15T19:56:00

Hello Manohar

Just try this

C#

SqlCommand cmd1 = new SqlCommand("select * from content_managment ", con);


SqlDataReader dr1 = cmd1.ExecuteReader();
var yourList = new List<int>();
if (dr1.HasRows)
{
    while (dr1.Read())
    {
       yourList.Add(Convert.ToInt32(dr1[0]));


    }
}
Session["divhtml_heading1"] = yourList;
dr1.Close();
cmd1.Dispose();

**AmitGajjar** · Answer 4 · 2012-06-15T20:01:00

Hi,

because you have selected a row to store in your session variable.

C#

Session["divhtml_heading1"] = ds.Tables[0].Rows[0];

instead

C#

Session["divhtml_heading1"] = ds.Tables[0];

use above code and iterate through all the rows,

although this is not the right way of storing data in session variable and display on your page. instead you can return List of your data and bind it with your page.

Let us know why you would like to store in session ? there should be some strong reason for storing information in session.

thanks
-Amit

How to store multiple value in session

4 solutions

Solution 2

Solution 4

Solution 1

Solution 3

Add your solution here

Preview 0