Datatable in view state not working

Question

0.00/5 (No votes)

See more:

Hello Im having an issue saving my dataTable to a ViewState. GetDataTable takes a SQL command and retrieve data from database. The problem I am facing is that the ViewState is NOT storing the datatable in the code below, however the dataTable has data stored within. I am using VB to write this code.

VB

Dim originDt As New DataTable()
originDt = GetDataTable()
ViewState("orignDt") = originDt

In another method I am trying to load the ViewState to a new datatable.

VB

If Not (ViewState("originDT") Is Nothing) Then
            Dim uploadDT As New DataTable
            uploadDT = DirectCast(ViewState("originDT"), DataTable)
            ReceiptGrid.DataSource = uploadDT
            ReceiptGrid.Rebind()
        End If

What I have tried:

I've tried to search other post for problems however it seems that everything I have is how it is suppose to be done :/

Posted 28-Oct-16 7:55am

Member 12821924

Add a Solution

1 solution

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)

Vincent Maverick Durano · Answer 1 · 2016-10-28T10:32:00

I'm not sure if the issue is about the case sensitivity of your ViewState keys. You set the value to ViewState("orignDt") and you get the value using ViewState("originDT") - noticed the capital T.

Try to fix that so it will match the case. Also try to debug your codes, step into it and see if it hits in the line where you set the value to the ViewState. Do the same debugging for checking the value from ViewState.

Edit: Actually you had a different name of your ViewState key. The first one is misspelled. It should be ViewState("originDt") and not ViewState("orignDt") - Noticed the missing i.