Problem with query

[micoud]

Hello i'm going to crazy with this query...
i'm using tableadapter query configurator , this is the query:

Code: Select all

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE '%'+:Param1)

Passing "1" like parameter it gives 0 row but on database the are 100 rows with CARD=11111111
if i write

Code: Select all

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE '%1')

i have the 100 rows

[micoud]

solved editing query :

Code: Select all

SELECT        ID, DATA, CARD, IN1, OUT1, IN2, OUT2, IN3, OUT3, IN4, OUT4, NOTE
FROM            Ingressi
WHERE        (CARD LIKE :Param1)

and passing "%" with parameter :

Code: Select all

 Me.IngressiTableAdapter.FillByMese(Me.DataSet.Ingressi, String.Format("%/{0:D2}/{1}", ComboBox1.SelectedIndex + 1, anno))