private void ShowData()
{
Employee emp = blObjct.SelectEmployee(EmpId);
txt_code.Text = emp.EmpCode;
txt_Name.Text = emp.EmpName;
txt_fatherName.Text = emp.FatherName;
txt_address.Text = emp.Address;
txt_phon.Text = emp.PhoneNo;
txt_nationality.Text = emp.Nationality;
cbGender.Text = emp.Gender;
txt_maritalStatus.Text = emp.MaritalStatus;
dtpDob.Text = Convert.ToString(emp.DateOfBirth);
txt_PassportNo.Text = emp.PassportNo;
dtpPasprtExpryDate.Text = Convert.ToString(emp.PassportExpiryDate);
txt_LabrCrdNo.Text = emp.LabourCardNo;
dtpLbrCrdExpryDate.Text = Convert.ToString(emp.LabourCardExpiryDate);
txt_noOchildren.Text = emp.NoOfChildren;
cbBloodgrp.Text = emp.BloodGroup;
txt_BankAccNo.Text = emp.BankAccNo;
txt_BankName.Text = emp.BankName;
txt_BankBrach.Text = emp.BankBranch;
txt_qlifucation.Text = emp.Qualification;
cbYearOfPassing.Text = Convert.ToString(emp.YearOfPassing);
txt_percentageOfMarks.Text = emp.PercentageOfMarks;
txt_university.Text = emp.University;
txt_yearOfExperience.Text = Convert.ToString(emp.YearsOfExperience);
txt_EmployeeStatus.Text = emp.EmployeeStatus;
if (empPhoto.Image != null)
{
empPhoto.Image.Dispose();
}
MemoryStream stmBLOBData;
try
{
//BLOB is read into Byte array, then used to construct MemoryStream, then passed to PictureBox.
Byte[] byteBLOBData = new Byte[0];
stmBLOBData = new MemoryStream(emp.EmpPhoto);
empPhoto.Image = Image.FromStream(stmBLOBData);
}
catch
{ }
finally
{
stmBLOBData = null;
}
txt_sponserName.Text = emp.SponsorName;
txt_VisaNo.Text = emp.VisaNo;
dtpVisaExpryDate.Text = Convert.ToString(emp.VisaExpiryDate);
txt_AnnualLeave.Text = Convert.ToString(emp.AnnualLeaveMaturity);
}
