[Solved] Session values in RadGrid

[Attila]

Hi,

I'm trying to use this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [ProductID], [ProductName], [ProductPrice], [PicName], [ModifiedDate] FROM [Products] WHERE ([UserID] = @UserID)">
<SelectParameters>
<asp:SessionParameter Name="UserID" SessionField="LoginID" Type="Int32" DefaultValue="1" />
</SelectParameters>
</asp:SqlDataSource>

My stored cookie name is: LoginID and the content is: UserGUID=c2a89926-868b-41a2-bad2-9a67fe9c140a&UserID=2

How can I get the UserID session value from my session?

[Attila]

Never mind I'm too tired.....

[Shinu]

Hi,

I guess you want to get the UserID from the Session string. Please take a look into the following sample I tried.

ASPX:

<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server">
    <MasterTableView>
        <Columns>
            <telerik:GridBoundColumn DataField="OrderID">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString3 %>"
    SelectCommand="SELECT [OrderID] FROM [Orders] WHERE ([OrderID] = @OrderID)">
    <SelectParameters>
        <asp:SessionParameter Name="OrderID" SessionField="Login" Type="Int32" DefaultValue="1" />
    </SelectParameters>
</asp:SqlDataSource>

C#:

protected void Page_Load(object sender, EventArgs e)
{
    Session["LoginID"] = "UserGUID=c2a89926-868b-41a2-bad2-9a67fe9c140a&UserID=2";
    Regex regex = new Regex(@"\bUserID=\b");
    string[] substrings = regex.Split(Session["LoginID"].ToString());
    Session["Login"] = substrings[1].ToString();
}

Thanks,
Shinu.