.Net SqlDataSource tag SelectCommand

Question

1

Hi,

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.

edited Jul 10 '09 at 23:20

Canavar
11.4k●2●19●34

asked Jul 10 '09 at 22:59

flavour404
448●1●15

60% accept rate

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 Jul 10 '09 at 23:42

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

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>

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

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>

?

.Net SqlDataSource tag SelectCommand

2 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged asp.net .net sqldatasource or ask your own question.

Hello World!

Related