SQL and Dataset

[Alvin Bruney]

try MATCHES instead of LIKE

"jayuya" <jayuya@cox.net> wrote in message
news:017e01c35497$ad3d3390$a601280a@phx.gbl...

> What is wrong with this SQL statement below. I am trying
> to fill the data grid and apparently there is something
> wrong with my statament "Like"
>
> If I change the SQL to be Where FirstName =??? it works
>
> thanks in advance
> jayuya
>
> sql = "SELECT Id,FirstName,MiddleName,LastName FROM
> Defendant WHERE FirstName Like '*" &
> SearchCriteria.ToString & "*';"
>
> db.OpenConn() 'open db connection
> db.SetDataAdapter(sql, "Defendant") 'sets the data adapter
> With Me.DG_Defendant
> .DataSource = db.DtSet.Tables("Defendant").DefaultView
> Try 'binddata
> .DataBind() 'binds the data to data grid
> Catch
> .CurrentPageIndex = 0
> .DataBind()
> End Try
> End With
> db.DataAdapter.Dispose() 'close the data adapter
> db.CloseConn() 'closes db connection

[jayuya]

got it,
Just needed to change "*" with "%"
thanks,
jayuya

>-----Original Message-----
>What is wrong with this SQL statement below. I am trying
>to fill the data grid and apparently there is something
>wrong with my statament "Like"
>
>If I change the SQL to be Where FirstName =??? it works
>
>thanks in advance
>jayuya
>
>sql = "SELECT Id,FirstName,MiddleName,LastName FROM
>Defendant WHERE FirstName Like '*" &
>SearchCriteria.ToString & "*';"
>
>db.OpenConn() 'open db connection
>db.SetDataAdapter(sql, "Defendant") 'sets the data

adapter

>With Me.DG_Defendant
> .DataSource = db.DtSet.Tables("Defendant").DefaultView
> Try 'binddata
> .DataBind() 'binds the data to data grid
> Catch
> .CurrentPageIndex = 0
> .DataBind()
>End Try
>End With
>db.DataAdapter.Dispose() 'close the data adapter
>db.CloseConn() 'closes db connection
>.
>