I have an aspx page that conatain:
<asp:SqlDataSource ID="dsName" runat="server"
ConnectionString="<%$ ConnectionStrings:myConnectionString %>
SelectCommand="SELECT t1.ID, t2.desc FROM table1 t1 JOIN \"10.10.10.10\".dbname.schemaName.table2 t2 ON t1.ID = t2.ID">
I can already see in visual studio that the quotation mark are not reacting as they should.
and when trying to run it I get: "The server tag is not well formed."
If I remove the \" from the string or try to replace " with ' I get incorrect syntax for the sql query.
How can i use place quotation mark in that string?
View Complete Post