sqlcommand where condition use dynamic value

[martin1]

Hi, All,

In the aspx page sqlDataSource section, I try to use dynamic value in
selectCommand where condition, anyone knows how? or correct foramt to use the
dcnid value

Dim dcnid=12

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM table1 where id =dcnid? ">

</asp:SqlDataSource>

Thanks