// Search departmental heads public void searchDepartmentalHeads() { searchDepartmentalHeadStaffIdTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; searchDepartmentalHeadStaffIdTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection collection = new AutoCompleteStringCollection(); sqlConnection = new MySqlConnection(databaseConnection); try { sqlConnection.Open(); MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM departmental_heads", sqlConnection); MySqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { String name = reader.GetInt64("pfno").ToString(); collection.Add(name); } } catch (Exception exception) { MessageBox.Show("Error has occured while seraching departmental head, : " + exception.Message); } searchDepartmentalHeadStaffIdTextBox.AutoCompleteCustomSource = collection; }
private void AutoCompleteAnimalSerial() { //auto completes Employee name in check out page. textBoxTreatmentSerial.AutoCompleteMode = AutoCompleteMode.SuggestAppend; textBoxTreatmentSerial.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection collection1 = new AutoCompleteStringCollection(); textBoxFoodAnimalSerial.AutoCompleteMode = AutoCompleteMode.SuggestAppend; textBoxFoodAnimalSerial.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection collection2 = new AutoCompleteStringCollection(); SqlConnection connection = new SqlConnection(connectionString); string commandString = "SELECT aserial FROM animal"; SqlCommand command = new SqlCommand(commandString, connection); SqlDataReader myReader; try { connection.Open(); myReader = command.ExecuteReader(); while (myReader.Read()) { string value = myReader["aserial"].ToString(); collection1.Add(value); collection2.Add(value); } connection.Close(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } textBoxTreatmentSerial.AutoCompleteCustomSource = collection1; textBoxFoodAnimalSerial.AutoCompleteCustomSource = collection2; NameShadeShow(); }
/// <summary>The find object form_ shown.</summary> /// <param name="sender">The sender.</param> /// <param name="e">The e.</param> private void FindObjectForm_Shown(object sender, EventArgs e) { var collection = new AutoCompleteStringCollection(); try { UseWaitCursor = true; if (_databaseInspector.DbSchema == null) { _databaseInspector.LoadDatabaseDetails(); } foreach (DbModelTable table in _databaseInspector.DbSchema.Tables) { collection.Add(table.FullName); } foreach (DbModelView view in _databaseInspector.DbSchema.Views) { collection.Add(view.FullName); } } finally { UseWaitCursor = false; } cboObjects.AutoCompleteCustomSource = collection; }
public void Initialize() { SetFormHeader(); AutoCompleteStringCollection cmbstrName = new AutoCompleteStringCollection(); AutoCompleteStringCollection cmbstrJer = new AutoCompleteStringCollection(); DataRow drTeam = ObjUdtprovider.CurrentDataSet.Tables[2].Select("Name = '" + Team+"'").FirstOrDefault(); if (drTeam != null) { DataRow[] drPlayers = ObjUdtprovider.CurrentDataSet.Tables[3].Select("T24_ID = '" + drTeam["T24_ID"] + "' AND Playing=true"); cmbPlayerJer.Items.Clear(); cmbPlayerName.Items.Clear(); foreach (DataRow item in drPlayers) { cmbPlayerName.Items.Add(item["First Name"]); cmbstrName.Add(item["First Name"].ToString()); cmbPlayerJer.Items.Add(item["Jersey No"]); cmbstrJer.Add(item["Jersey No"].ToString()); } cmbPlayerName.SelectedIndex = 1; cmbPlayerJer.SelectedIndex = 1; cmbPlayerName.AutoCompleteMode = AutoCompleteMode.Suggest; cmbPlayerName.AutoCompleteSource = AutoCompleteSource.CustomSource; cmbPlayerName.AutoCompleteCustomSource = cmbstrName; cmbPlayerJer.AutoCompleteMode = AutoCompleteMode.Suggest; cmbPlayerJer.AutoCompleteSource = AutoCompleteSource.CustomSource; cmbPlayerJer.AutoCompleteCustomSource = cmbstrJer; } }
private void SetupElements(NationSelectForm nationSelectForm, Nation selectedNation, int numberOfCrewSlots) { _nationSelectForm = nationSelectForm; _selectedNation = selectedNation; _numberOfCrewSlots = numberOfCrewSlots; _vehicleType = new VehicleType(); // Crappy default value _crewSlotData = Helpers.LoadCrewSlotDataFromFile(CrewSlotDataFileName) ?? new List<CrewSlotData>(); // Load from file, if null is returned, creates a new (empty) list if (_crewSlotData.Count < 1) // Happens only when nothing comes from reading the file with data. { _crewSlotData.Add(new CrewSlotData(_selectedNation)); } #region Setup fields for form controls List<string> vehicleNames = Helpers.LoadVehicleDataFromJson(Helpers.GetVehicleJsonDataForNation(_selectedNation)).OrderBy(v => v.VehicleName).Select(v => v.VehicleName).ToList(); _faytVehicleSource = new AutoCompleteStringCollection(); _faytVehicleSource.AddRange(vehicleNames.ToArray()); List<string> vehicleTypes = Helpers.LoadVehicleTypesDataFromJson(Helpers.GetVehicleTypesJsonData()).OrderBy(t => t.VehicleTypeLongName).Select(t => t.VehicleTypeLongName).ToList(); _faytVehicleTypeSource = new AutoCompleteStringCollection(); _faytVehicleTypeSource.AddRange(vehicleTypes.ToArray()); _crewSlotConfigurations = new List<CrewSlotConfiguration>(); _crewSlotGroupBoxes = new Dictionary<int, GroupBox>(); _crewNameComboBoxes = new Dictionary<int, ComboBox>(); _crewTrainedMembersNumericScrollers = new Dictionary<int, NumericUpDown>(); _crewVehicleTypeComboBoxes = new Dictionary<int, ComboBox>(); #endregion SetFormHeight(); Helpers.ChangeBackground(this, selectedNation); PopulateFormControls(); }
/// <summary>Reloads the repo's objects tree.</summary> public void Reload() { // todo: task exception handling Cancel(); _cancelledTokenSource = new CancellationTokenSource(); var token = _cancelledTokenSource.Token; var tasks = rootNodes.Select(r => r.ReloadTask(token)).ToArray(); Task.Factory.ContinueWhenAll(tasks, (t) => { if (!t.All(r => r.Status == TaskStatus.RanToCompletion)) { return; } if (token.IsCancellationRequested) { return; } BeginInvoke(new Action(() => { var autoCompletionSrc = new AutoCompleteStringCollection(); autoCompletionSrc.AddRange( _branchFilterAutoCompletionSrc.ToArray()); txtBranchFilter.AutoCompleteCustomSource = autoCompletionSrc; })); }, _cancelledTokenSource.Token); tasks.ToList().ForEach(t => t.Start()); }
private void addCarnets(AutoCompleteStringCollection DataCollection) { foreach (Alumnos Alumno in Alumnos) { DataCollection.Add(Alumno.carnet + " - " + Alumno.nombres ); } }
private void frmDodjelaPrava_Load(object sender, EventArgs e) { // key/value for combobox source List<KeyValuePair<string, string>> data = new List<KeyValuePair<string, string>>(); // autocomplete for user's combobox AutoCompleteStringCollection autocomplete = new AutoCompleteStringCollection(); // text inside combobox: Name Surname (username) // value: username foreach (iUser korisnik in piLogin.GetUser()) { data.Add(new KeyValuePair<string, string> (korisnik.UserName, korisnik.Name + " " + korisnik.Surname + " (" + korisnik.UserName + ")")); autocomplete.Add(korisnik.Name + " " + korisnik.Surname + " (" + korisnik.UserName + ")"); } // set datasource for user's combobox cmbKorisnik.DataSource = new BindingSource(data, null); cmbKorisnik.DisplayMember = "Value"; cmbKorisnik.ValueMember = "Key"; // set autocomplete source and mode cmbKorisnik.AutoCompleteSource = AutoCompleteSource.CustomSource; cmbKorisnik.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cmbKorisnik.AutoCompleteCustomSource = autocomplete; // set role items cmbUloga.Items.Add("Odobravanje"); cmbUloga.Items.Add("Likvidatura"); // if user is set, select it from combobox if (this.korisnik != null) { cmbKorisnik.SelectedValue = this.korisnik.UserName; } }
static void Main() { if (Directory.Exists(GetCheetahFolder()) == false) Directory.CreateDirectory(GetCheetahFolder()); WebConfig conf = WebConfig.Default; #if DEBUG conf.LogFile = Application.StartupPath + @"\log.txt"; conf.LogSeverity = ChromiumEngine.Enum.LogSeverity.Verbose; #endif if (Directory.Exists(GetCheetahFolder() + @"\Cache\") == false) Directory.CreateDirectory(GetCheetahFolder() + @"\Cache\"); conf.CachePath = GetCheetahFolder() + @"\Cache\"; WebCore.Initialize(conf); History.initialize(); Bookmarking.initialize(); autocompletedata = new AutoCompleteStringCollection(); for (int i = 0; i < History.GetItemsCount() - 1; i++) autocompletedata.Add(History.Url(i)); for (int i = 0; i < Bookmarking.GetItemsCount() - 1; i++) autocompletedata.Add(Bookmarking.Url(i)); AuthenticationPasswords.Initialize(); Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(true); Application.Run(new Form1()); WebCore.ShutDown(); }
private void textBox1_TextChanged_1(object sender, EventArgs e) { AutoCompleteStringCollection names = new AutoCompleteStringCollection(); textBox1.AutoCompleteMode = AutoCompleteMode.Suggest; textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource; string server = "MYSQL5009.HostBuddy.com"; string database = "db_9cf135_hawk"; string uid = "9cf135_hawk"; string password = "******"; string connectionString; connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD="******";"; MySqlConnection con = new MySqlConnection(connectionString); con.Open(); MySqlCommand cms = new MySqlCommand("select * from user", con); MySqlDataReader dr = cms.ExecuteReader(); while (dr.Read()) { names.Add(dr[1].ToString()); } dr.Close(); con.Close(); textBox1.AutoCompleteCustomSource = names; }
private void AddRestrictForm_Load(object sender, EventArgs e) { AutoCompleteStringCollection c = new AutoCompleteStringCollection(); c.AddRange(this.SuggestProperties); txtPropertyName.AutoCompleteCustomSource = c; AutoCompleteStringCollection c1 = new AutoCompleteStringCollection(); c1.AddRange(this.SuggestRoles); txtRole.AutoCompleteCustomSource = c1; if (Xml != null) { string type = Xml.GetAttribute("Type"); if (type.Equals("PropertyEquals",StringComparison.CurrentCulture)) { rbPropertyEquals.Checked = true; txtPropertyName.Text = Xml.GetAttribute("Property"); txtPropertyValue.Text = Xml.GetAttribute("Value"); } else if (type.Equals("RoleContain", StringComparison.CurrentCulture)) { rbRoleContain.Checked = true; txtRole.Text = Xml.GetAttribute("Role"); } else { rbDB.Checked = true; txtSQL.Text = Xml.InnerText.Trim(); } } }
public frmArticulosBorradoMasivo() { InitializeComponent(); System.Drawing.Icon ico = Properties.Resources.icono_app; this.Icon = ico; this.Text = " Borrado de artículos sin stock"; this.ControlBox = true; this.MaximizeBox = false; FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle; cmbGenero.Validating += new System.ComponentModel.CancelEventHandler(BL.Utilitarios.ValidarComboBox); cmbGenero.KeyDown += new System.Windows.Forms.KeyEventHandler(BL.Utilitarios.EnterTab); DataTable tblGeneros = BL.GetDataBLL.Generos(); cmbGenero.ValueMember = "IdGeneroGEN"; cmbGenero.DisplayMember = "DescripcionGEN"; cmbGenero.DropDownStyle = ComboBoxStyle.DropDown; cmbGenero.DataSource = tblGeneros; cmbGenero.SelectedValue = -1; AutoCompleteStringCollection generosColection = new AutoCompleteStringCollection(); foreach (DataRow row in tblGeneros.Rows) { generosColection.Add(Convert.ToString(row["DescripcionGEN"])); } cmbGenero.AutoCompleteCustomSource = generosColection; cmbGenero.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cmbGenero.AutoCompleteSource = AutoCompleteSource.CustomSource; }
public MainWindow() { InitializeComponent(); using (var db = new MySqlContext()) { var permissions = from a in db.Permissions select a.Name; this.checkedListBox_permissions.Items.AddRange(permissions.ToArray()); this.checkedListBox_modificar_permissions.Items.AddRange(permissions.ToArray()); var users = from b in db.LoginModels select b.User; this.checkedListBox_users.Items.AddRange(users.ToArray()); this.checkedListBox_modificar_users.Items.AddRange(users.ToArray()); var roles = from r in db.Roles select r.Name; AutoCompleteStringCollection accl = new AutoCompleteStringCollection(); accl.AddRange(roles.ToArray()); txt_rol_nombre.AutoCompleteMode = AutoCompleteMode.Suggest; txt_rol_nombre.AutoCompleteCustomSource = accl; txt_rol_nombre.AutoCompleteSource = AutoCompleteSource.CustomSource; txt_modificar_nombre.AutoCompleteMode = AutoCompleteMode.Suggest; txt_modificar_nombre.AutoCompleteCustomSource = accl; txt_modificar_nombre.AutoCompleteSource = AutoCompleteSource.CustomSource; } }
private void Autocomplete() { try { con = new OleDbConnection(cs); con.Open(); OleDbCommand cmd = new OleDbCommand("SELECT distinct ProductName FROM product", con); DataSet ds = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(ds, "Product"); AutoCompleteStringCollection col = new AutoCompleteStringCollection(); int i = 0; for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { col.Add(ds.Tables[0].Rows[i]["productname"].ToString()); } txtProductName.AutoCompleteSource = AutoCompleteSource.CustomSource; txtProductName.AutoCompleteCustomSource = col; txtProductName.AutoCompleteMode = AutoCompleteMode.Suggest; con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// Search department public void searchJobCategory() { searchJobCategoryName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; searchJobCategoryName.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection collection = new AutoCompleteStringCollection(); sqlConnection = new MySqlConnection(databaseConnection); try { sqlConnection.Open(); MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM job_category", sqlConnection); MySqlDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { String name = reader.GetString("name"); collection.Add(name); } } catch (Exception exception) { MessageBox.Show("Error has occured while seraching department, : " + exception.Message); } searchJobCategoryName.AutoCompleteCustomSource = collection; }
private void CargarComboClientesTodos(long IdUsuario, string Busqueda) { var timer = System.Diagnostics.Stopwatch.StartNew(); //Llena el combo con la lista de Targets CboCliente.ResetText(); IList<clsClienteMaster> ListaClienteMaster = LogicaNegocios.Clientes.clsClientesMaster.ListarClienteMaster(Busqueda, Enums.TipoPersona.Comercial, Enums.Estado.Todos, true); ComboBoxItemCollection coll = CboCliente.Properties.Items; coll.Add(Utils.Utils.ObtenerPrimerItem()); foreach (var list in ListaClienteMaster) { coll.Add(list); } CboCliente.SelectedIndex = 0; AutoCompleteStringCollection textoAutocompletar = new AutoCompleteStringCollection(); textoAutocompletar = new AutoCompleteStringCollection(); CboCliente.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; CboCliente.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; foreach (var list in ListaClienteMaster) { textoAutocompletar.Add(list.NombreCliente); } CboCliente.MaskBox.AutoCompleteCustomSource = textoAutocompletar; ClsLogPerformance.Save(new LogPerformance(Base.Usuario.UsuarioConectado.Usuario, timer.Elapsed.TotalSeconds)); }
private void BuildSearchSuggestions() { var artistStrings = new List<string>(); var titleStrings = new List<string>(); foreach (var item in _libraryManager.GetTablatureItems()) { if (artistStrings.Find(x => x.Equals(item.File.Artist, StringComparison.OrdinalIgnoreCase)) == null) artistStrings.Add(item.File.Artist); var title = TablatureUtilities.RemoveVersionConventionFromTitle(item.File.Title); if (titleStrings.Find(x => x.Equals(title, StringComparison.OrdinalIgnoreCase)) == null) titleStrings.Add(title); } var artistSuggestions = new AutoCompleteStringCollection(); var titleSuggestions = new AutoCompleteStringCollection(); foreach (var str in artistStrings) artistSuggestions.Add(str); foreach (var str in titleStrings) titleSuggestions.Add(str); txtSearchArtist.AutoCompleteCustomSource = artistSuggestions; txtSearchTitle.AutoCompleteCustomSource = titleSuggestions; }
public EDDiscoveryForm() { InitializeComponent(); EDDConfig = new EDDConfig(); //_fileTgcSystems = Path.Combine(Tools.GetAppDataDirectory(), "tgcsystems.json"); _fileEDSMDistances = Path.Combine(Tools.GetAppDataDirectory(), "EDSMDistances.json"); string logpath=""; try { logpath = Path.Combine(Tools.GetAppDataDirectory(), "Log"); if (!Directory.Exists(logpath)) { Directory.CreateDirectory(logpath); } } catch (Exception ex) { Trace.WriteLine($"Unable to create the folder '{logpath}'"); Trace.WriteLine($"Exception: {ex.Message}"); } _edsmSync = new EDSMSync(this); trilaterationControl.InitControl(this); travelHistoryControl1.InitControl(this); imageHandler1.InitControl(this); SystemNames = new AutoCompleteStringCollection(); Map = new EDDiscovery2._3DMap.MapManager(); }
public UC_mailSearchWeb() { InitializeComponent(); m_identifier = Page.MailSearchWeb; m_next = Page.Gesture; m_previous = Page.Action; lbl_icon.Text = Translation.GetText("C_SearchOpenWeb_lbl_icon"); m_timer = new Timer(); m_timer.Interval = 2000; m_timer.Tick += new EventHandler(m_timer_Tick); m_webIconExtractor = new Favicon(); m_webIconExtractor.IconObatined += new Favicon.DlgIconObtained(IconObtained); m_autoCompleteSearchItems = new AutoCompleteStringCollection(); m_autoCompleteSearchItems.AddRange(new string[] { "http://www.google.com/search?&q=(*)", "http://en.wikipedia.org/w/index.php?&search=(*)", "http://maps.google.com/maps?q=(*)", "http://translate.google.com/#auto|en|(*)", "http://www.last.fm/search?q=(*)", "http://www.imdb.com/find?s=all&q=(*)", "http://search.yahoo.com/search?p=(*)", "http://www.bing.com/search?q=(*)", "http://search.seznam.cz/?q=(*)", "http://www.slovnik.seznam.cz/?q=(*)&lang=en_cz", "http://www.mapy.cz/?query=(*)", "http://www.csfd.cz/hledani-filmu-hercu-reziseru-ve-filmove-databazi/?search=(*)" }); }
public void initGui() { clg = new dataHandler.catalog(timeout: gpExtension.timeout); keyWords = new AutoCompleteStringCollection(); keyWords.AddRange( clg.getKeyWords().ToArray() ); keywordTxt.AutoCompleteSource = AutoCompleteSource.CustomSource; keywordTxt.AutoCompleteCustomSource = keyWords; gdiThemes = clg.getGDIthemes(); gdiThemes.Insert(0, ""); GDIthemeCbx.DataSource = gdiThemes; orgNames = clg.getOrganisations(); orgNames.Insert(0, ""); orgNameCbx.DataSource = orgNames; dataBronnen = clg.getSources(); List<string> bronnen = dataBronnen.Select(c => c.Key).ToList(); bronnen.Insert(0, ""); bronCatCbx.DataSource = bronnen; dataTypes = clg.dataTypes; List<string> dtypes = dataTypes.Select(c => c.Key).ToList(); dtypes.Insert(0, ""); typeCbx.DataSource = dtypes; inspKeyw = clg.inspireKeywords(); inspKeyw.Insert(0, ""); INSPIREthemeCbx.DataSource = inspKeyw; INSPIREannexCbx.DataSource = clg.inpireAnnex; INSPIREserviceCbx.DataSource = clg.inspireServiceTypes; filterResultsCbx.SelectedIndex = 0; }
public static void EnableFaytAndDropDownList(ComboBox comboBox, AutoCompleteStringCollection dataSource) { comboBox.AutoCompleteCustomSource = dataSource; comboBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; comboBox.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox.DataSource = new BindingSource(dataSource, null); //HACK: Stop combo boxes from staying in sync with one another }
public frmContacts() { InitializeComponent(); Icon = Properties.Resources.logo; DataSet ds = Program.DB.SelectAll("SELECT ID,Name FROM Companies;"); if (ds.Tables.Count > 0) { AutoCompleteStringCollection asCompanies = new AutoCompleteStringCollection(); foreach (DataRow r in ds.Tables[0].Rows) { string sName = r["Name"].ToString(); asCompanies.Add(sName); } txtCompanies.AutoCompleteCustomSource = asCompanies; } ds = Program.DB.SelectAll("SELECT ID,NameFirst,NameLast FROM Contacts;"); if (ds.Tables.Count > 0) { foreach (DataRow r in ds.Tables[0].Rows) { DevComponents.Editors.ComboItem i = new DevComponents.Editors.ComboItem(); i.Tag = r["ID"]; i.Text = r["NameFirst"].ToString() + " " + r["NameLast"].ToString(); cbxContact.Items.Add(i); } } }
void AutoComplte() { searchTextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; searchTextBox.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection coll=new AutoCompleteStringCollection(); string url = @"server=faruk\SQLEXPRESS; database=library; integrated security=true"; SqlConnection connection = new SqlConnection(url); connection.Open(); string query = "select * from book_table"; SqlCommand command = new SqlCommand(query, connection); SqlDataReader aReader = command.ExecuteReader(); if (aReader.HasRows) { while (aReader.Read()) { string sname = aReader[1].ToString(); coll.Add(sname); } } searchTextBox.AutoCompleteCustomSource= coll; connection.Close(); }
public void FillTheCustomerInfo(custVendor.CustVendorManager.custvendorinfo custInfo) { AutoCompleteStringCollection contactSource = new AutoCompleteStringCollection(); if (custInfo.contact1.Length!=0) { tbContact.Text = custInfo.contact1; contactSource.Add(custInfo.contact1); } if (custInfo.contact2.Length!=0) { contactSource.Add(custInfo.contact2); } tbContact.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tbContact.AutoCompleteSource = AutoCompleteSource.CustomSource; tbContact.AutoCompleteCustomSource = contactSource; tbCustomerAccount.Text = custInfo.cvnumber; tbFreightTerm.Text = custInfo.shippingTerm; tbPaymentTerm.Text = custInfo.paymentTerm; tbBillto.Text = custInfo.billTo; List<custVendor.CustVendorManager.custvendorinfoshipto> shipToList = custVendor.CustVendorManager.CustVenInfoManager.GetShipTo(custInfo.cvId); List<string> shipToListString = new List<string>(); foreach (custVendor.CustVendorManager.custvendorinfoshipto shipto in shipToList) { shipToListString.Add(shipto.shipTo); } SetShipToList(shipToListString); }
public DGV_TextBoxCell() : base() { pAC = null; pACMode = AutoCompleteMode.None; pACSource = AutoCompleteSource.None; }
public AutoCompleteStringCollection autoComplete() { AutoCompleteStringCollection collection = new AutoCompleteStringCollection(); try { SqlConnectionObj.Open(); string query = "select * from tbl_room"; SqlCommandObj.CommandText = query; SqlDataReader reader = SqlCommandObj.ExecuteReader(); while (reader.Read()) { string roomNo = reader["roomNo"].ToString(); collection.Add(roomNo); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (SqlConnectionObj != null && SqlConnectionObj.State == ConnectionState.Open) { SqlConnectionObj.Close(); } } return collection; }
//オートコンプリートの初期化 public void AutoComplete_Init(TextBox tbx, string filename) { //オートコンプリート用インスタンス生成 AutoCompleteStringCollection auto_scs = new AutoCompleteStringCollection(); tbx.AutoCompleteCustomSource = auto_scs; string directory = Environment.GetEnvironmentVariable("LOCALAPPDATA") + "\\SCV"; //iniファイル用ディレクトリの確認 if (Directory.Exists(directory) == false) { DirectoryInfo di = Directory.CreateDirectory(directory); } //保存用 ini ファイルの読込/作成 if (File.Exists(filename) == false) { FileStream fs = File.Create(filename); fs.Close(); } //読み込んだファイル内容の反映 foreach (string row in File.ReadLines(filename, SJIS)) { auto_scs.Add(row); } }
void AutocompleteText() { textBox5.AutoCompleteMode = AutoCompleteMode.Suggest; textBox5.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection coll = new AutoCompleteStringCollection(); try { if (conn.State != ConnectionState.Open) { conn.Open(); } string sqluery = "SELECT * FROM MED_INFO WHERE MED_MGF='" + comboBox1.Text + "' ORDER BY MED_NAME"; OracleCommand cd = new OracleCommand(sqluery, conn); OracleDataReader r; r = cd.ExecuteReader(); while(r.Read()) { string sn = r.GetString(1); coll.Add(sn); } r.Dispose(); cd.Dispose(); conn.Close(); } catch (Exception exe) { MessageBox.Show(exe.Message); } textBox5.AutoCompleteCustomSource = coll; }
//オートコンプリートの初期化 public void AutoComplete_Init(TextBox tbx, string filename) { //オートコンプリート用インスタンス生成 AutoCompleteStringCollection auto_scs = new AutoCompleteStringCollection(); tbx.AutoCompleteCustomSource = auto_scs; string directory = Environment.GetEnvironmentVariable("LOCALAPPDATA") + "\\SCV"; //保存用 ini ファイルの読込/作成 if (File.Exists(filename) == false) { FileStream fs = File.Create(filename); fs.Close(); } //読み込んだファイル内容をパスワードを復号化し反映 foreach (string row in File.ReadLines(filename, SJIS)) { auto_scs.Add(Decrypt(row)); } //ファイルのサイズを取得 System.IO.FileInfo fi = new System.IO.FileInfo(filename); long filesize = fi.Length; //ファイルの中身が空ではない場合、テキストボックスに初期値を追記 if (filesize != 0) { //テキストファイルからすべての行を読み込む string[] lines = System.IO.File.ReadAllLines(filename); //最終行の値を追記 tbx.Text = (Decrypt(lines[lines.Length - 1])); } }
//Initialization for AutoComplete public void AutoComplete_Init(TextBox tbx, string filename) { filename = path + filename; //Instantiation for AutoComplete AutoCompleteStringCollection auto_scs = new AutoCompleteStringCollection(); tbx.AutoCompleteCustomSource = auto_scs; string directory = Environment.GetEnvironmentVariable("LOCALAPPDATA") + "\\SCV"; //Checking of LOCALAPPDATA <C:\Users\AppData\Local> directory and file if (Directory.Exists(directory) == false) { DirectoryInfo di = Directory.CreateDirectory(directory); } if (File.Exists(filename) == false) { FileStream fs = File.Create(filename); fs.Close(); this.file_flg = true; } //Reading file for AutoComplete foreach (string row in File.ReadLines(filename, SJIS)) { if(row.Contains(",")) { string[] data = row.Split(','); auto_scs.Add(data[0]); } else { auto_scs.Add(row); } } //Auto Input from last history //Getting file size System.IO.FileInfo fi = new System.IO.FileInfo(filename); long filesize = fi.Length; //File is not null(or brank) if (filesize != 0) { //Reading all row from file string[] lines = System.IO.File.ReadAllLines(filename); //Input for history from last data if (tbx.Name == "tbxUser") { string[] data = (lines[lines.Length - 1]).Split(','); tbx.Text = data[0]; } else { string data = lines[lines.Length - 1]; tbx.Text = data; } } }
private void FindSceneTable() { Scenes = new List <ISceneTableEntry>(); if (IsMajora || !HasZ64TablesHack) { int increment = (IsMajora ? 16 : 20); DMATableEntry dma = Files.OrderBy(x => x.VStart).FirstOrDefault(x => x.FileType == DMATableEntry.FileTypes.Scene); for (int i = CodeData.Length - (increment * 2); i > 0; i -= 4) { ISceneTableEntry entry = (!IsMajora ? (ISceneTableEntry) new SceneTableEntryOcarina(this, i, true) : (ISceneTableEntry) new SceneTableEntryMajora(this, i, true)); if (entry.GetSceneStartAddress() == dma.VStart && entry.GetSceneEndAddress() == dma.VEnd) { SceneTableAddress = i; break; } } if (SceneTableAddress != -1) { for (int i = SceneTableAddress, j = 0; i < CodeData.Length - (16 * 16); i += increment) { ISceneTableEntry scn1 = (!IsMajora ? (ISceneTableEntry) new SceneTableEntryOcarina(this, i, true) : (ISceneTableEntry) new SceneTableEntryMajora(this, i, true)); if (!scn1.IsValid() && !scn1.IsAllZero()) { break; } scn1.SetNumber((ushort)j); if (!scn1.IsAllZero()) { Scenes.Add(scn1); } j++; } } } else { SceneTableAddress = Endian.SwapInt32(BitConverter.ToInt32(Data, Z64TablesAdrOffset)); int cnt = Endian.SwapInt32(BitConverter.ToInt32(Data, Z64TablesAdrOffset + 4)); for (int i = 0; i < cnt; i++) { Scenes.Add(new SceneTableEntryOcarina(this, SceneTableAddress + (i * 20), false)); } } SceneNameACStrings = new System.Windows.Forms.AutoCompleteStringCollection(); foreach (ISceneTableEntry ste in Scenes) { ste.ReadScene(); SceneNameACStrings.Add(ste.GetName()); } }
public static AutoCompleteStringCollection AutoCompletarBuscarMunicipio() { DataTable dt = DatosAutoCompleteMunicipios(); AutoCompleteStringCollection sc = new System.Windows.Forms.AutoCompleteStringCollection(); foreach (DataRow row in dt.Rows) { sc.Add(Convert.ToString(row["Descripcion"])); } return(sc); }
public void MakeComboBox(System.Windows.Forms.ComboBox MSComBoBox, List <string> DanhSach) { System.Windows.Forms.AutoCompleteStringCollection str = new System.Windows.Forms.AutoCompleteStringCollection(); foreach (string mem in DanhSach) { MSComBoBox.Items.Add(mem.Trim()); str.Add(mem.Trim()); } MSComBoBox.AutoCompleteCustomSource = str; MSComBoBox.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.SuggestAppend; MSComBoBox.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource; }
public frmLogin() { CheckForIllegalCrossThreadCalls = false; this.Text = ""; this.ControlBox = false; InitializeComponent(); var pos = this.PointToScreen(lblMensagem.Location); pos = pictureBox1.PointToClient(pos); lblMensagem.Parent = pictureBox1; lblMensagem.BackColor = Color.Transparent; chkManterAutenticacao.Parent = pictureBox1; chkManterAutenticacao.BackColor = Color.Transparent; picLoader.Parent = pictureBox1; picLoader.BackColor = Color.Transparent; _usuarios = Classes.Aplicacao.ListaUsuarios; txtUsuario.AutoCompleteCustomSource = _usuarios; if (!Classes.Aplicacao.UsuarioPadrao.Usuario.ToString().Equals(String.Empty) && !Classes.Aplicacao.UsuarioPadrao.Senha.ToString().Equals(String.Empty)) { txtUsuario.Text = Classes.Aplicacao.UsuarioPadrao.Usuario.ToString(); txtSenha.Text = Classes.Aplicacao.UsuarioPadrao.Senha.ToString(); txtSenha.UseSystemPasswordChar = true; chkManterAutenticacao.Checked = true; btnEntrar.Focus(); } txtUsuario.Focus(); }
private void FillFormFromRegistry() { if (!stateLoaded) { if (AppCuKey != null) { // fill the various textboxes SlurpFileHistory(); var s = (string)AppCuKey.GetValue(_rvn_XPathExpression); if (s != null) { this.tbXpath.Text = s; } s = (string)AppCuKey.GetValue(_rvn_Prefix); if (s != null) { this.tbPrefix.Text = s; } s = (string)AppCuKey.GetValue(_rvn_Xmlns); if (s != null) { this.tbXmlns.Text = s; } // get the MRU list of XPath expressions _xpathExpressionMruList = new System.Windows.Forms.AutoCompleteStringCollection(); string historyString = (string)AppCuKey.GetValue(_rvn_History, ""); if (!String.IsNullOrEmpty(historyString)) { string[] items = historyString.Split('¡'); if (items != null && items.Length > 0) { //_xpathExpressionMruList.AddRange(items); foreach (string item in items) { _xpathExpressionMruList.Add(item.XmlUnescapeIexcl()); } // insert the most recent expression into the box? this.tbXpath.Text = _xpathExpressionMruList[_xpathExpressionMruList.Count - 1]; } } // set the geometry of the form s = (string)AppCuKey.GetValue(_rvn_Geometry); if (!String.IsNullOrEmpty(s)) { int[] p = Array.ConvertAll <string, int>(s.Split(','), new Converter <string, int>((t) => { return(Int32.Parse(t)); })); if (p != null && p.Length == 5) { this.Bounds = ConstrainToScreen(new System.Drawing.Rectangle(p[0], p[1], p[2], p[3])); } } // workitem 3392 - don't need this // set the splitter // s = (string)AppCuKey.GetValue(_rvn_Splitter); // if (!String.IsNullOrEmpty(s)) // { // try // { // int x = Int32.Parse(s); // this.splitContainer3.SplitterDistance = x; // } // catch { } // } stateLoaded = true; } } }
/// This app uses the windows registry to store config data for itself. /// - creates a key for this DotNetZip Winforms app, if one does not exist /// - stores and retrieves the most recent settings. /// - this is done on a per user basis. (HKEY_CURRENT_USER) private void FillFormFromRegistry() { if (!stateLoaded) { if (AppCuKey != null) { var s = (string)AppCuKey.GetValue(_rvn_DirectoryToZip); if (s != null) { this.tbDirectoryToZip.Text = s; this.tbDirectoryInArchive.Text = System.IO.Path.GetFileName(this.tbDirectoryToZip.Text); } s = (string)AppCuKey.GetValue(_rvn_SelectionToZip); if (s != null) { this.tbSelectionToZip.Text = s; } s = (string)AppCuKey.GetValue(_rvn_SelectionToExtract); if (s != null) { this.tbSelectionToExtract.Text = s; } s = (string)AppCuKey.GetValue(_rvn_ZipTarget); if (s != null) { this.tbZipToCreate.Text = s; } s = (string)AppCuKey.GetValue(_rvn_ZipToOpen); if (s != null) { this.tbZipToOpen.Text = s; } s = (string)AppCuKey.GetValue(_rvn_ExtractLoc); if (s != null) { this.tbExtractDir.Text = s; } else { this.tbExtractDir.Text = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments); } s = (string)AppCuKey.GetValue(_rvn_Encoding); if (s != null) { SelectNamedEncoding(s); } s = (string)AppCuKey.GetValue(_rvn_Compression); if (s != null) { SelectNamedCompressionLevel(s); } else { SelectNamedCompressionLevel("Default"); } s = (string)AppCuKey.GetValue(_rvn_Encryption); if (s != null) { SelectNamedEncryption(s); this.tbPassword.Text = ""; } int x = (Int32)AppCuKey.GetValue(_rvn_ZipFlavor, 0); if (x >= 0 && x <= 2) { this.comboFlavor.SelectedIndex = x; } x = (Int32)AppCuKey.GetValue(_rvn_Zip64Option, 0); if (x >= 0 && x <= 2) { this.comboZip64.SelectedIndex = x; } x = (Int32)AppCuKey.GetValue(_rvn_ExtractExistingFileAction, 0); if (x >= 0 && x <= comboExistingFileAction.Items.Count) { this.comboExistingFileAction.SelectedIndex = x; } x = (Int32)AppCuKey.GetValue(_rvn_FormTab, 1); if (x == 0 || x == 1) { this.tabControl1.SelectedIndex = x; } x = (Int32)AppCuKey.GetValue(_rvn_HidePassword, 1); this.chkHidePassword.Checked = (x != 0); x = (Int32)AppCuKey.GetValue(_rvn_OpenExplorer, 1); this.chkOpenExplorer.Checked = (x != 0); x = (Int32)AppCuKey.GetValue(_rvn_TraverseJunctions, 1); this.chkTraverseJunctions.Checked = (x != 0); x = (Int32)AppCuKey.GetValue(_rvn_RecurseDirs, 1); this.chkRecurse.Checked = (x != 0); x = (Int32)AppCuKey.GetValue(_rvn_RemoveFiles, 1); this.chkRemoveFiles.Checked = (x != 0); // get the MRU list of selection expressions _selectionCompletions = new System.Windows.Forms.AutoCompleteStringCollection(); string history = (string)AppCuKey.GetValue(_rvn_SelectionCompletions, ""); if (!String.IsNullOrEmpty(history)) { string[] items = history.Split('¡'); if (items != null && items.Length > 0) { foreach (string item in items) { _selectionCompletions.Add(item.XmlUnescapeIexcl()); } } } // set the geometry of the form s = (string)AppCuKey.GetValue(_rvn_Geometry); if (!String.IsNullOrEmpty(s)) { int[] p = Array.ConvertAll <string, int>(s.Split(','), new Converter <string, int>((t) => { return(Int32.Parse(t)); })); if (p != null && p.Length == 5) { this.Bounds = ConstrainToScreen(new System.Drawing.Rectangle(p[0], p[1], p[2], p[3])); // Starting a window minimized is confusing... //this.WindowState = (FormWindowState)p[4]; } } AppCuKey.Close(); AppCuKey = null; tbPassword_TextChanged(null, null); stateLoaded = true; } } }
private void FindObjectTable() { Objects = new List <ObjectTableEntry>(); ObjectTableAddress = 0; ObjectCount = 0; EntranceTableAddress = 0; if (!HasZ64TablesHack) { int inc = 8; for (int i = (int)ActorTableAddress; i < CodeData.Length - (8 * 8); i += inc) { ObjectCount = Endian.SwapUInt16(BitConverter.ToUInt16(CodeData, i - 2)); if (ObjectCount < 0x100 || ObjectCount > 0x300) { continue; } ObjectTableEntry obj1 = new ObjectTableEntry(this, i, true); ObjectTableEntry obj2 = new ObjectTableEntry(this, i + 8, true); ObjectTableEntry obj3 = new ObjectTableEntry(this, i + 16, true); if (obj1.IsEmpty == true && obj2.IsValid == true && obj3.IsValid == true && Objects.Count == 0) { ObjectTableAddress = i; break; } } if (ObjectTableAddress != 0 && ObjectCount != 0) { int i, j = 0; for (i = ObjectTableAddress; i < (ObjectTableAddress + (ObjectCount * 8)); i += 8) { Objects.Add(new ObjectTableEntry(this, i, true, (ushort)j)); j++; } if (!IsMajora) { EntranceTableAddress = i + (i % 16); } } } else { ObjectTableAddress = Endian.SwapInt32(BitConverter.ToInt32(Data, Z64TablesAdrOffset + 8)); ObjectCount = (ushort)Endian.SwapInt32(BitConverter.ToInt32(Data, Z64TablesAdrOffset + 12)); for (int i = 0; i < ObjectCount; i++) { Objects.Add(new ObjectTableEntry(this, ObjectTableAddress + i * 8, false, (ushort)i)); } } ObjectNameACStrings = new System.Windows.Forms.AutoCompleteStringCollection(); foreach (ObjectTableEntry obj in Objects) { ObjectNameACStrings.Add(obj.Name); } }
/// <summary> /// Returns an observable sequence wrapping the CollectionChanged event on the AutoCompleteStringCollection instance. /// </summary> /// <param name="instance">The AutoCompleteStringCollection instance to observe.</param> /// <returns>An observable sequence wrapping the CollectionChanged event on the AutoCompleteStringCollection instance.</returns> public static IObservable <EventPattern <CollectionChangeEventArgs> > CollectionChangedObservable(this AutoCompleteStringCollection instance) { return(Observable.FromEventPattern <CollectionChangeEventHandler, CollectionChangeEventArgs>( handler => instance.CollectionChanged += handler, handler => instance.CollectionChanged -= handler)); }