private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow) { HtmlSelect select = new HtmlSelect(); using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand()) { if (command.Parameters.Count > 0) { command.Parameters[0].Value = AppUser.GetRole(); } using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { DataTable list = new DataTable(); adapter.Fill(list); select.DataSource = list; select.DataValueField = list.Columns[0].ColumnName; select.DataBind(); } command.Connection.Dispose(); } select.Items.Insert(0, new ListItem("", "")); return(select); }
private void Autocomplete() { string id = Request.QueryString["criteria"]; string text = Request.QueryString["query"]; Configuration config = AppContext.GetConfiguration(); Configuration.SearchInputFieldRow searchInputFieldRow = config.SearchInputField.First(o => o.FieldID == id); using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand()) { command.Parameters[0].Value = text; if (command.Parameters.Count > 1) { command.Parameters[1].Value = AppUser.GetRole(); } List <string> values = new List <string>(); using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { values.Add(reader.GetString(0)); } } command.Connection.Dispose(); Dictionary <String, Object> result = new Dictionary <String, Object>(); result.Add("suggestions", values); ReturnJson(result); } }