private void searchBanks(string q) { DataTable data = getService.searchDataFrom(app.objects["banks"], q); if (data.Rows.Count > 0) { bankdataGridView.DataSource = data; } }
private void searchLocation(string q) { DataTable data = getService.searchDataFrom(app.objects["locations"], q); if (data.Rows.Count > 0) { locationGridView.DataSource = data; } }
private void searchUser(string q) { DataTable data = getService.searchDataFrom(app.objects["users"], q); if (data.Rows.Count > 0) { data.Columns.Remove("password"); } data.Columns.Remove("picture"); usersGridView.DataSource = data; }
public void buildSalesDropdown(Form currentForm, Object sender, Panel panel, string source) { TextBox textBox = (sender as TextBox); SSGetService getService = new SSGetService(); currentTextBox = textBox; if (!listedItems.Contains(textBox.Text) && textBox.Text.Length > 1) { customDropdown.HideSelection = false; customDropdown.Margin = new Padding(5); customDropdown.Size = new Size(panel.Width, 97); customDropdown.Sorting = SortOrder.Ascending; customDropdown.TabIndex = 58; customDropdown.TileSize = new Size(panel.Width, 25); customDropdown.UseCompatibleStateImageBehavior = false; customDropdown.View = View.Tile; customDropdown.Location = new Point(panel.Location.X + 18, panel.Location.Y + (panel.Height * 3) - 11); customDropdown.ItemSelectionChanged += new ListViewItemSelectionChangedEventHandler(onSelectedIndexChanged); customDropdown.MouseLeave += new EventHandler(onMouseLeave); customDropdown.Hide(); if (textBox.Text != "" && textBox.Text != null) { try { DataTable data = getService.searchDataFrom(this.objects[source], textBox.Text); if (data.Rows.Count > 0) { customDropdown.Clear(); currentForm.Controls.Add(customDropdown); customDropdown.BringToFront(); customDropdown.Show(); foreach (DataRow row in data.Rows) { string name = row.Field <string>("name"); listedItems.Add(name); customDropdown.Items.Add(name); } } else { customDropdown.Hide(); currentForm.Controls.Remove(customDropdown); } } catch (Exception ex) { this.showError(ex.Message); } } else { customDropdown.Hide(); currentForm.Controls.Remove(customDropdown); } } else { customDropdown.Hide(); currentForm.Controls.Remove(customDropdown); } }