Hi,
Add this query in Textbox_Textchanged Event and populate the DataGridView-
Declare one Dataset Object
Dim da as OleDbDataAdapter("Select * from Table where CityCode like '"& TextBox1.Text &"%'", Connection)
da.Fill(ds,"TableName")
DataGridView.DataSource=ds.Tables(0)
Thanks