In-line code in <asp:SqlDataSource SelectCommand tag

F

Fred Dag

Hello,

When I use the following code,

<asp:SqlDataSource ID="CrescendoWebSqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:Crescendo WebConnectionString1 %>"

SelectCommand="SELECT [CatalogueItemID], [CatalogueItemTitle],
[CatalogueItemDescription], [CatalogueItemImage],
[CatalogueItemMYOBItemNumber] FROM [CatalogueItem] WHERE CatalogueItemTitle
LIKE '<%=HttpContext.Current.Request.QueryString["Index"]%>'" >

</asp:SqlDataSource>



I get the error Server tags cannot contain <% ... %> constructs.


I have tried to do this in-line by changing the quoting order etc. I have
also searched the net but have problems finding relevant information.

I am rather new to ASP.NET and its quite a steep learning curve. Especially
without a book dedicated to the subject. I am having to learn by doing. Its
very hard creating a search to find information on "<%" for example wereas
it would be explained in order in reference book in order. Is there a good
ASP.NET reference book. I need a reference book. I don't have time for a
tutorial book. I'm looking at Pro ASP.NET 2.0 in C# 2005 September 2005 how
was his 1st edition?

Is it possible to do this inline? If not how do I change the SelectCommand
from using code behind? The object ID=CrescendoWebSqlDataSource doesn't
exist in terms of intellisence.



Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,774
Messages
2,569,599
Members
45,165
Latest member
JavierBrak
Top