Hello all,
I want to use code behind variable in mysql command in aspx file here are the codes
[U]code behind[/U]
public vgroup as string
vgroup ="1,7"
[U]in aspx [/U]
<asp:SqlDataSource ID="SqlCategoryList" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT * FROM categorymaster WHERE catgroup in ('<%=vgroup %>')">
</asp:SqlDataSource>
Thanks.