Weird SQL Exception in SqlDataSource

Question

I have an issue with trying to get a SqlDataSource working. here is the ASP.net code:

    <asp:SqlDataSource id="SqlDataSource2" runat="server"
           ConnectionString="<%$ ConnectionStrings:connection %>"
           SelectCommand="SELECT [term] [FROM[Ceremony]] order by term">
    </asp:SqlDataSource>

The exception Detail is: System.Data.SqlClient.SqlException: unclosed quotation mark after the character string 'FROM [Ceremony] order by term'

I just don't really know what is wrong with the asp.net code? my C# code is working, and the SQL server is up and running. I go into the SQL tool to test out the select command and it works! If anyone can point out any issues of this code that would be great!

p.s. the connection string works fine also.

Cam Bruce · Accepted Answer · 2014-01-29 19:55:54Z

4

The brackets around the FROM clause are not necessary. You only need to use them when your column/table names have spaces or they are a reserved SQL keyword.

Change SQL to:

SELECT [term] FROM [Ceremony] order by term

answered Jan 29, 2014 at 19:55

Cam Bruce

5,68924 silver badges37 bronze badges

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

1 Comment

Sovr Sov Over a year ago

thank you for replying so fast, I will try it out :-)

mason · Accepted Answer · 2014-01-29 19:56:23Z

2

Try this...

<asp:SqlDataSource id="SqlDataSource2" runat="server"
           ConnectionString="<%$ ConnectionStrings:connection %>"
           SelectCommand="SELECT [term] FROM [Ceremony] order by term">
    </asp:SqlDataSource>

You had a weird nested bracket syntax. Don't wrap the "FROM" word in brackets.

answered Jan 29, 2014 at 19:56

mason

32.8k12 gold badges83 silver badges127 bronze badges

Comments

Kaptan · Accepted Answer · 2014-01-29 20:03:45Z

0

<asp:SqlDataSource id="SqlDataSource2" runat="server"
           ConnectionString="<%$ ConnectionStrings:connection %>"
           SelectCommand="SELECT [term] FROM[Ceremony] order by [term]">
    </asp:SqlDataSource>

If term and Ceremony are not a keyword then i think do not need to include []

answered Jan 29, 2014 at 20:03

Kaptan

3362 silver badges11 bronze badges

Collectives™ on Stack Overflow

Weird SQL Exception in SqlDataSource

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related