Example #1
0
        private void btnAFind_Click(object sender, EventArgs e)
        {
            frmIPSearchCommon f = new frmIPSearchCommon();

            f.gTableName = "tblArea";
            f.ShowDialog();
            if (f.gOkCancel == true)
            {
                txtAreaCode.Text = f.CODE;
                //gMajorCatID = f1.CUSTID;
                //lblCategory.Text = f1.NAME;
                txtAreaCode.Focus();
            }
        }
Example #2
0
        private void btnIFind_Click(object sender, EventArgs e)
        {
            frmIPSearchCommon f1 = new frmIPSearchCommon();

            f1.gTableName = "tblSysUsers";
            f1.isCustom   = true;
            f1.gQuery     = "SELECT SY.CustID, SY.Code, SY.Username AS NameOf, CM.NameOf AS DescriptionOf FROM tblSysUsers AS SY INNER JOIN tblCompany AS CM ON SY.CompID = CM.CustID";
            f1.ShowDialog();
            if (f1.gOkCancel == true)
            {
                txtCode.Text = f1.CODE;
                txtCode.Focus();
            }
        }