Use variable from the code behind

[skiabox]

I am using this variable from the code behind :

public string UserID; //globally declare the UserId 
    protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        MembershipUser myObject = Membership.GetUser();
        UserID = myObject.ProviderUserKey.ToString();    
    }

I am trying to use the variable in the INSERT command in the aspx file but it seems that the following command does not work,any ideas why?

InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '<%=UserID %>')"

Thanks!

[MrMancunian]

I am using this variable from the code behind :




public string UserID; //globally declare the UserId
protected void RadGrid1_PreRen der(object sender, EventArgs e)
{
MembershipUser myObject = Membership.GetU ser();
UserID = myObject.Provid erUserKey.ToStr ing();
}

I am trying to use the variable in the INSERT command in the aspx file but it seems that the following command does not work,any ideas why?

InsertCommand=" INSERT INTO table (column1, column2) VALUES (value1, '<%=UserID %>')"


Thanks!

The variable holding the userID is inserted as a string now, so it litterally tries to enter <%=UserID %>. You'll have to concatenate the value. Something like this:

InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '" & <%=UserID %> & "')"

Steven

[skiabox]

If I use this one it causes an error to the whole SqlDataSource tag!
:(
Thnx anyway!

[jkmyoung]

Assuming this is Java and not VB, use + instead of &.

[Plater]

yes, try this:

InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '" + <%=UserID %> + "')"

And if not, maybe this:

InsertCommand="INSERT INTO table (column1, column2) VALUES (value1, '" + UserID + "')"