Hey All,
I am trying to use a textbox with an AutoCompleteExtender to take a string of letters and retreive a list of street names from a web service. This web service works fine when it returns a dataset which I bind to a GridView. However when I try to use the AutoCompleteExtender it just gives me:
[object Object]
Any help on what I need to do to resolve this would be appreciated.
Thanks,
Doug
Here is the webservice code:
[WebMethod]
public DataSet GetStreetNames(string strStreetName)
{
OracleConnection myStrConnection = new OracleConnection();
OracleCommand myStrCommand = new OracleCommand();
OracleDataAdapter myStrAdapter = new OracleDataAdapter();
DataSet myStrDataSet = new DataSet();
myStrConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnName"].ToString();
myStrCommand.CommandText = "PackageNameIsHere";
myStrCommand.CommandType = CommandType.StoredProcedure;
myStrCommand.Parameters.Add("p_street_name", OracleDbType.Varchar2).Value = strStreetName;
myStrCommand.Parameters["p_street_name"].Direction = ParameterDirection.Input;
myStrCommand.Parameters.Add("cur_streets", OracleDbType.RefCursor);
myStrCommand.Parameters["cur_streets"].Direction = ParameterDirection.Output;
myStrCommand.Connection = myStrConnection;
try
{
myStrConnection.Open();
myStrAdapter.SelectCommand = myStrCommand;
myStrAdapter.Fill(myStrDataSet);
myStrConnection.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myStrConnection.Close();
myStrConnection.Dispose();
}
return myStrDataSet;
}