This Code Working Fine
ConfigurationBLL configurationBLL = new ConfigurationBLL(); int selectedvalue = (int)ddlVolunteerName.SelectedValue; if (!(ddlVolunteerName.SelectedValue.ToString() != "-1")) return; DataSet dataSet = configurationBLL.FetchVolunteerDetails(volunteerID:selectedvalue); DataRow row = dataSet.Tables[0].Rows[0]; txtFirstName.Text = row["FIRSTNAME"].ToString(); txtMiddleName.Text = row["MIDDLENAME"].ToString(); txtSurname.Text = row["SURNAME"].ToString(); txtAddress.Text = row["ADDRESS"].ToString(); txtCNIC.Text = row["CNIC"].ToString(); txtHomePhoneNumber.Text = row["HOMEPHONENUMBER"].ToString(); txtMobilePhoneNumber.Text = row["MOBILEPHONENUMBER"].ToString(); txtEmailAddress.Text = row["EMAILADDRESS"].ToString(); txtAcademicQualification.Text = row["ACADEMICQUALIFICATION"].ToString(); txtAcademicQualification.Text = row["RELIGIOUSQUALIFICATION"].ToString(); txtMaritalStatus.Text = row["MARITALSTATUS"].ToString(); ddlBloodGroup.SelectedItem = (object)row["BLOODGROUP"].ToString(); txtLastTimeBloodDonated.Text = row["LASTTIMEBLOODDONATED"].ToString(); txtOccupation.Text = row["OCCUPATION"].ToString(); txtFirmName.Text = row["FIRMNAME"].ToString(); txtDesignation.Text = row["DESIGNATION"].ToString(); txtWorkAddress.Text = row["WORKADDRESS"].ToString(); ddlGroupName.SelectedValue = (object)row["GROUPNAME"].ToString(); txtDateofBirth.Text = row["DATEOFBIRTH"].ToString(); txtDateofJoining.Text = row["DATEOFJOINING"].ToString(); ddlCurrentPosition.SelectedValue = (object)row["VOLUNTEERPOSITIONID"].ToString(); txtPrevInstitutionName.Text = row["PREVINSTITUTIONNAME"].ToString(); txtPrevInstitutionJoiningDate.Text = row["PREVINSTITUTIONJOININGDATE"].ToString(); txtPrevInstitutionLeavingDate.Text = row["PREVINSTITUTIONLEAVINGDATE"].ToString(); if (row["ISMEDICALINSURANCE"].ToString() == "1") { rbtnYesMedicalInsurance.Checked = true; rbtnNoMedicalInsurance.Checked = false; } else if (row["ISMEDICALINSURANCE"].ToString() == "0") { rbtnYesMedicalInsurance.Checked = false; rbtnNoMedicalInsurance.Checked = true; } else { rbtnYesMedicalInsurance.Checked = false; rbtnNoMedicalInsurance.Checked = false; } if (row["ISFIREFIGHTING"].ToString() == "1") { rbtnYesFireFighting.Checked = true; rbtnNoFireFighting.Checked = false; } else if (row["ISFIREFIGHTING"].ToString() == "0") { rbtnYesFireFighting.Checked = false; rbtnNoFireFighting.Checked = true; } else { rbtnYesFireFighting.Checked = false; rbtnNoFireFighting.Checked = false; } if (row["ISFIRSTAID"].ToString() == "1") { rbtnYesFirstAid.Checked = true; rbtnNoFirstAid.Checked = false; } else if (row["ISFIRSTAID"].ToString() == "0") { rbtnYesFirstAid.Checked = false; rbtnNoFirstAid.Checked = true; } else { rbtnYesFirstAid.Checked = false; rbtnNoFirstAid.Checked = false; } if (row["ISENGLISHLANGUAGE"].ToString() == "1") { rbtnYesEnglishLanguage.Checked = true; rbtnNoEnglishLanguage.Checked = false; } else if (row["ISENGLISHLANGUAGE"].ToString() == "0") { rbtnYesEnglishLanguage.Checked = false; rbtnNoEnglishLanguage.Checked = true; } else { rbtnYesEnglishLanguage.Checked = false; rbtnNoEnglishLanguage.Checked = false; } if (row["ISBOMBDISPOSAL"].ToString() == "1") { rbtnYesBombDisposal.Checked = true; rbtnNoBombDisposal.Checked = false; } else if (row["ISBOMBDISPOSAL"].ToString() == "0") { rbtnYesBombDisposal.Checked = false; rbtnNoBombDisposal.Checked = true; } else { rbtnYesBombDisposal.Checked = false; rbtnNoBombDisposal.Checked = false; } if (row["ISCERT"].ToString() == "1") { rbtnYesCERT.Checked = true; rbtnNoCERT.Checked = false; } else if (row["ISCERT"].ToString() == "0") { rbtnYesCERT.Checked = false; rbtnNoCERT.Checked = true; } else { rbtnYesCERT.Checked = false; rbtnNoCERT.Checked = false; } if (row["ISSECURITY"].ToString() == "1") { rbtnYesSecurity.Checked = true; rbtnNoSecurity.Checked = false; } else if (row["ISSECURITY"].ToString() == "0") { rbtnYesSecurity.Checked = false; rbtnNoSecurity.Checked = true; } else { rbtnYesSecurity.Checked = false; rbtnNoSecurity.Checked = false; } if (row["ISRESIGN"].ToString() == "0") { rbtnYesActive.Checked = true; rbtnNotActive.Checked = false; } else { rbtnYesActive.Checked = false; rbtnNotActive.Checked = true; txtDateofLeaving.Text = row["DATEOFLEAVING"].ToString(); } if (row["PROFILEPHOTO"] is byte[]) { byte[] buffer = (byte[])row["PROFILEPHOTO"]; MemoryStream memoryStream = new MemoryStream(buffer); try { picPhoto.Image = Image.FromStream((Stream)memoryStream); bPhotoImage = buffer; } catch (Exception ex) { picPhoto.Image = (Image)null; } } else picPhoto.Image = (Image)null; DataTable table1 = dataSet.Tables[1]; FingerPrints prints = new FingerPrints(); for (int index = 0; index < table1.Rows.Count; ++index) { switch (int.Parse(table1.Rows[index]["FINGERPRINTID"].ToString())) { case 11: if (table1.Rows[index]["FINGERPRINTPHOTO"] is byte[]) { byte[] imgData = (byte[])table1.Rows[index]["FINGERPRINTPHOTO"]; DrawImage(imgData, prints.picRightThumb); picRightThumbPhoto = imgData; bRightThumbImage = (byte[])table1.Rows[index]["FINGERPRINTTEMPLATE"]; break; } prints.picRightThumb.Image = (Image)null; break; case 12: if (table1.Rows[index]["FINGERPRINTPHOTO"] is byte[]) { byte[] imgData = (byte[])table1.Rows[index]["FINGERPRINTPHOTO"]; DrawImage(imgData, prints.picRightIndex); picRightIndexPhoto = imgData; bRightIndexImage = (byte[])table1.Rows[index]["FINGERPRINTTEMPLATE"]; break; } prints.picRightIndex.Image = (Image)null; break; case 16: if (table1.Rows[index]["FINGERPRINTPHOTO"] is byte[]) { byte[] imgData = (byte[])table1.Rows[index]["FINGERPRINTPHOTO"]; DrawImage(imgData, prints.picLeftThumb); picLeftThumbPhoto = imgData; bLeftThumbImage = (byte[])table1.Rows[index]["FINGERPRINTTEMPLATE"]; break; } prints.picLeftThumb.Image = (Image)null; break; case 17: if (table1.Rows[index]["FINGERPRINTPHOTO"] is byte[]) { byte[] imgData = (byte[])table1.Rows[index]["FINGERPRINTPHOTO"]; DrawImage(imgData, prints.picLeftIndex); picLeftIndexPhoto = imgData; bLeftIndexImage = (byte[])table1.Rows[index]["FINGERPRINTTEMPLATE"]; } else prints.picLeftIndex.Image = (Image)null; break; } //prints.Show(); } DataTable table2 = dataSet.Tables[2]; LetterRecord letterRecord = new LetterRecord(); for (int index = 0; index < table2.Rows.Count; ++index) { string str = table2.Rows[index]["LETTERIMAGEPATH"].ToString(); imageListLetter.Images.Add(Image.FromStream((Stream)new MemoryStream((byte[])table2.Rows[index]["LETTERIMAGE"]))); listLetter.BeginUpdate(); listLetter.Items.Add(str); listLetter.EndUpdate(); } if (table2.Rows.Count > 0) { iCurrentImage = 0; letterRecord.txtFileName.Text = listLetter.Items[iCurrentImage].ToString(); letterRecord.picLetter.Image = imageListLetter.Images[iCurrentImage]; letterRecord.lblPaging.Text = (iCurrentImage + 1).ToString() + " of " + (object)listLetter.Items.Count; //btnPrevious.Enabled = true; //btnNext.Enabled = true; } else iCurrentImage = -1; letterRecord.Show();
Line Number 221. Not Working
imageListLetter.Images.Add(Image.FromStream((Stream)new MemoryStream((byte[])table2.Rows[index]["LETTERIMAGE"])));