string sqlstr = "select * from zjgcsj_dzfcmx t";
if (data!="")
{
sqlstr += "where name='" + data + "'";
}
OracleConnection orcn = new OracleConnection(ConfigurationManager.AppSettings["ConectionStr"]);
OracleCommand orcm = orcn.CreateCommand();
orcm.CommandText = sqlstr;
OracleDataAdapter adpter = new OracleDataAdapter(orcm);
DataTable dt = new DataTable();
adpter.Fill(dt);
string[] array = new string[dt.Rows.Count];//定义数组
if (dt.Rows.Count>0)
{
//循环数据
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
array[i] = dr["name"].ToString();//为数组赋值
}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// Response.Write(array[i].ToString());
//}
}
var haystack;
$(function () {
var ve = $('#search').val();
$.ajax({
url: "hsts.aspx/GetTable",
contentType: "application/json;charset=utf-8",
type: "post",
dataType: "json",
data: "{data:'" + ve + "'}",
success: function (d) {
haystack = d.d;
alert(d.d[0]);
//$('#search').suggest(haystack);
},
error: function (eror) {
alert(eror);
}
});
});