multicolumn search in single Textbox. c#asp.net

vinod mishra

13y2.9k.NET

Dear Sir Help me … c#
I have a textbox name TextBox1.Text. When I typing in Textbox the some filed value are autofill from database. i.e.
In textbox accept both value for example when I type Keyword @Name it show the Name of all Employees
In textbox accept both value for example when I type Keyword @CompanyName it show the List of Company.

Example: My Name is @Name and I Worked in @companyName joining date is @JoinDate to @tillDate.

@ID	@Name	@CompanyName	@JoiningDate
1	vinod	ABC	01-Jan-2010
2	Raju	AAA	31-Dec-2011

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

venkata kumar13y ago
hi
use the fallowing query

select *from tablename where columnname1=@perametername or columnname2=@perametername or columnname3=@perametername or columnname4=@perametername
0
Iftikar Hussain13y ago
please refer the below link

http://www.asp.net/ajaxlibrary/act_autocomplete_simple.ashx

Regards,
Iftikar
0
vinod mishra13y ago
Example: My Name is @Name and I Worked in @companyName joining date is @JoinDate to @tillDate. Sir, how can autofill textbox during typing.
0
Iftikar Hussain13y ago
that it I got it. you try in your sql query like this

string searchData;
select *from yourtable where (name like searchData+'%' or compnayname like searchData+'%')

Regards,
Iftikar
0
vinod mishra13y ago
when user type @Name and give space Value of Name Coloumn (as a List show user select any one) is fill and when he type @companyName and give space value of CompanyName column is fill Note : @Name, @ Compnayname is the Column of Database
0
Iftikar Hussain13y ago
Hi,
How you will distinguish weather user has typed Name or Company name?

Regards,
Iftikar
0