Displaying Search Results in Other page

I have a ASP.Net Page which includes a DropDown and the Selected item is displayed in a label:

Private Shared Sub DisplaySelection(dropdownlist As Telerik.Web.UI.RadDropDownList, label As Label)

        If dropdownlist.SelectedText <> [String].Empty Then

            label.Text = dropdownlist.SelectedText

        Else

            label.Text = "RadDropDownList is empty"

        End If

    End Sub

    Protected Sub RadDropDownList2_SelectedIndexChanged(sender As Object, e As DropDownListEventArgs) Handles RadDropDownList2.SelectedIndexChanged
        DisplaySelection(RadDropDownList2, Label2)
    End Sub
*************************************************************
I need to show the resulting record in a seperate page.  The query I have in the Submit button is as follows:
 Response.Redirect("SearchByCity.aspx?City=" & Convert.ToString(Me.Label2.Text))
***********************************************************************

This is way wrong and im not sure how is should be.  

The result page "SearchByCity.aspx" contains the following SQL DataSource:

 <asp:SqlDataSource ID="SqlDataSource3" runat="server"
            ConnectionString="<%$ ConnectionStrings:dbMyCMSConnectionString %>"
           SelectCommand="SELECT
      UserProfiles.UserId
    , UserProfiles.City
    , Locations.city
    , Locations.UserId
    , Locations.id
FROM UserProfiles
      INNER JOIN Locations
            ON Locations.UserID = UserProfiles.UserID
                  AND (Locations.City = @City
                  OR UserProfiles.City = @City)">
           <SelectParameters>
               
               <asp:Parameter Name="City" />
               
           </SelectParameters>
                      </asp:SqlDataSource>
misnsttAsked:
Who is Participating?
 
Alan WarrenApplications DeveloperCommented:
Hi misnstt,

You could set some session variables on RadDropDownList2_SelectedIndexChanged
Session("MySessionParam")=RadDropDownList2.SelectedItem.ToString
' Redirect to results page...

Open in new window

Then modify the SqlDataSource SelectParameters on the results page to consume the Session variables you set on the previous page by declaring them as SessionParameters
      <asp:SqlDataSource ID="SqlDataSource1" runat="server" >
        <SelectParameters>
          <asp:SessionParameter Name="MySqlParamName" Type="String" SessionField="MySessionParam" Size="50" DefaultValue="" />
        </SelectParameters>
      </asp:SqlDataSource>

Open in new window

You should probably clear the session variables using the SQLDataSource_Selected Event
  Protected Sub SqlDataSource1_Selected(sender As Object, e As SqlDataSourceStatusEventArgs)
    '' clear the session params
    Session("MySessionParam") = ""
  End Sub

Open in new window

Also it's a good plan to make sure the session variables exist for each page prior to attempting to reference them
  Protected Sub Page_Init(sender As Object, e As EventArgs) Handles Me.Init
    If Session("MySessionParam") Is Nothing Then
      Session("MySessionParam") = ""
    End If

  End Sub

Open in new window

Respectfully yours,
Alan
0
 
Jerry MillerCommented:
I normally do that sort of thing in a ViewState variable. The main issue is that you don't want to store a large variable like a big array and don't store any sensitive information. Large arrays take up a lot of memory and the ViewState can be decoded.

Overview:
http://msdn.microsoft.com/en-us/library/ms227551(v=vs.85).aspx

Look at disadvantages:
http://msdn.microsoft.com/en-us/library/z1hkazw7(v=vs.85).aspx
0
 
misnsttAuthor Commented:
Hello thanks for this information however I need first to know how to query the SQL datasource on ny  SearchByCity.aspx page.  My current query on the submit button is :

Response.Redirect("SearchByCity.aspx?City=" & Convert.ToString(Me.Label2.Text))

And this is not correct.  Im not sure what needs to be changed to make it work.  

Thanks
0
 
CodeCruiserCommented:
What do you mean by it being not correct?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.