First I want to thank you all.I am getting all responses at this Daniweb :)
My problem is that I have a sql statement where I want to add where clause in case of dropdown is changed.
My database connection part:
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/_database.accdb" SelectCommand="SELECT * FROM [Devices] WHERE ([feature1] = ?)">
but I don't want that * WHERE ([feature1] = ?) * exist there.
I want that it only added there when i click to the below radio button
<asp:RadioButtonList ID="feature1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource10" DataTextField="feature1" DataValueField="feature1"> </asp:RadioButtonList>
As far as I understand I should write some
RadioButton Control OnCheckedChanged Event and some code in the select command part within the sql but I don't know how i will do that or is it doable within the sql statement part ?