I am having a hard time passing data as a session variable from a SqlDataSource on a masterpage to another sqldatasource on the default page.

<code>

Site2.master

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
                            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                            SelectCommand="SELECT Song.Type, Song.Artist, Song.Title, Song.User# From Song">
                        </asp:SqlDataSource>


Site2.master.cs

protected void Page_Load(object sender, EventArgs e)
    {
Response.Redirect("CB_Default.aspx", true);
}


Default.aspx

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
    
        SelectCommand="SELECT Note.Note#, Note.NoteTitle, Note.NoteText, Note.User# FROM Note WHERE (Note.Note# = @column1)">
    <SelectParameters>
        <asp:SessionParameter Name="column1" SessionField="songNum" />
    </SelectParameters>
</asp:SqlDataSource>

</code>