General discussion

Locked

Problem with SessionState/ViewState

By jeff_boykin ·
The answer to this is probably something I'll go d'oh! over once I see it but here's my problem:

I'm trying to use SessionState or ViewState to pass a variable back to the same page so that the same page can pull up different sets of data. This way I don't have to code 1500 different pages. Unfortunately the page has to be refreshed before the values will pass. Unfortunatly I have found several references to this on the net but no solutions. Passing the SessionState to another page works fine but I cannot pass the SessionState or the ViewState immediately back to the originating page. I could due this through the URL but I don't the data visible.
My code is somewhat simple because I wanted to see if this would work before I decided to use it:
dim searchString as string
dim typeString as string

If Not IsPostBack Then
'set sql query
OleDbDataAdapter1.SelectCommand.CommandText
= "SELECT tblBuildings.fldBuilding,
tblBuildings.fldBuildingKey,
tblContacts.fldContactKey,..."
'fill
OleDbDataAdapter1.Fill(PdDataSet1)
Page.DataBind()

Response.Write("Session ID = " &
Session.SessionID & " -- ")
Response.Write("Search String = " & ViewState
("searchString"))

Else
'load viewstate variables
searchString = ViewState("searchString")
typeString = ViewState("typeString")

'set new sql query
OleDbDataAdapter1.SelectCommand.CommandText
= "SELECT tblBuildings.fldBuilding,
tblBuildings.fldBuildingKey,
tblContacts.fldContactKey,
tblDepartments.fldPrimaryKey FROM
tblBuildings..."

'fill
OleDbDataAdapter1.Fill(PdDataSet1)
Page.DataBind()
Response.Write("Search String = " & ViewState
("searchString"))

End If
End Sub

Private Sub searchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchButton.Click

typeString = searchText.Text
ViewState("typeString") = typeString
Session.Add(typeString, typeString)

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums