Hi all, how do i go about getting a user that type in a persons contact name from the MS Access telephone db and/or by only typing in a persons first 2 or 3 letters of their name? My coding knowledge is lacking just so you guys know.MY current code which if you type in eg. "P" it displays every name that has a character "P" in which is not what I want.
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/Database/phone.mdb" SelectCommand="SELECT [FirstName], [LastName], [ext], [cell] FROM [table] WHERE ([FirstName] LIKE '%' + TextBox1 + '%')"> <SelectParameters> <asp:ControlParameter ControlID="TextBox1" Name="FirstName" PropertyName="Text" Type="String" /> </SelectParameters> </asp:AccessDataSource>
Any help or link to tutorial appreciated.