Sending a data collection report as an email body

my problem here is this:
When you click on a button my program have to send a email where a report must be generated from table adapters from dataset. Now this report is not going to be displayed when the button is clicked, so it will be sent automatically by code which I have some part(see below). My questions are:
1. how can you generate or build a report without displaying it.
2.embeed this report or data collection from the table adapters as part of the body of the email


my email code so far is this:
mail.From = New MailAddress("qwerty@qwerty.com")
mail.To.Add(New MailAddress("qwerty@qwerty.com"))
mail.Subject = "test"
mail.Priority = MailPriority.Normal
Dim smpt As New SmtpClient
smpt.Host = "smtp.live.com"
smpt.Port = 25
 smpt.Credentials = New System.Net.NetworkCredential("qwerty@qwerty.com","****")) 'hehe not telling :P< ...