如何通过电子邮件以网格/表格形式发送VB.Net DataGridView信息



在VB.Net[使用Microsoft Visual Basic 2010学习版]中,任何人都能帮助我了解如何使用VB.Net通过电子邮件发送DataGridView[记录/数据已从数据库中提取]信息吗?我可以发送带有DataGrid信息的电子邮件,但不能以Grid/Table形式发送。以下是示例代码:

Private Sub btnGUIEmail_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGUIEmail.Click
    Dim html As String = String.Empty
    Dim Mail As New MailMessage
    mail.Subject = "test email"
    mail.To.Add(TextBox2.Text)
    mail.From = New MailAddress("X@gmail.com")
    Dim strAccount_No, strClient_Name As String
    Dim i As Integer
    For i = 0 To DataGridView1.Rows.Count - 2
     strAccount_No = DataGridView1.Item(0, i).Value.ToString
     strClient_Name = DataGridView1.Item(1, i).Value.ToString
      strMailBody += strAccount_No & "     " & strClient_Name & vbCrLf
        Mail.Body = strMailBody
     Next
   Dim SMTP As New SmtpClient("smtp.X.com")
    SMTP.EnableSsl = True
    SMTP.Credentials = New System.Net.NetworkCredential("X@gmail.com", "X")
    SMTP.Port = "587"
    SMTP.Send(Mail)
    MsgBox("Email Sent")

End Sub

在VB.Net〔使用Microsoft Visual Basic 2010学习版〕中,有人能帮助我了解如何使用VB.Net通过电子邮件发送DataGridView〔记录/数据已从数据库中提取〕信息吗?我可以发送带有DataGrid信息的电子邮件,但不能以网格/表的形式发送。下面是示例代码:

如果您想以表格格式发送,您必须使用表格标记以html格式创建信息。

例如

mail.BodyFormat = MailFormat.Html
mail.Body = "this is my test email body.<br><b>this part is in bold</b>"

只需浏览以下链接,它可能会帮助你了解如何?

http://www.emailarchitect.net/easendmail/kb/vbnet.aspx?cat=6

http://www.aspsnippets.com/Articles/Create-and-send-HTML-Formatted-Emails-in-ASP.Net-using-C-and-VB.Net.aspx

我希望它能帮助你

最新更新