how send datatable's data by email

i want to email all the data from a datatable from another form.
is there a way i can get all the data at once?
and if I want to sortorder the date in the datagrid, what should I put in the query builder??

Code:

---

Private Sub emailbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles emailbtn.Click


        Dim message As New EmailMessage
        message.Subject = "test email"
        message.BodyText = ' all data here<<<<

        Dim client As New Recipient("ABD", "[email protected]")
        message.To.Add(client)
        Dim emailsession As New OutlookSession

        emailsession.EmailAccounts("GoogleMail").Send(message)

        MsgBox("email sent")
    End Sub

---

I think you will have to read the datatable and put the contents in the body.

To sort on a Sql retrieval use 'order by' - is that what you mean?

Quote:

---

Originally Posted by petevick

I think you will have to read the datatable and put the contents in the body.

To sort on a Sql retrieval use 'order by' - is that what you mean?

---

i mean (for example. search in a table would be : LIKE @lastname +'%')

so what do I put on the " sort by " to achieve sort according to date?

order by mydatename

SELECT [Recorded date], [Food Intake], Image
FROM foodjournal
ORDER BY [Recorded date] DESC

this is what i put, but it doesnt seems to work.

Do you get a syntax error, is it not sorted - how does it not seem to work??

Try the same syntax on the device in query analyzer

Quote:

---

Originally Posted by petevick

Do you get a syntax error, is it not sorted - how does it not seem to work??

Try the same syntax on the device in query analyzer

---

ok ...i done it...just a little bit of mistake...

back to the read datatable question...
i am trying to use sqldatareader to read them.

so that means i need to establishing the connection right?
and i wonder what is the data source equals to? my filepath for the .sdf file?

is this the connection string correct?

Code:

---

myConnection = New SqlConnection("Data Source=" & "Initial Catalog=appdatabase1;" & _
    "Integrated Security=SSPI")

---

Surely you have filled the datatable from the database - do you now not just want to read the datatable?

Quote:

---

Originally Posted by petevick

Surely you have filled the datatable from the database - do you now not just want to read the datatable?

---

yes, sure I filled the table. but what I mean by reading the data is not displaying them in the grid.

as my initial question was to send those data out by email, so I need to read those data and put it in a string variable. then send it out by email right?

Why not just read from the database, construct a string, and email the string?

Quote:

---

Originally Posted by petevick

Why not just read from the database, construct a string, and email the string?

---

isnt this just same as what i try to do??

So what is the datagrid all about then?

Quote:

---

Originally Posted by petevick

So what is the datagrid all about then?

---

it is because I have this datagrid on form1 and I enter data there...

then I wanted to read all that data from that grid and send it out on form2

So now I am totally confused - where does the datatable and SQL come into things.

You can process the grid by reading each row and column in turn, and appending to a string.