search box

rizp · September 6th, 2004, 06:30 PM

Hi -

I have a few problems....1st creating a search box - this is what i have so far:

<HTML>
<HEAD>
    <script language="vb" runat="server">

    Sub Page_Load(Sender As Object, E As EventArgs)

        Dim MyConnection As SqlConnection = New SqlConnection("server=(local);database=XXX;Trusted _Connection=yes")

        Dim MyCommand As SqlCommand = New SqlCommand("select location from location where location like'%' & TextBox1.Text & '%'", MyConnection)

        MyConnection.Open()
        Dim dr As SqlDataReader = MyCommand.ExecuteReader()
    End Sub

    </script>
    </HEAD>
    <body>
        <form runat="server">
        <asp:Label id="Label1" runat="server" Font-Names="Verdana" Font-Size="X-Small" Font-Bold="True"
                style="Z-INDEX: 100; LEFT: 16px; POSITION: absolute; TOP: 24px">Search Location</asp:Label>
            <asp:TextBox id="TextBox1" runat="server" style="Z-INDEX: 101; LEFT: 16px; POSITION: absolute; TOP: 48px"></asp:TextBox>
            <asp:Button id="Button1" runat="server" Text="Search" style="Z-INDEX: 102; LEFT: 184px; POSITION: absolute; TOP: 48px"></asp:Button>
        </form>
    </body>
</HTML>

The error messages state that the column prefix 'TextBox1' does not match with a table name or alilas name use in the query. From this i am guessing that i have referenced TextBox1 in the wrong place. Can someone guide me in the right direction here please??

Once I have this search box set up, i need the results of the search to be in a listbox (when submit selected). Any suggestions on how to go about doing this??

I then need to be able to select the chosen result and submit it so that it is pasted (on the same page) in a textbox.

Any suggestions??

rizp

happygv · September 6th, 2004, 06:48 PM

That is because you have used Single quotes instead of Double quotes in there, so that TextBox1.Text has become a constant and LIKE expects the string to be formatted as '%something%', which in your case shows up as '%'TextBox1.Text'%' is not valid and when searched in the table, it results in error.

Try this.

Code:

Dim MyCommand As SqlCommand = New SqlCommand("select location from location where location like'%" & TextBox1.Text & "%'", MyConnection)

Cheers!

_________________________
- Vijay G
Strive for Perfection

rizp · September 6th, 2004, 07:38 PM

that seems to have solved the erro message, however, when i search, i cant see any results - why is this???

Any suggestions about the questions on the post?

rizp

rizp · September 7th, 2004, 06:59 AM

Hi

Please can anyone suggest a solution to the problems i have above??

thanks,
rizp

melvik · September 8th, 2004, 01:08 AM

is ur Solution Config set to DEBUG?

Always:),
Hovik Melkomian.

rizp · September 10th, 2004, 04:49 PM

Hi

why, should it be set to debug??

rizp