private void LoadDefaultData(CodeFrm.TableNames TableName) { switch (TableName) { case CodeFrm.TableNames.CD_Esthkak: repositoryItemGridLookUpEditEsthkakId.DataSource = SqlDB.LoadDataTable(@"SELECT EsthkakId, Esthkak FROM CD_Esthkak"); repositoryItemGridLookUpEditEsthkakId.DisplayMember = "Esthkak"; repositoryItemGridLookUpEditEsthkakId.ValueMember = "EsthkakId"; break; case CodeFrm.TableNames.All: //CD_Esthkak repositoryItemGridLookUpEditEsthkakId.DataSource = SqlDB.LoadDataTable(@"SELECT EsthkakId, Esthkak FROM CD_Esthkak"); repositoryItemGridLookUpEditEsthkakId.DisplayMember = "Esthkak"; repositoryItemGridLookUpEditEsthkakId.ValueMember = "EsthkakId"; //TBL_Emp repositoryItemGridLookUpEditEmpID.DataSource = SqlDB.LoadDataTable(@"SELECT EmpID, Isnull(EMP_FIRST_NAME, '') + ' ' + Isnull(EMP_FATHER_NAME, '') + ' ' + Isnull(EMP_FAM_NAME, '') + ' ' + Isnull(EMP_FOURTH_NAME, '') AS Emp_Name FROM TBL_Emp"); repositoryItemGridLookUpEditEmpID.DisplayMember = "Emp_Name"; repositoryItemGridLookUpEditEmpID.ValueMember = "EmpID"; break; default: break; } }
private void repositoryItemGridLookUpEditEsthkakId_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { if (e.Button.Kind != DevExpress.XtraEditors.Controls.ButtonPredefines.Plus) return; CodeFrm FrmCode = new CodeFrm(CodeFrm.TableNames.CD_Esthkak); FrmCode.ShowDialog(); LoadDefaultData(CodeFrm.TableNames.CD_Esthkak); }