private void frmListHespekim_Load(object sender, EventArgs e)
{
hespekimTable allHes = new hespekimTable();
DataTable dtHespkim = allHes.GetTableTrue();
dgvHespekim.DataSource = dtHespkim;
}
public frmHespekim(statusKind sta)
{
InitializeComponent();
this.myHespekims = new hespekimTable();
this.statusfrm = sta;
cmbKodHazmana.DataSource = DAL.dal.GetTableFromSQL("SELECT pirteHazmana.kodPirteyHazmana, mazminim.NameOfFamily+' '+mazminim.nameOfMazmin+'-'+abodotStam.nameOfAboda AS fullName FROM mazminim INNER JOIN (hazmanot INNER JOIN (abodotStam INNER JOIN pirteHazmana ON abodotStam.kodAboda = pirteHazmana.kodAboda) ON hazmanot.kodHazmana = pirteHazmana.kodHazmana) ON mazminim.kodMaznim = hazmanot.kodMazmin ORDER BY mazminim.nameOfMazmin+' '+mazminim.NameOfFamily+'-'+abodotStam.nameOfAboda");
cmbKodHazmana.DisplayMember = "fullName";
cmbKodHazmana.ValueMember = "kodPirteyHazmana";
}