i am using this code
<script type="text/javascript">
$(function () {
$("[id$=txtaccount]").autocomplete({
source: function (request, response) {
$.ajax({
url: '<%=ResolveUrl("~/Renaming.aspx/GetCustomers") %>',
data: "{ 'prefix': '" + request.term + "'}",
dataType: "json",
type: "POST",
contentType: "application/json; charset=utf-8",
success: function (data) {
response($.map(data.d, function (item) {
return {
label: item.split('-')[0],
val: item.split('-')[1]
}
}))
},
error: function (response) {
alert(response.responseText);
},
failure: function (response) {
alert(response.responseText);
}
});
},
select: function (e, i) {
$("[id$=hfCustomerId]").val(i.item.val);
},
minLength: 1
});
});
</script>
and at .cs Page
public static string[] GetCustomers(string prefix)
{
List<string> customers = new List<string>();
using (OracleConnection conn = new OracleConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (OracleCommand cmd = new OracleCommand())
{
cmd.CommandText = "select CUSTOMER_NAME,CUSTOMER_NAME from ptrcustomer_information where CUSTOMER_NAME like @SearchText + '%'";
cmd.Parameters.AddWithValue("@SearchText", prefix);
cmd.Connection = conn;
conn.Open();
using (OracleDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
customers.Add(string.Format("{0}-{1}", sdr["account_number"], sdr["account_number"]));
}
}
conn.Close();
}
}
return customers.ToArray();
}
and error is showing like this
{"Message":"ORA-01036: illegal variable name/number\n","StackTrace":" at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)\r\n at System.Data.OracleClient.OracleParameterBinding.Bind(OciStatementHandle statementHandle, NativeBuffer parameterBuffer, OracleConnection connection, Boolean\u0026 mustRelease, SafeHandle\u0026 handleToBind)\r\n at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor\u0026 rowidDescriptor, ArrayList\u0026 resultParameterOrdinals)\r\n at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList\u0026 resultParameterOrdinals)\r\n at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)\r\n at System.Data.OracleClient.OracleCommand.ExecuteReader()\r\n at Test.GetCustomers(String prefix) in d:\\Web_Front\\FileNaming\\Test.aspx.cs:line 35","ExceptionType":"System.Data.OracleClient.OracleException"}