calling querystring within a db query syntax

[ifntech]

This is what I was trying, the syntax will not run. What is the proper way to request myvalue within the select command.
VS underlines & myvalue &

<!--<script >
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myvalue as string = request.querystring("value")
End Sub
</script>-->
<asp:SqlDataSource ID="SqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:testConnectionString1.ProviderName %>" SelectCommand="SELECT * From table WHERE (table.column1 = N' & myvalue & '">
</asp:SqlDataSource>

 

[tperri]

well what object are you using the SqlDataSource with?

 

[ifntech]

That's the code I use SqlDataSource with -

<asp:FormView
ID="FormView" runat="server" DataSourceID="SqlDataSource1">

<ItemTemplate>
<asp:Label ID="label"
Text='<%# Bind("column2")%>'></asp:Label>
</ItemTemplate>

</asp:FormView>