datagridview filter code error

dv.RowFilter ="CustomerName LIKE '*" & txtSearchBox.Text &"*'"

this code has errors

pls rectify and reply

I want to sort the datagrid according to the text entered in the text box

for eg

when user enters letter ' k ' in the textbox, the datagridview should be sorted with Customers starting with letter ' k '

pls reply

[852 byte] By [PradeepGupta] at [2007-12-23]
# 1
"CustomerName LIKE '" & txtSearchBox.Text & "%'"
hrubesh at 2007-8-30 > top of Msdn Tech,Windows Forms,Windows Forms General...