Connecting Tech Pros Worldwide Help | Site Map

Highlight search text in datagrid

Savvas
Guest
 
Posts: n/a
#1: Nov 15 '06
Hi,

I am using VB.Net 2005 for a windows application. The application was
actually upgraded from vb.net 2003.


I have a search field which is used as a parameter to search all
datagrid columns. According to this parameter, the dataset and datagrid

shows only the columns where the search parameter applies. The code is
the following under the txtSearch_TextChanged event:


Me.dtsPurchasesMain.Clear()


Me.adpPurchasesMain.SelectCommand.Parameters("invo iceNo").Value =
Me.txtSearch.Text


Me.adpPurchasesMain.SelectCommand.Parameters("comp anyName").Value =
Me.txtSearch.Text


Me.adpPurchasesMain.SelectCommand.Parameters("cate goryName").Value =
Me.txtSearch.Text


Me.adpPurchasesMain.SelectCommand.Parameters("pSer ialNo").Value =
Me.txtSearch.Text


Me.adpPurchasesMain.SelectCommand.Parameters("pMod el").Value =
Me.txtSearch.Text


Me.adpPurchasesMain.Fill(Me.dtsPurchasesMain.Purch asedProducts)


What I want to do is to highlight the words (or only the searched text
that is contained in the word) in the datagrid. I found similar code
for ASP.NET (dataItemBound event) but not for windows applications.


Please help, thanks.


Savvas

Closed Thread