Hello all, I know I'm not crazy but this application is getting me there. First off, I am capturing the aspnet_db userID and placing it into a session variable so I can refer to it in my queries. However, what's happening is when I try accessing the value, I get errors:

The server tag is not well formed.

Literal expressions like '<%$ ConnectionStrings:MySQLCN %>' are not allowed. Use <asp:Literal runat="server" Text="<%$ ConnectionStrings:MySQLCN%>" /> instead.

Now this is where the problem comes in. If I execute my query with a static value, all is right with the world. When I try to bring my session variable UserID into the mix, it gives me the errors above.

Visual Element:
<asp:SqlDataSource ID="MySQLCustData" runat="server"
ConnectionString="<%$ ConnectionStrings:MySQLCN %>"
ProviderName="<%$ ConnectionStrings:MySQLCN.ProviderName %>"
                
SelectCommand="SELECT egw_addressbook.n_fn, egw_addressbook.adr_one_street, egw_addressbook.adr_one_street2, egw_addressbook.adr_one_locality, egw_addressbook.adr_one_region, egw_addressbook.adr_one_postalcode FROM egw_addressbook INNER JOIN ewise_device ON egw_addressbook.aspnet_id = ewise_device.aspnet_id WHERE (ewise_device.aspnet_id = <%Session["UserID"])">
</asp:SqlDataSource>

Code Behind:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;

public partial class home : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       Session["UserID"] = Membership.GetUser().ProviderUserKey;
    }
}

Please help and thank you.

Hi,

Use this

bbcompent1:

SelectCommand="SELECT egw_addressbook.n_fn, egw_addressbook.adr_one_street, egw_addressbook.adr_one_street2, egw_addressbook.adr_one_locality, egw_addressbook.adr_one_region, egw_addressbook.adr_one_postalcode FROM egw_addressbook INNER JOIN ewise_device ON egw_addressbook.aspnet_id = ewise_device.aspnet_id WHERE (ewise_device.aspnet_id = <%Session["UserID"].ToString())"

New value is in Bold try this...

Hi

try using

WHERE (ewise_device.aspnet_id = '<%Session["UserID"])' "> 

put the quotes quotation marks

First of all you are missing >

WHERE(ewise_device.aspnet_id = <%Session["UserID"])%>">

Another way of doing this by using SessionParameter, which sets the name of the session variable that the parameter binds to. Try like this..

    <asp:SqlDataSource ID="MySQLCustData" runat="server" ConnectionString="<%$ ConnectionStrings:MySQLCN %>"
        ProviderName="<%$ ConnectionStrings:MySQLCN.ProviderName %>" 
        SelectCommand="SELECT egw_addressbook.n_fn, egw_addressbook.adr_one_street, egw_addressbook.adr_one_street2, egw_addressbook.adr_one_locality, egw_addressbook.adr_one_region, egw_addressbook.adr_one_postalcode FROM egw_addressbook INNER JOIN ewise_device ON egw_addressbook.aspnet_id = ewise_device.aspnet_id 
        WHERE (ewise_device.aspnet_id = ? ">
                <SelectParameters>
            <asp:SessionParameter Name="UserID" SessionField="UserID" DefaultValue="YourDefaultValue" />
        </SelectParameters>
    </asp:SqlDataSource>

budugu:

view plaincopy to clipboardprint?

1. <asp:SqlDataSource ID="MySQLCustData" runat="server" ConnectionString="<%$ ConnectionStrings:MySQLCN %>"  
2.     ProviderName="<%$ ConnectionStrings:MySQLCN.ProviderName %>"   
3.     SelectCommand="SELECT egw_addressbook.n_fn, egw_addressbook.adr_one_street, egw_addressbook.adr_one_street2, egw_addressbook.adr_one_locality, egw_addressbook.adr_one_region, egw_addressbook.adr_one_postalcode FROM egw_addressbook INNER JOIN ewise_device ON egw_addressbook.aspnet_id = ewise_device.aspnet_id   
4.     WHERE (ewise_device.aspnet_id = ? ">  
5.             <SelectParameters>  
6.         <asp:SessionParameter Name="UserID" SessionField="UserID" DefaultValue="YourDefaultValue" />  
7.     </SelectParameters>  
8. </asp:SqlDataSource>  

Well, it makes sense to me but when I try building the page, I get (using MySQL):

in the select statement the where clause is not ended with ')' close the paranthesis.. 

The source you mention was copied from another posting. Intellitype caught that one but I still have the error. I used a vanilla page and got the same error. Here's the code:

        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySQLCN %>" 
            ProviderName="<%$ ConnectionStrings:MySQLCN.ProviderName %>" 
            SelectCommand="SELECT n_fn, adr_one_street, adr_one_street2, adr_one_locality, adr_one_region, adr_one_postalcode, aspnet_id FROM addressbook WHERE (aspnet_id = ?)">
            <SelectParameters>
                <asp:SessionParameter Name="aspnet_id" SessionField="UserID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?)' at line 1

I figured out that I missed putting the name of the parameter after the (aspnet_id = ?) so the entire query clause should read:

<asp:SqlDataSource ID="MySQLCustData" runat="server" ConnectionString="<%$ ConnectionStrings:MySQLCN %>" ProviderName="<%$ ConnectionStrings:MySQLCN.ProviderName %>" 

SelectCommand="SELECT egw_addressbook.n_fn, egw_addressbook.adr_one_street, egw_addressbook.adr_one_street2, egw_addressbook.adr_one_locality, egw_addressbook.adr_one_region, egw_addressbook.adr_one_postalcode FROM egw_addressbook INNER JOIN ewise_device ON egw_addressbook.aspnet_id = ewise_device.aspnet_id WHERE (ewise_device.aspnet_id =  ?aspnet_id)">          
<SelectParameters>
            <asp:SessionParameter DbType="Int32" Name="aspnet_id" SessionField="UserID" />
</SelectParameters>
</asp:SqlDataSource> 

Of course, declare the session variable UserID in code behind like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Security;
using System.Text;

public partial class home : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

       Session["UserID"] = Membership.GetUser().ProviderUserKey;

    }

}