acess

[babbu]

the code doesnt retrieve any data from the database
datagridview1 always remains blank

Dim oledbcom As New OleDb.OleDbCommand
        oledbcom.CommandText = "Select * from customer where company like '*?*'"
        oledbcom.Connection = oledbcon

        oledbcom.Parameters.Add("?", OleDb.OleDbType.VarChar)
        Dim company As String = txtSearch.Text.Trim
        oledbcom.Parameters(0).Value = company.ToString

        Dim da As New OleDb.OleDbDataAdapter(oledbcom)
        Dim dt As New DataTable
        da.Fill(dt)
        dataGridView1.DataSource = dt

[kvprajapati]

Use

oledbcom.CommandText = "Select * from .... like *?*"

[babbu]

if i remove the single inverted commas this is the error that i get

Syntax error (missing operator) in query expression 'company like *?*'

[kvprajapati]

..
oledbcom.CommandText = "Select * from customer where company like ?"
..
oledbcom.Parameters.Add("?", OleDb.OleDbType.VarChar)
Dim company As String = txtSearch.Text.Trim
oledbcom.Parameters(0).Value = "*" & company.ToString & "*"
...

[babbu]

still not fetching any data

[kvprajapati]

Which database product are you using?

[babbu]

m using access