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(); } }
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(); } }