autocompleteextenter读oracle数据库?
我想利用ajax autocompleteextenter完成自动填充功能,可不成功。我已经确定问题出在以下代码中,因为总在数据库还没打开时就直接跳过下面的代码了。麻烦哪位大侠解答一下我的疑惑,谢谢
public string[] GetCompletionList(string prefixText, int count)
{
List<string> items = new List<string>(count);
OracleConnection conn = new OracleConnection("server=服务器IP;user id=用户名;password=密码;database=数据库名称;");
conn.Open();
string SQL = "select region_name from ywzc_measure_query where region_name like '" + prefixText + "%' and rownum<= " + count;
OracleCommand cmd = new OracleCommand(SQL, conn);
OracleDataReader odr = cmd.ExecuteReader();
while (odr.Read())
{
items.Add(odr["region_name"].ToString());
}
conn.Close();
}