Hi John,
Throughout SelectParameters collection:
<asp:SqlDataSource ID="propertyDataSource" runat="Server"
ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
SelectCommand="SELECT * FROM [Properties] WHERE propertyid = @id">
<SelectParameters>
<asp:QueryStringParameter DefaultValue="0" Name="@id"
QueryStringField="id" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
--
Milosz
"Jon Paal" wrote:
how does a querystring value get passed to the selectcommand statement of an asp:SqlDataSource?
<asp:SqlDataSource id="propertyDataSource" Runat="Server"
ConnectionString="<%$ ConnectionStrings:myConnectionString %>"
SelectCommand="SELECT * FROM [Properties] WHERE propertyid = @id " />