session variables for Datatable.

Question

1.00/5 (1 vote)

See more:

Hi,

Can someone please help me.

I have a usercontrol with gridview and populated by records from a datatable.
After populating the gridview by datatable, I saved the datatable in session variable. Once i clicked the row in gridview i will load another usercontrol and then once i click back button, it will load again the previous usercontrol thats why i save the datatable into session variable so that i don't need to query again from the database.

The system is runnin but the problem is that sometimes when im retrieving the datatable from session variable, it gives me "Stack Empty" error.

Can someone out there enlighten me what's the problem?

Thanks in advance.

Posted 6-Dec-11 4:30am

Hernan K. Cabrera

Add a Solution

Comments

Leeland Clay 6-Dec-11 14:58pm

Can you provide the code that you're using?

Hernan K. Cabrera 6-Dec-11 15:30pm

I provided my code.

I'm thinking of putting a try catch in the else part where the error occurs. In the catch part, I will retrieve again the data from the table but I hope there's a better idea than that.

Hernan K. Cabrera 6-Dec-11 15:20pm

Hi Leeland,

Here's my code.

If Session("VolumeDataTable") Is Nothing Then
If clsDAL.GetDataTable(strQuery, dt) Then
GridView1.DataSource = dt
GridView1.DataBind()
Session("VolumeDataTable") = dt
End If
Else
GridView1.DataSource = CType(Session("VolumeDataTable"), DataTable)
GridView1.DataBind() <-- Error is here
End If

Sergey Alexandrovich Kryukov 6-Dec-11 17:17pm

What that supposed to mean: "I saved the datatable in session variable"?
--SA

Hernan K. Cabrera 6-Dec-11 20:08pm

Hi SAKryukov,

I mean, I assigned the datatable to a session variable.

Leeland Clay 6-Dec-11 17:19pm

Personally, I'm not a fan of casting an object as you assign it to a property. In the Else block, try declaring a DataTable, then casting the session variable to the newly declared datatable, then assign it to the GridView1.DataSource.

Else
Dim dtable As DataTable
dtable = CType(Session("VolumeDataTable"), DataTable)
GridView1.DataSource = dtable

Hernan K. Cabrera 6-Dec-11 20:05pm

Hi Leeland,I did your suggestion but still it sometimes throw an error.

Leeland Clay 7-Dec-11 7:47am

Hi Hernan,
Can you pull the IIS logs for the time that the error occurs and see if there's something happening in the background that is causing this? Normally, I see this error when someone forgets to test whether the session variable is null or not, but you're doing that. My thought is that maybe something is happening at the server level that is erroring out, and this cryptic message is just the result of that.

Hernan K. Cabrera 7-Dec-11 10:01am

Hi Leeland,

Thank you very much for the concern.

I forgot to mention that there are 4 independent processes querying and binding into gridview. And because of that I decided to use threading so that simultaneously the 4 processes are running. But I never knew that this threading will cause stack empty error. In my research, gridview binding should not be done simultaneously with other instances of binding.

Here is the site :
http://stackoverflow.com/questions/6852857/databind-within-parallel-invoke-failing-due-to-stack-empty-error

I'm ok now Leeland, again thank you very much.

Hernan

Leeland Clay 7-Dec-11 10:22am

You're Welcome Hernan. I'm glad you got it figured out. If possible, you should mark the question as resolved so that others can learn from it as well. If that's not an option, I'd suggest copy & paste your previous comment into the solution area so that it shows as answered.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hernan K. Cabrera · Accepted Answer · 2011-12-07T05:27:00

Hi Leeland,

Thank you very much for the concern.

I forgot to mention that there are 4 independent processes querying and binding into gridview. And because of that I decided to use threading so that simultaneously the 4 processes are running. But I never knew that this threading will cause stack empty error. In my research, gridview binding should not be done simultaneously with other instances of binding.

Here is the site :
http://stackoverflow.com/questions/6852857/databind-within-parallel-invoke-failing-due-to-stack-empty-error

I'm ok now Leeland, again thank you very much.

Hernan

session variables for Datatable.

1 solution

Solution 1

Add your solution here

Preview 0

session variables for Datatable.

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us