Author: SpongeBert | Posted on: 9/30/2009 1:23:43 AM | Views : 275

 Hi All,
I have a public property that get's filled in my page_load. I want to use this property in my front aspx page:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:NopSqlConnection %>" SelectCommand="SELECT DISTINCT Name, OptionID FROM BIV_StyleTypeOptions WHERE     (StyleTypeID = 1) AND (GenderID = 1) and (LanguageId = <%lid%>)"></asp:SqlDataSource>
The query runs if i run it manually but I get an sql error: "incorrect syntax near '<'
This is my property:
        private string _lid = "";
        public string lid
        { get { return _lid; } set { _lid = value; } }
      &nbs ...

Go to the complete details ...