basically i have a web app that takes text from the user for a last name. this data is in textbox1. I then want to take this data and search for anything that matches the string within my oracle database. below is what I have for my data connection and query and it is not working.
<asp:SqlDataSource ID="oracleHRP" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT PERSON_ID, LAST_NAME, FIRST_NAME, BU_NAME, JOB_TITLE, PAY_LINKED, PRIMARY_APPT FROM HRREPORT.V_APPT_BASIC WHERE (PAY_LINKED = - 1) AND (PRIMARY_APPT = - 1) AND (LAST_NAME = '%&Name%') ORDER BY LAST_NAME, FIRST_NAME">
<asp:ControlParameter ControlID="TextBox1" Name="Name"
PropertyName="Text" Type="String" />