<div>
Hi!<br />
I guess you need to set value for parameter, because it will not be binded automatically:<br />
&lt;asp:Parameter Name=&quot;Culture&quot; Type=&quot;String&quot; &nbsp;DefaultValue=&quot;&lt;%= this.Culture %&gt;&quot;/&gt;
</div>


Hi!
I guess you need to set value for parameter, because it will not be binded automatically:
<asp:Parameter Name="Culture" Type="String"  DefaultValue="<%= this.Culture %>"/>

<div>
it looks like it is passing that literal value.<br />
<br />
This is what it looks like from the sql server trace<br />
exec usp_ListSubProductsByProdu<wbr />ctID @ProductID=1156,@Culture=N<wbr />'&lt;%= this.Culture %&gt;'
</div>


it looks like it is passing that literal value.

This is what it looks like from the sql server trace
exec usp_ListSubProductsByProductID @ProductID=1156,@Culture=N'<%= this.Culture %>'

<div>
<div class="content wysiwyg-content">
I have not used a sql data source before and I'm doing some updates on an existing web site.<br />
In the basepage class that all of the aspx pages inherit from is a property called Culture of type string.<br />
I added the parameter below, is this correct? Do I need to specify anything else or will it extract the value from the property?<br />
&nbsp;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;SelectParameters&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;asp:QueryStringParameter Name=&quot;ProductID&quot; QueryStringField=&quot;prodid&quot; Type=&quot;Int32&quot; /&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;asp:Parameter Name=&quot;Culture&quot; Type=&quot;String&quot; /&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/SelectParameters&gt;
</div>
</div>


I have not used a sql data source before and I'm doing some updates on an existing web site.
In the basepage class that all of the aspx pages inherit from is a property called Culture of type string.
I added the parameter below, is this correct? Do I need to specify anything else or will it extract the value from the property?
 
		<SelectParameters>
			<asp:QueryStringParameter Name="ProductID" QueryStringField="prodid" Type="Int32" />
			<asp:Parameter Name="Culture" Type="String" />
		</SelectParameters>

Sql Datasource and Parameters

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications