If System.IO.File.Exists(strPathName & "_Master.xml") Then dsMaster.ReadXml(strPathName & "_Master.xml") Else MessageBox.Show("Master does not exist") End If Dim rowMaster() As DataRow = dsMaster.Tables(0).Select("FinYearID=" & GlobalClass.finYearId & " And MemType='" & GlobalClass.MemType & "' And MemberID='" & rowTran("MemberID") & "'") Dim strBuilder As New StringBuilder strBuilder.AppendLine("<?xml version='1.0' encoding='utf-8'?>") 'declare the start root. strBuilder.AppendLine("<ReportInfo>") strBuilder.Append("<Info>") strBuilder.Append("<Email>") Try strBuilder.Append(rowMaster(0)("Email") & "") ' to test if there is any "Email" column in master table or not ? Catch ex As Exception strBuilder.Append("") End Try strBuilder.Append("</Email>") strBuilder.Append("</Info>") 'declare the end root. strBuilder.AppendLine("</ReportInfo>")
if(dt.Columns.Contains("COLUMNNAME")) return dt.Rows(0)("COLUMNNAME") else return string.Empty
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)