How to display Sql data in a Gridview display manner in a EMAIL

Hey


I would like to know if someone can please help me ..I need to send  emails out to  Companies  and provide them with a list of their Product  Purchase history data.....


Ok so what I would like to know is ...how do I display sql data results in my email's Html body section ...so that the data results look like a gridview dataview



data results retrieve from a SQL query and then should go in HtmlBody of email..example


To Company:        Inkjet 24/7 Shop

Body of email:     Laptop     x1   $ 200
                           Hard Drive   x2    $30
            &n ...