multicolumn search in single Textbox. c#asp.net

Question

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

venkata kumar · Answer

hi use the fallowing query select *from tablename where columnname1=@perametername or columnname2=@perametername or columnname3=@perametername or columnname4=@perametername

Iftikar Hussain · Answer

please refer the below link http://www.asp.net/ajaxlibrary/act_autocomplete_simple.ashx Regards Iftikar

vinod mishra · Answer

Example: My Name is @Name and I Worked in @companyName joining date is @JoinDate to @tillDate. Sir how can autofill textbox during typing.

Iftikar Hussain · Answer

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

vinod mishra · Answer

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

Iftikar Hussain · Answer

Hi How you will distinguish weather user has typed Name or Company name? Regards Iftikar