appliying a RowFilter from a textbox value in VB.net

ABOU · 04-30-2008, 06:02 PM

i am trying to apply a row filter to a dataset

using the following code:

Code:

DV_CP.RowFilter = "[CID] like 'C002' "

I can filter the content of the CID column to all entries that match C002. C002 being a pre-specified ID.

Say i wanted to use a binded text box or combo box which could change (selecting different Ids to display Client information) as the source of my ID as apposed to pre-defining it, how would i code this?

The barrier i am coming up against is that the compare statement:

Code:

"[CID] like 'C002' "

is wrapped in "" if i try to insert say txtCID.text it will read the name of the item and not the property that txtCID is possessing.

I hope this is a clear explanation of my issue, help appreciated

04-30-2008, 06:02 PM	#1 (permalink)
ABOU Registered User Join Date: Feb 2007 Location: Ireland Posts: 34 OS: XP	appliying a RowFilter from a textbox value in VB.net i am trying to apply a row filter to a dataset using the following code: Code: DV_CP.RowFilter = "[CID] like 'C002' " I can filter the content of the CID column to all entries that match C002. C002 being a pre-specified ID. Say i wanted to use a binded text box or combo box which could change (selecting different Ids to display Client information) as the source of my ID as apposed to pre-defining it, how would i code this? The barrier i am coming up against is that the compare statement: Code: "[CID] like 'C002' " is wrapped in "" if i try to insert say txtCID.text it will read the name of the item and not the property that txtCID is possessing. I hope this is a clear explanation of my issue, help appreciated