public string[] GetCompletionList(string prefixText)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand("select top 9 username FROM UserInfo where username like '" + prefixText + "%'");
DataSet ds = db.ExecuteDataSet(dbCommand);
List<string> items = new List<string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
items.Add(dr["username"].ToString());
}
return items.ToArray();
}
public string[] GetCompletionList(string prefixText)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand("select username FROM UserInfo where username like '" + prefixText + "%'");
DataSet ds = db.ExecuteDataSet(dbCommand);
//SqlConnection _sqlConnection = new SqlConnection();
//_sqlConnection.ConnectionString = ConfigurationManager.AppSettings["Conn"];
//_sqlConnection.Open();
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = new SqlCommand("_selectWords FROM [AutoComplete] where Words like '" + prefixText + "%'", _sqlConnection);
//DataSet ds = new DataSet();
//da.Fill(ds);
List<string> items = new List<string>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
items.Add(dr["Words"].ToString());
}
return items.ToArray();
}