Hi all !
I need some clue form u guys !
I have a webform in which i have a textbox in which user is supposed to enter some value.
Once entered, the database will be searched for all those values which are contained in the Textbox and output will be shown in a ListBox.

I am using ASP.NET 1.1 with C# and is unable to get the output.
the Sql query i wrote is :
"SELECT Company_Name FROM CompanyName WHERE Company_Name LIKE '%" &val& "%'";

where val=TextBox1.text

Please somebody provide the solution

Vinay Chugh

If I rest, I will rust ! Let's share the knowledge !

This should work for you:

"SELECT Company_Name FROM CompanyName where Company_Name Like '" &val & "%'";

You aren't very specific as to what your problem is here though, you are using a LIKE here but it sounds like a user may be able to enter multiple values in the textbox. (e.g., Company1, Company2) which then changes your SQL Query to this

"SELECT Company_Name FROM CompanyName where Company_Name IN ('" & val &"')";

Be mindful of special characters in the text box as well, if someone enters Mike's Company that is going to cause your SQL statement to fail because of the aposterphe.

Hope this helps.

-Doug

"The one language all programmers understand is profanity."