Gridview doesn't edit field after filter LIKE find

M

Mark B

I have a filter that finds relevant text in a Gridview. However when I click
Edit on the Gridview row, no rows appear at all.

Protected Sub Button5_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Button5.Click
'Find text
With SqlDataSource3
.FilterExpression = Nothing
.FilterExpression = "MyColumn1 LIKE '%{0}%'"
.FilterParameters.Clear()
.FilterParameters.Add("fp2", TextBox4.Text)
End With

End Sub


Any ideas?

It works fine when I don't use the LIKE keyword.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,994
Messages
2,570,223
Members
46,813
Latest member
lawrwtwinkle111

Latest Threads

Top