Error while accessing session variable stored as a list

Anu

Hi,

I am using an MVC application. I want to display the menu based on the values taken from the database. That menu values should persist till the user logout. That menu values should be there after each redirection. I was saving the data as an array in the session. But not able to use it in the razor page after splitting it into a list. Below is the code used to store the value in session and trying to access it from view page.

Controller method:

public ActionResult Welcome()

{

if(Session["UserName"]!=null)

{

string usrname = Session["UserName"].ToString();

connection();

SqlCommand cmd = new SqlCommand("sp_getLeftLink", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Username", usrname);

con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

string[] Desc=new string[100];

int[] Id = new int[100];

int i = 0;

while (rdr.Read())

{

Id[i] =Convert.ToInt32(rdr[0]);

Desc[i] = rdr[1].ToString();

i++;

}

Session["Id"] = Id;

Session["LinkDesc"] = Desc;

con.Close();

return View();

}

else

{

return RedirectToAction("Index");

}

In the view:

List ids = Session["Id"] != null ? (List)Session["Id"] : null;

List descs = Session["LinkDesc"] != null ? (List)Session["LinkDesc"] : null;

if (ids != null)

{

for (int i = 0; i < 2; i++)

{

@descs[i]

}

But I am getting error like "Unable to cast object of type 'System.Int32[]' to type 'System.Collections.Generic.List`1[System.Int32]'."

[Screen shot attached]

Can someone please help me to fix the issue?

Thanks,

Hanusha

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
hii
now instead of for loop use foreach like
@foreach(var item in Id){
  {
@url.Action("action","controller",new {Id=item})
}
Anu5y ago
Hi Sachin,

Thank alot for your help.

Thanks,
Hanusha
Anu5y ago
Thanks Sachin for looking into this. With the id passing to the controller, I need to display the text also which is store in another list descs[i]

like:

@descs[i]

Thanks,
Hanusha
Anu5y ago
Hi Sachin,

Thanks alot for your help. Your suggestion worked. But now I am getting an error inside the view as "Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index"
Attached is the scrrenshot of the error.

Thanks,
Hanusha
Sachin Singh5y ago
Your error is self explainatory you have stored values as array but converting it into List.
instead of using array use List to store values and there will be no error.
string[] Desc=new string[100];
int[] Id = new int[100];

    //change above To
List<int> Id=new List<int>();
List Desc=new List<string>();