.Net SqlDataSource tag SelectCommand

Question

My question is in regard to the SelectComman in the

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:conStr %>" 
             SelectCommand="SELECT * " +
                            "FROM myTable">
        </asp:SqlDataSource>

Obviously I have given an example but why won't it let me spread the sql statement over a couple of lines?

Thanks, R.

Hi flavour404, it would be nice to upvote for the people who answered your question correct. Just click the up arrow near the answer. And click check sign near the answer to select accepted answer. These are encourages people to answer questions. — Canavar
– Canavar, Commented Jul 10, 2009 at 23:42

Canavar · Accepted Answer · 2009-07-10 23:19:51Z

2

If you want to write your query in multiple lines write it without the concatenation like that :

<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
     ConnectionString="<%$ ConnectionStrings:conStr %>" 
     SelectCommand="SELECT * 
                   FROM myTable">
</asp:SqlDataSource>

answered Jul 10, 2009 at 23:19

Canavar

48.1k17 gold badges94 silver badges126 bronze badges

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

Comments

Quintin Robinson · Accepted Answer · 2009-07-10 23:19:34Z

0

Because you are assigning the value to an attribute of an element in markup. You can certainly do this in the code behind by setting the property, but without spacing instead of code-like concatenation this can't work.

Have you tried:

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
    ConnectionString="<%$ ConnectionStrings:conStr %>"
    SelectCommand=
      "SELECT * 
       FROM myTable
       ...Where...">
</asp:SqlDataSource>

?

answered Jul 10, 2009 at 23:19

Quintin Robinson

82.6k14 gold badges128 silver badges132 bronze badges

Collectives™ on Stack Overflow

.Net SqlDataSource tag SelectCommand

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related