private void lblAdvanced_Click(object sender, EventArgs e)
        {
            FormItemSearch form = new FormItemSearch(this);

            query = "SELECT * FROM vwDistrib WHERE `Item Name` LIKE '" + txtFilter.Text + "%' ";
            form.ShowDialog();
        }
        private void lblAdvanced_Click(object sender, EventArgs e)
        {
            FormItemSearch form = new FormItemSearch(this);

            query = "SELECT * FROM vwstock WHERE `Item Name` LIKE '" + txtFilter.Text + "%' ";
            form.ShowDialog();
            //this.grid.Size = new Size(832,this.grid.RowTemplate.Height * (1 + this.grid.Rows.Count) + gridPanel.Height);
        }
Exemple #3
0
        private void lblAdvanced_Click(object sender, EventArgs e)
        {
            FormItemSearch form = new FormItemSearch(this, itemType);

            if (itemType == 3)
            {
                query = "SELECT `Code`, `Generic Name`, `Name`, `Manufacturer`, `Minimum Level`, `Maximum Level` FROM vwitem WHERE `Type` LIKE '" + strItem + "' AND `Name` LIKE '" + txtFilter.Text + "%' ";
            }
            else
            {
                query = "SELECT * FROM vwitem WHERE `Type` LIKE '" + strItem + "' AND `Name` LIKE '" + txtFilter.Text + "%' ";
            }
            form.ShowDialog();
        }