ASP.NET

<Address1 xsi:type="xsd:string">1234 Main Street</Address1><Address2 xsi:type="xsd:string"></Address2>

<Address1 xsi:type="xsd:string">1234 Main Street</Address1><Address2 xsi:type="xsd:string"/>

Dim buffer As MessageBuffer = request.CreateBufferedCopy(Int32.MaxValue)
request = buffer.CreateMessage

Dim msg As Message = buffer.CreateMessage
Dim encoder As UTF8Encoding = New UTF8Encoding

Dim txn As MemoryStream = New MemoryStream
Dim xmlSettings As New XmlWriterSettings
With xmlSettings
    .OmitXmlDeclaration = True
End With

Using xmlWriter As XmlWriter = xmlWriter.Create(txn, xmlSettings)
    Using writer As XmlDictionaryWriter = XmlDictionaryWriter.CreateDictionaryWriter(xmlWriter)

        msg.WriteStartEnvelope(writer)
        msg.WriteStartBody(writer)
        msg.WriteBodyContents(writer)
        xmlWriter.WriteEndElement()
        xmlWriter.WriteEndElement()
        writer.Flush()

    End Using
End Using

'Convert the MemoryStream to a Byte Array
Dim txn_string As String = encoder.GetString(txn.ToArray()).Replace(" />", "/>")
Dim xml_bytes() As Byte = encoder.GetBytes(txn_string)

public void sendemail(int MemberId, DataTable Member, int rowNo)
        {
            MailMessage msgMail = new MailMessage();

            msgMail.To = Member.Rows[rowNo]["EmailID"].ToString();
            msgMail.From = "admin@auditionbollywood.com"; 
            msgMail.Subject = "Auditions BollyWood Account Expire";
            msgMail.BodyFormat = MailFormat.Text;
            StringBuilder sb = new StringBuilder();
            sb.AppendFormat("Hi !\n\n");
            sb.AppendFormat("Your Audition Bollywood Account has been expired.Please pay the payment for activation.\n");
            sb.AppendFormat("Click the below link to pay to activate your account\n");
            string link = string.Format("http://www.auditionbollywood.com/paymentrenewal.aspx?MemberId={0}", MemberId.ToString());
            sb.Append(link);
            sb.AppendFormat("\n\nThank You");
            msgMail.Body = sb.ToString();
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserver", "mail.auditionbollywood.com");
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", 587);
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusing", 2);
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1");
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "admin@auditionbollywood.com");
            msgMail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "**********");
            SmtpMail.SmtpServer = "mail.auditionbollywood.com";
            SmtpMail.Send(msgMail);
        }

public void ExportToExcel(DataTable dataTable)
{
		string filename = "Report.xls";
		StringWriter tw = new System.IO.StringWriter();
		HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); 
		DataGrid dgGrid = new DataGrid();
		dgGrid.DataSource = dataTable;
		dgGrid.DataBind();
		dgGrid.RenderControl(hw);
		HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
		HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); 
		HttpContext.Current.Response.Write(tw.ToString());
		HttpContext.Current.Response.End();
}