I am having some trouble in my search.aspx page (Search Page)
This is my code:
When I type the first name in text box...It's Working the same when i type the last name.
But when i'm trying to combine them such us I'm going to type in textbox : "George Santos" the result is "No data found"??
Combing two columns returns to null?? How to do it?
This is my code:
Code:
<asp:AccessDataSource runat="server" ID="AccessDataSource1" DataFile="_private/records.mdb" SelectCommand="SELECT * FROM [DriversRecords] WHERE ([LastName] LIKE '%' + ? + '%') OR ([FirstName] LIKE '%' + ? + '%')"> <SelectParameters> <asp:formparameter FormField="LastName1" Name="FirstName" Type="String" /> <asp:formparameter FormField="LastName1" Name="LastName" Type="String" /> </SelectParameters> </asp:AccessDataSource>
But when i'm trying to combine them such us I'm going to type in textbox : "George Santos" the result is "No data found"??
Combing two columns returns to null?? How to do it?
Comment