Incorrect syntax near '<' error while tring to access ASP.Net variable from code behind

Question

This fix possibly pretty easy. When I copy and paste it works, but my SelectCommand is too long and I need to get it from the code behind.

Aspx file:

<asp:SqlDataSource ID="sds_Dashboard" runat="server" ConnectionString="<%$
                   ConnectionStrings:MyDbConn %>"
                   SelectCommand="<%= SelectCommand.ToString() %>">

Cs file:

public partial class Dashboard : System.Web.UI.Page
{
    public string SelectCommand = "Select * from .....";
}

Error:

Incorrect syntax near '<'.

@Despertar If I write my connection string directly to the selectcommand then it works so I didn't think that it is related to $ — HOY
– HOY, Commented Feb 1, 2013 at 6:37
The '$' is black and not the expected red color. Which is the point I think he was trying to make... — Brian
– Brian, Commented Feb 1, 2013 at 6:39

Software Engineer · Accepted Answer · 2013-02-01 06:46:15Z

1

You can set SelectCommand of SqlDataSource in code-behind's Page_Load instead of aspx file:

sds_Dashboard.SelectCommand = "Select * from .....";

answered Feb 1, 2013 at 6:46

Software Engineer

3,9861 gold badge28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aniket Inge · Accepted Answer · 2013-02-01 06:42:16Z

0

There maybe a constant newline in your code here:

ConnectionString="<%$ //HERE
                   ConnectionStrings:MyDbConn %>"

. But my concern is a little different, why can't you custom define your select statement in the window that looks like this:

enter image description here

Instead of in the code-behind?

answered Feb 1, 2013 at 6:42

Aniket Inge

25.9k5 gold badges54 silver badges80 bronze badges

Comments

Harold Javier · Accepted Answer · 2013-02-01 07:52:40Z

0

Try to change your ASP.NET code into something like this:

<asp:SqlDataSource ID="sds_Dashboard" runat="server" ConnectionString="<% ConnectionStrings:MyDbConn %>" />

Then from Code Behind, After some If/Else blocks, try this:

sds_Dashboard.SelectCommand = "Select * FROM ...";

It should work fine now.

Thanks.

answered Feb 1, 2013 at 7:52

Harold Javier

8972 gold badges7 silver badges16 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near '<' error while tring to access ASP.Net variable from code behind

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related