|
Subject:
|
Passing wildcard parameter to Dataadapter
|
|
Posted By:
|
Hughesie78
|
Post Date:
|
7/3/2008 2:30:22 AM
|
Using VS 2005 and have a tableadapter, the adapter returns values based on a control paramter passed from a textbox, i want to pass a wildcard paramter, how can i do this, im basically looking for all values where the lastname like value%
code:
SELECT USERID, FIRSTNAME, LASTNAME
FROM TBLUSER
WHERE (LASTNAME LIKE :Last)
|
|
