filtering

V

VJ

the problem i'm having is that i can't get the Sql statement set to
search for Department or Last_Name%..
:(


<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:dbPMAEventsConnectionString %>"
SelectCommand="SELECT [Last_Name], [First_Name], [Title],
[Extension], [Email_Address], [Department] FROM [qryEntire_List] WHERE
(([Department_ID] = @Department_ID) OR ([Last_Name] = @Last_Name%))">
<SelectParameters>
<asp:ControlParameter ControlID="departmentDropdown"
Name="Department_ID" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="lastnameTextbox"
Name="Last_Name" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top