u can write in the textbox textchange event with the sql query using the like condition....
Dim myCommand As New OleDbCommand
.CommandText = "SELECT ID , (FirstName +' '+LastName) as Name FROM TableName where ID like '" & Textbox1.Text & "%" + "' order by ID"
.CommandType = CommandType.Text
.Connection = Connection
Dim dt As New DataTable
.AutoGenerateColumns = True
.DataSource = dt
Catch ex As Exception
MsgBox("Error in select query: " + ex.Message)
there is another method to do this is
use this code at the textbox textchange event
dim con as new sqlconnection("connection string")
dim dt as new datatable
dim da as new sqldataadapter("select * from table1 where name like '" & textbox1.text & "%'",con)
datagridview1.datasource = dt