ASP.NET

Imports System.Data.Entity
Imports System.Collections.Generic
Imports System.ComponentModel.DataAnnotations
Imports System.Data.Entity.Infrastructure

Namespace Models

    Public Class Customer_Accounts

        Public Property ID As Integer
        Public Property Advanced As Boolean
        Public Property AccountName As String
        Public Property FirstName As String
        Public Property LastName As String
        Public Property EmailAddress As String
        Public Property Password As Byte
        Public Property PasswordSalt As Byte
        Public Property PhraseHint As String
        Public Property PhraseAnwser As String
        Public Property DateOpened As DateTime
        Public Property Lockout As Boolean
        Public Property LastLogin As DateTime
        Public Property IPAddress As String

    End Class

End Namespace

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data.Entity;
using System.Linq;
using DataAccessLibrary.Models;

namespace DataAccessLayer.Models
{
    /// <summary>
    /// Class Customer.
    /// </summary>
    public class Customer : EntityBase, IValidatableObject
    {
        #region Public Constructors

        /// <summary>
        /// </summary>
        public Customer()
        {
            SalesOrders = new ObservableListSource<SalesOrderHeader>();
            Addresses = new ObservableListSource<CustomerAddress>();
        }

        #endregion Public Constructors

        #region Public Properties

        /// <summary>
        /// Gets or sets the addresses.
        /// </summary>
        /// <value>The addresses.</value>
        [Description("List of addresses for this customer")]
        public virtual ObservableListSource<CustomerAddress> Addresses { get; set; }

        /// <summary>
        /// Gets or sets the name of the business.
        /// </summary>
        /// <value>The name of the business.</value>
        [Description("This customer's business name.")]
        [DisplayName("Business Name")]
        [StringLength(45)]
        [Index(IsUnique = true)]
        public string BusinessName { get; set; }

<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();
}