Missing expression error with AutoComplete TextBox with Oracle in ASP.Net

Waghmare

hii,

i am trying to get 2 fields from db with autocomplete textbox extender but want to show only 1 fields n other id field to fetch another value.

empnumber, name from db where empnumber is used fetch designation from another table.

have refferd foll link:

query is : select empnumber ,empname from empview where empstatus is ='0' and "empname like @SearchText+'%'"

but getting error on

using (SqlDataReader sdr = cmd.ExecuteReader())

on this line.

Waghmare

0 2

i have solved this issue by making changes in below line

cmd.CommandText = "select ContactName from Customers where ContactName like '" + prefixText+"%'";

I have directoly pass the value without passing parameterised query.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html