SQL Search LIKE VB.net

[drkgme]

Paano po search sql with LIKE gamit yung naka parameter?

ganito po yung gamit kong code kaso hindi gumagana:

sql_Search = "SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE @SearchAs "

oledcommand.Parameters.AddWithValue("@SearchAs", OleDbType.VarWChar).Value = txtSearch.Text


Thanks sa mga tutulong.

 

[rhidzki]

Paano po search sql with LIKE gamit yung naka parameter?

ganito po yung gamit kong code kaso hindi gumagana:

sql_Search = "SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE @SearchAs "

oledcommand.Parameters.AddWithValue("@SearchAs", OleDbType.VarWChar).Value = txtSearch.Text


Thanks sa mga tutulong.

SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE '%' + @SearchAs + '%'

 

[drkgme]

SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE '%' + @SearchAs + '%'

thanks po sa reply.. hindi pa rin po working yung code, meron pa rin pong error message:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: No value given for one or more required parameters.


Working naman pag ganito lang yung code:
"SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE '%" & searchAs & "%'"

 

[ramnad31]

ql_Search = "SELECT tblinfo.emp_no, tblinfo.lname, tblinfo.fname, tblinfo.bday, tblinfo.gender, tblinfo.status, tblemp.emp_status, tblemp.emp_position, tblemp.emp_department FROM tblinfo LEFT JOIN tblemp ON tblinfo.emp_no = tblemp.emp_no WHERE tblinfo.fname LIKE @SearchAs "

oledcommand.Parameters.AddWithValue("@SearchAs", OleDbType.VarWChar).Value ="%" & txtSearch.Text &"%"

try mo to sir