public void RefreshAutocompleteForDatabase() { //create autocomplete popup menu var actTables = StaticTreeClass.GetAllTableObjects(_dbReg); var actSystemTables = StaticTreeClass.GetSystemTableObjects(_dbReg); var actViews = StaticTreeClass.GetViewObjects(_dbReg); _popupMenu = new AutocompleteMenu(_txtBox) { MinFragmentLength = 1 }; var words = new List <string>(); words.AddRange(SqlCommands()); words.AddRange(DatabaseTables(actTables)); words.AddRange(DatabaseViews(actViews)); words.AddRange(DatabaseSystemTables(actSystemTables)); if (actTables != null) { words.AddRange(DatabaseTableFields(actTables)); } if (actViews != null) { words.AddRange(DatabaseViewFields(actViews)); } if (actSystemTables != null) { words.AddRange(DatabaseSystemTableFields(actSystemTables)); } _popupMenu.SearchPattern = @"[\w\.$]"; _popupMenu.Items.SetAutocompleteItems(words); _popupMenu.AllowTabKey = true; //size of popupmenu _popupMenu.Items.MaximumSize = new System.Drawing.Size(400, 500); _popupMenu.Items.Width = 400; }
public string[] DatabaseSystemTableFields() { var actSystemTables = StaticTreeClass.GetSystemTableObjects(_dbReg); return(DatabaseSystemTableFields(actSystemTables)); }