Can we search multiple data in single text box

Question

I created web application in that can we search multiple data with single text box and display in grid view when click search button. for example in text box if i put Sai  Supraja will it show the result for both the names. can anyone suggest me how to do that. Thanks

Supraja · Answer

Hi Venkata i want to filter from gridview using asp.net the below code is the one which i am using now to filter the reference number but it filter only one data i want to filter 2 data. f txtReferenceNo.Text  Then If filter.Trim()=  Then filter= WHEREReferenceNo=' &txtReferenceNo.Text& ' Else filter = filter &  AND ReferenceNo =' & txtReferenceNo.Text & ' End If End If

Munesh Sharma · Answer

http://www.aspsnippets.com/Articles/Search-records-in-GridView-and-highlight-results-in-ASPNet-using-C-and-VBNet.aspx

Venkata Subbareddy · Answer

Hi suraja Try This And let me know DataSourceFile.Filter=firstColumnId='&textbox.text&'OR SecoundId ='&textbox.text & '

Supraja · Answer

Hi Venkata where to add that code what is the datasourcefile.filter ?? can you explain becuase when i use this code it shows error in datasource.

Munesh Sharma · Answer

Sai  Supraja are in different column of gridview

Venkata Subbareddy · Answer

Hi Supriya Try this link http://www.aspforums.net/Threads/175367/Search-Multiple-Column-fields-of-GridView-on-single-TextBox-KeyPress-in-ASPNet/